Getting Started | Feedback | Report bugs
Release notes
If you have trouble installing the SSMS extension, try the following command line:
"C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\vsixinstaller.exe" "full path to extension.vsix"
The SQL Server Compact & SQLite Toolbox adds several features to help your SQL Server Compact and SQLite development efforts:
Explore!
- Connect to SQL Server Compact 4.0, 3.5, SQL Server and SQLite database files in SQL Server Management Studio 17.x
- Displays object properties in Properties window
- Explore all database objects: Tables, Columns, Indexes, Keys, Views, Triggers, Statistics, Merge Subscriptions, Sync Scopes
- Rename connections and tables
- Copy the database file for example to your project or any other folder
Script/Migrate!
- Script entire schema and/or all data from SQL Server Compact, SQLite and SQL Server databases, and choose tables to script - with high fidelity
- Import to SQL Server Compact or SQLite from a SQL Server database or a CSV file
- Migrate a SQL Server Compact or SQLite database directly to SQL Server (LocalDB/Express)
- Migrate from SQL Server Compact or SQLite to SQL Server, SQL Azure and SQLite via script
- Migrate from SQL Server or SQLite to SQL Server Compact, either via script or in a single step
- Build CREATE TABLE scripts, and Index/Column and Foreign Key scripts from the UI
Query!
- Basic, free form query execution in editor with syntax coloring, support for large files, and built-in search with result highlighting
- Parse SQL scripts
- Display graphical estimated and actual execution plan
- Check query duration
- Explore query results with filtering, sorting and grouping
- Edit table data in a grid, with column sorting, clever column sizing, image import/export, quick search and free form query
- View table data as a report, with options to page through data, print and export as Excel/Word/PDF
Manage versions!
- Database File version check
- Maintain databases: Set password, Verify, Shrink, Compact, Repair (SQLCE), Vaccum, Reindex (SQLite)
- About box with detailed SQL Server Compact engine version information
- Upgrade version 3.1/3.5 files to version 4.0 in a single step
Synchronize!
- Create and manage SQL Server Merge Replication subscriptions
For support, full source code and feedback, go to: https://github.com/ErikEJ/SqlCeToolbox - the source code also includes a scripting API and command line versions of many of the features in the Toolbox.
| |
