Project DescriptionThis console app and SQL Server 2008 Management Studio add-in helps you better manage your SQL Compact development efforts. If 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.
For more SQL Compact news and tips, visit my blog at
http://erikej.blogspot.com
SQL Server Management Studio 2008 (Express) add-in - new release 2.2 (Oct. 24 2009)
ExportSqlCE is also available as 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
- Script Table as
- Import Data from CSV
- Rename
It also adds the menu item "Script Database" to the database context menu:
Command line utility
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.
The project now uses the EQATEC Analytics Service at
http://analytics.eqatec.com for monitoring.
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