In the upcoming release of the ExportSqlCe project, a new command line utility, named Export2SqlCe, will be included. This command line utility allows you to script all tables and constraints in a SQL Server 2005/2008 database, and the output will be SQL Server Compact compatible T-SQL.
The tool will allow you to move schema and both schema/data from SQL Server to SQL Server Compact.
Currently, the tool will break if any of your tables contains the following SQL Server data type :
sql_variant
If you would like to test the tool, let me know and I can provide you a test build (you can also download the VS 2008 source and build the tool from here.)
No comments:
Post a Comment