SQL Compact data and schema script utility

Project Description
This console app and SQL Server 2008 Management Studio add-in helps you better manage your SQL Compact development efforts. It allows you to script schema and data to a .sql file, which can be used in any context. It also scripts DML for use in SSMS scripts.

You can use the resulting script for documentation, programmatic scripting of SQL Compact database files, or migration of schema and data to SQL Server (Express) 2005 or later.

Notice that a similar add-in for Visual Studio 2010 (Pro or higher) for SQL Compact 3.5 and 4.0 is now available here

New features in release 3.5

• The command line utilities and scripting library also works with SQL Server Compact 4.0 CTP
• Support for export to SQL Azure (batching, primary keys before data, no ROWGUIDCOL)

For more SQL Compact news and tips, visit my Blog

SQL Server Management Studio 2008 (Express) add-in

ExportSqlCE is a command line application and a SQL Server 2008 Management Studio (Express) add-in.
The add-in adds the following menu items to the table context menu in Object Explorer:
- Show Table Data (browse, sort, edit, import/export/delete images, refresh data)
- Script Table as CREATE, DROP, SELECT, INSERT, UPDATE, DELETE and INSERTs (data) to New Query Editor Windows/File/Clipboard
- Import Data from CSV
- Rename



It also adds the menu items "Script Database" and "Script Server Database" to the database context menu:



Command line utilities

Credits

The project is based on the work by Bembeng Arifin published here: http://bembengarifin-tech.blogspot.com/2008/08/generate-script-export-data-from-sql-ce.html.

Also see Related projects for other credits.

The following features/changes have been added after version 1.1:
CREATE TABLE now uses nchar and nvarchar
CREATE TABLE supports ROWGUIDCOL property
GO added after each statement
Unicode supported
Using image/rowversion in INSERTs
Using IDENTITY columns (using SET IDENTITY INSERT)
Numeric fraction and precision
INSERT statement improvements
Support for rowversion
Support for foreign keys with multiple fields
Handle merge replicated databases
Handle large tables
Support for SQL Compact 3.1
Includes Update and Delete Rules on Foreign Keys
SSMS add-in