I'm interested in some of the questions raised about SQL Server Compact Edition, I've been using SQL Server Express edition to process a subset of data from our main dataware house server to the local desktop.
However its not easy copy data (unlike previous versions which contained DTS - MSDE) , at the moment its a matter or creating a linked server and using SELECT/INSERT method, not a great way.
Plus the restricted 4Gbyte of data, thou this doesnt apply to tempdb (does this exist in SQL Server CE??), thou you can create several databases splitting the data into each database and then create a view joining all the required data as a way around this.
I do like the sound of SQL Server CE, great for those offline client applications.
re: "does this exist in SQL Server CE??"
Hi Ron,
SQL Server CE does not allow splitting a database into multiple disk files. You can have only one database file per database.
Jacob
oops, sorry I didnt explain.
create 2-3 databases, e.g. DatabaseA, DatabaseB & DatabaseC.
partition the required data into 3 tables splitting the data equally into DatabaseA, DatabaseB & DatabaseC. Create a View in DatabaseA which contains the tables created in DatabaseA, DatabaseB & DatabaseC. This should solve the 4Gigabyte limit, a bit messy to say the least....bill remove that 4Gigabyte limit !!!
that would not work with SQLCE.
It does not support views.
One of the biggest difference between MS Access and SQLCE is that ACCESS is a standalone application and SQLCE is a set of IN-PROCESS dlls that will get embedded to your application. Further, it supports Mobile and Desktop platforms.
Regarding Stored procedures: Steve Lasker, Program Manager of SQLCE at Microsoft has a detailed explanation in his blog (http://blogs.msdn.com/stevelasker/archive/2007/05/14/empowering-your-users-with-reference-data-and-knowledge.aspx)
