[Visual Studio Extension Of The Day] SQL Server Compact Toolbox
SQL Server Compact Toolbox is an add-in for Visual Studio 2010. Supports SQL Server Compact version 3.5 and 4.0.
Adds several features in concert with Server Explorer to help your SQL Server Compact development efforts:
- Lists all SQL Server Compact Data Sources defined in Server Explorer
- Displays object properties in Properties window
- Launch directly from Server Explorer
- Explore all database objects: Tables, Columns, Indexes, Keys, Statistics, Merge Subscriptions
Scripting:
- Script tables, including data, both DDL and DML
- Script entire schema, optionally with data, from SQL Server Compact and SQL Server 2005/2008 databases
- Import to SQL Server Compact from a SQL Server 2005/2008 database or a CSV file
- Migrate from SQL Server Compact to SQL Server and SQL Azure
- Migrate from SQL Server to SQL Server Compact
- Create database diff scripts, compare with a SQL Server Compact or even a SQL Server database
Query editing:
- Basic, free form query execution
- Editor with syntax coloring
- Parse SQL scripts
- Display graphical estimated and actual execution plan
- Check query duration
- Edit table data in a grid, with column sorting, image import/export, quick search and free form query
Code generation:
- Generate an Windows Phone DataContext (.cs or .vb) in the current project, optionally split into a file per table (.cs only)- Generate an Entity Data Model (EDMX) in the current project for both 3.5 and 4.0 in any applicable project (WPF, WinForms, Class Library) and create configuration for Private Deployment
Documentation creation:
- Add object descriptions to databases, tables and columns- Generate detailed DGML files for visualizing table columns and relationships (requires VS 2010 Premium or higher to view)
- Generate database documentation in HTML or XML formats, courtesy of DB>doc for Microsoft SQL Server
Other features:
- Rename tables
- File version check (for version 2-4)
- Upgrade version 3.1/3.5 files to version 4.0 via the "Add SQL Server Compact 4.0 Connection" dialog
- Create and manage SQL Server Merge Replication subscriptions
- Data types node with documentation tooltips lists the 18 available data types
- Remove invalid connection definitions from the Toolbox (and Server Explorer)
- About dialog with detailed SQL Server Compact version information
For support, full source code, a standalone version for 4.0 and feedback, go to:https://sqlcetoolbox.codeplex.com
For users not having Visual Studio 2010 Pro or higher installed, an add-in for 3.5 with similar functionality for the free SQL Server 2008 Management Studio Express and also command line versions are available here:https://exportsqlce.codeplex.com
New in version 2.5:
- Selected Database and Table properties displayed in VS properties window
- DGML file (database graph) now also contains object descriptions
- EDMX dialog now allows adding configuration for Private Deployment to app.config
- Added ability to add 3.5 Connections from Toolbox
- Improved VS UI Guidelines compliance: Toolbars, SQL Editor Font, Dialogs (frame, background and buttons)
Download it from Visual Studio Extension Manager