I have a few basic questions on SQL Compact - and hope I can get some clarification.
There seems to be a few difference versions that are referenced. SQL Compact 3.5
SQL Compact 2005 and SQL 2008 Compact? What is the correct name of the current product?
2. Visual Studio 2008 compatibility.
Which one(s) will Visual Studio 2008 happily work with.
4. Size limitation.
It seems that there is a 4GB size limitation. I assume that is the total sum of all
tables or is that a single table. What happens if I want to go larger than that
can I say create a new instance etc. Please clarify.
5. Remote access.
Do these allow for any form of remote connectivity. Can say 2 remote machine
connect to a SQL Compact database - what are the limits here?
Is there an program I can use outside of Visual Studio to manage these.
7. Future Direction.
Can I assume from what I am reading that this is way we should be developing in
the future. So it is like the replacement for desktop databases (a jet replacement)?
Any help much appreciated - hope I have not exceeded my question limit :)
View Complete Post