Version (Updated August 9, 2010)

Rating:        Based on 8 ratings
Reviewed:  8 reviews
Downloads: 5759
Change Set: 58835
Released: Apr 6, 2010
Updated: Aug 29, 2010 by ErikEJ
Dev status: Stable Help Icon


application, 786K, uploaded Aug 29, 2010 - 3324 downloads
application, 35K, uploaded Aug 10, 2010 - 794 downloads
application, 37K, uploaded Aug 10, 2010 - 491 downloads
application, 33K, uploaded Jun 24, 2010 - 234 downloads
application, 27K, uploaded Aug 9, 2010 - 345 downloads
application, 35K, uploaded Aug 10, 2010 - 571 downloads

Release Notes

This release contains 6 downloadable files:
- SSMS 2008 scripting add-in (for SQL Compact 3.5) -
- SQL Server 2005/2008 command line utility to generate a SQL Compact compatible script with schema and data (or schema only) -
- SQL Compact 4.0 command line utility to generate a script with schema and data -
- SQL Compact 3.5 command line utility to generate a script with schema and data -
- SQL Compact 3.1 command line utility to generate a script with schema and data -
- SqlCeScripting .NET library (for SQL Compact 3.5), for easy inclusion of scripting in your own application -

New features in SSMS add-in:
- Support for SQL Server 2008 R2 RTM
- "Script Server Database" menu item added - script SQL Server 2005/2008 tables and constraints in SQL Compact T-SQL dialect
- "Schema and Data with BLOB files" output option added to "Script Database" and "Script Server Database" menus. (contrib gabrielhausmann)
- "Show Table Data" - added context menu to Image cells, to enable Import, Export and Delete of images.
- "Show Table Data" - grid now supports sorting
- "Show Table Data" - added "Reload" button to refresh data
- Added context menu item to Indexes to DROP and CREATE. Also to script index statistics.

New features in command line utilities:
- All 3 command line utilities now support the optional "schemaonly" and "saveimages" options (see the Documentation tab for details) (contrib gabrielhausmann)

Revision changes:
- No scripting of indexes based on XML columns and calculated columns
- Added errorlevel to exportsqlce/export2sqlce
- Bug: Missing V35 constant during build caused IDENTITY columns to be ignored

Revision changes:
- Separate scripting library released
- ExportSqlCe31.exe now built for x86 instead of Any CPU
- Improved support for foreign keys (Generator, contrib jvans)
- Improved support for server IDENTITY colums that are not int or bigint (ServerDBRepository, contrib jvans)
- Conversion of newsequentialid() default to newid() (ServerDBRepository)
- Conversion of getutcdate() default to getdate() (ServerDBRepository)
- Merge releated tables are no longer scripted (ServerDBRepository)
- Improved error handling (SqlCeScripter)

Revision changes:
Primary key constraint names not scripted (Generator) (contrib mvockerodt)
NullReference bug (ServerDBRepository) (contrib mvockerodt)
Columns in foreign keys were not ordered correctly (ServerDBRepository) (contrib mvockerodt)
Columns in foreign keys where given two brackets (Cannot resolve the wiki link macro, length of title is too long. to avoid problems (Generator, contrib gabrielhausmann)
Export2SqlCE: Disabled constraints were exported and caused problem when data included in export (Generator, contrib gabrielhausmann)
Export2SqlCE: Disabled indexes were exported (Generator)
Export2SqlCE: Identity columns got wrong AutoIncrementNext. Had the last used value, not the next available. (Generator, contrib gabrielhausmann)

Improved import error handling (add-in)
No menu items will be shown if "Mobile Device" database opened (add-in)

Reviews for this release

Excellent. These tools should be incorporated automatically.
by Telavian on Oct 13, 2010 at 5:25 AM
Very useful project. Works very well and integrates nicely with SQL Server Management Studio. Thank you very much.
by alxtkr on Oct 4, 2010 at 12:30 PM
I found that there are no useful database low cost conversion programs for sql compact to sql server (express) - this addin helps a great deal. I open the sqlce database in MS SQL Server Management Studio and & use this addin's script create table (and subsequently data insert) to create scripts for database rcreation and migration.
by TimFlanders on Aug 9, 2010 at 9:20 AM
Looks like this will be very helpful
by bdoc7cp on Jul 26, 2010 at 7:52 PM
Wow, this really simplifies my life! I love the table view of data, and it's so easy to create scripts by table for the database structure and data, to port it somewhere else, as long as you don't have too many tables.
by dburson on Jul 8, 2010 at 3:31 PM
Very good. Is it possible to script all constraints?
by xgeneratorx on Jul 5, 2010 at 2:03 PM
excellent, does exactly what I needed with minimal fuss
by markheath on May 21, 2010 at 10:09 AM
This is very nice one. Thanks dude super helpfull for me.!!!
by Gordon2001 on May 8, 2010 at 12:38 PM