This release contains 6 downloadable files:
- SSMS 2008 scripting add-in (for SQL Compact 3.5) - ExportSqlCE_Addin.zip
- SQL Server 2005/2008 command line utility to generate a SQL Compact compatible script with schema and data (or schema only) - Export2SqlCE.zip
- SQL Compact 4.0 command line utility to generate a script with schema and data - ExportSqlCE40.zip
- SQL Compact 3.5 command line utility to generate a script with schema and data - ExportSqlCE.zip
- SQL Compact 3.1 command line utility to generate a script with schema and data - ExportSqlCE31.zip
- SqlCeScripting .NET library (for SQL Compact 3.5), for easy inclusion of scripting in your own application - SqlCeScripting.zip
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 3.0.0.6 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 3.0.0.4 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 3.0.0.2 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)
Other:
Improved import error handling (add-in)
No menu items will be shown if "Mobile Device" database opened (add-in)