.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh

Home >> Technology News >> General >> Post New Resource Bookmark and Share   

 Subscribe to Tech News

SQL Server Compact Toolbox

Posted By:Maverick       Posted Date: July 05, 2011    Points: 25    Category: General    URL: http://www.dotnetspark.com  

SQL Server Compact Toolbox 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
- Launch directly from Server Explorer
- 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
Other features:
- Rename tables
- Generate detailed DGML files for visualizing table columns and relationships (requires VS 2010 Premium or higher to view)
- 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)
- Generate an Windows Phone DataContext (.cs) in the current project
- Add object description to databases, tables and columns
- Remove invalid connection definitions from the Toolbox (and Server Explorer)
- Create and manage SQL Server Merge Replication subscriptions
- Data types node with documentation tooltips lists the 18 available data types
- File version check (for version 2-4)
- Upgrade version 3.x files to version 4 via the "Add version 4 connection" dialog
- About dialog with detailed SQL Server Compact version information

For support, full source code, a standalone version for 4.0 and feedback, go to: http://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: http://exportsqlce.codeplex.com

New in version 2.2:
- Menu option to generate an Windows Phone DataContext (.cs) in the current project (in beta)
- Menu option to add Description to tables and columns
- Descriptions or name shown as Tooltip on tables and columns
- Improvements to Db Diff script
- Options dialog for saving options from session to session
- New options available via new Options dialog:
* Include DROP in Db Diff script
* Display query results in DataGrid (SQL editor)
* Display binary result as a hex string (SQL editor)
* Show Descriptions Table in Treeview
- Save script (SQL editor)

Fixes in
- Execution of multiple statements with GO was broken



 Subscribe to Tech News


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Technology News Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend