Friday, January 15, 2010

Coming soon – script SQL Server 2008 (and 2005) databases for SQL Compact

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.

image 

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: