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

Release 4.2 Visual Studio add-in

Rating:        Based on 2 ratings
Reviewed:  2 reviews
Downloads: 0
Change Set: 94993
Released: Mar 30, 2015
Updated: Jul 20, 2015 by ErikEJ
Dev status: Stable Help Icon

Available Downloads

There are no downloads associated with this release.

Release Notes

Download the release version (4.0) of the Visual Studio add-in for SQL Server Compact 3.5, 4.0 and SQLite from here

SQL Server Compact & SQLite Toolbox 4.2 - Visual Guide of new features

Features in version 4.2

- Use only Server Explorer connections for SQL Server scripting etc.
- Add "Migrate SQLite database to SQL Server" feature (with help from @thughesit
- Added "Truncate SQLite strings" option to improve export to SQL Server success rate
- Add "Export SQL Server to SQLite" feature
- Using version 1.0.96 of SQLite ADO.NET provider

- Add both "Save" and "Save As" to SQL Editor
- Add keyboard shortcut for "Execute" query: F5, Save (Ctrl+S)
and Open (Ctrl+O) to SQL Editor
- Add "Export" first result as CSV option to SQL Editor
- Add ability to execute PRAGMA commands with SQLite

- Migrate to SQL Server no longer blocks UI
- Export from SQL Server no longer blocks UI
- Impossible/very hard to open LocalDB connection with old connection dialog
- Improved formatting of DataAcccess.cs sqlite-net code
- Minimize use of Error Reporting dialog
- Improved initial directory when adding connections
- Improved error information when SQLite datetime parsing errors occur
- Improved error information when SQL Server script execution errors occur
- Now using ExceptionLess for Error Reporting
- Closing the Edit Data grid now closes the connection to the database

Bug fixes:
- Migrate to SQL Server feature was broken
- Merge Replication Subscription creation was broken
- Edit column should not show "Primary Key" column, and not allow editing of column name
- Opening the SQL Editor sometimes crashed VS
- FormatException in Explorer window


I would be very grateful if you post any reviews for the Toolbox here

Reviews for this release

This is a fantastic extension. This has helped me several times in the past with migrating databases and with the added ability to migrate SQLite databases I can now do so much more with it. This extension also has the added benefit of being created by the very dedicated ErikEJ who is willing to work with his users to figure out any problem they may be having and to extend the extensions functionality to its full potential.
by RandomlyKnighted on Mar 14, 2015 at 7:53 PM
Addresses the VS2015 issue. Could use polishing on the tool window for selecting connection and the open or create dialogs should start in the solution root folder instead of the default explorer folder. Other than that, a great release!
by RyanF on Jan 19, 2015 at 2:52 PM