This project has moved and is read-only. For the latest updates, please go here.

Version 3.5.2 (legacy)

Rating:        Based on 8 ratings
Reviewed:  7 reviews
Downloads: 26988
Change Set: 102692
Released: Jan 30, 2012
Updated: Jan 2, 2014 by ErikEJ
Dev status: Stable Help Icon


application, 510K, uploaded Jan 30, 2012 - 11692 downloads
application, 195K, uploaded Aug 31, 2013 - 5086 downloads
application, 201K, uploaded Aug 31, 2013 - 4354 downloads
application, 212K, uploaded Aug 28, 2013 - 2269 downloads
application, 204K, uploaded Aug 31, 2013 - 1116 downloads
application, 293K, uploaded Aug 24, 2013 - 2471 downloads

Release Notes

This release contains 6 downloadable files:
- SSMS 2008 scripting add-in (for SQL Server 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 Server Compact 3.5 and 4.0), for easy inclusion of scripting in your own application

Improved SSMS add-in:
-Using latest scripting API

New and improved features in command line utilities:
- ability to exclude tables from being scripted - "exclude" switch
- scripting of Windows Phone Linq to SQL DataContext - "wpdc" switch
- new "dataonly" command line switch
- "dgml" script now contains object descriptions
- SQL Server Export: support for HierarchyId

Changes in release
- BREAKING: All command line utilities now depend on .NET 4.0
- BREAKING: All Solution upgraded to VS 2010
- Tables are now sorted by topological sort
- Fix: Improved script comments handling
- Fix: DataContext - Avoiding duplicate indexes on Primary Keys

Changes in release
- Improved handling of tables with . in their name
- DGML: Inlcudes schema name, no .sql files generated
- date and datetime2 always converted to datetime

Reviews for this release

Great tool. However it appeared to generate some invalid SQL when exporting data to SQL Server with identity columns: "ALTER TABLE [MyTable] ALTER COLUMN [MyID] IDENTITY (1,1)" instead I had to use: "DBCC CHECKIDENT (MyTable, RESEED) WITH NO_INFOMSGS " for each of the processed tables
by sejackson on Nov 8, 2013 at 2:31 PM
This is fixed in the latest update
Reply by ErikEJ (N/A) on Jan 24, 2014 at 10:12 AM
Fantastic utility with easy to use features! Awesome.
by fuzhaoz on Oct 29, 2013 at 2:54 AM
It helped me. Thanks!
by w1ld on Sep 11, 2013 at 3:08 PM
Awesome has been an essential piece of the project
by hansbarr on Jan 17, 2013 at 7:02 PM
I just used the ExportSqlCe.exe tool from the command line. It worked like a charm. Thanks to thanks a lot for this Erik and Chris.
by Chukwuemeka on Sep 13, 2012 at 5:57 PM
Error missing assembly QuickGraph
by nmohamed on Jul 23, 2012 at 4:03 AM
I did not use it yet
by youness_casa18 on Jun 28, 2012 at 11:25 AM