SQL Compact import DB from SQL Server Express with Server Management Studio?

SQL Server Compact 3.5 does not support the full SQL Server (non-Compact) DLL/feature set. E.g. Nvarchar(max) is not supported, nor is the ON PRIMARY syntax, since the compact database is stored in a single file Ref.

SQL Server Compact Edition CREATE TABLE: link text.

SQL Server Compact 3.5 does not support the full SQL Server (non-Compact) DLL/feature set. E.g. Nvarchar(max) is not supported, nor is the ON PRIMARY syntax, since the compact database is stored in a single file.Ref.

SQL Server Compact Edition CREATE TABLE: link text.

Thanks. Do you know any possible way to convert DB from SQL Server to SQL Server Compact? Or maybe some set of rules to do this manually?

– Sasha Nov 4 '09 at 10:18 Generally, it's not possible to convert an SQL Server DB to an SQL Server Compact DB, because of the differences in features. If you want to convert/replicate simple tables with data, you could possibly use the SqlCe 3.5 replication feature, that could take care of the type mapping and table creation for you, depending on your source DB of course. Note that there are a number of different options when it comes to SqlCe synchronization with other data sources: technet.microsoft.Com/en-us/library/ms171801.

Aspx – user202474 Nov 5 '09 at 23:32.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.