SQL Server Compact/SQLite Toolbox的Visual Studio插件：SqlCe35Toolbox
SqlCe35Toolbox 是 Visual Studio 的 SQL Server Compact/SQLite Toolbox 插件，这些插件能帮助你的 SQL Server Compact 开发更高效：数据和表脚本，从 SQL Server 和 CSV 导入数据等等。
The SQL Server Compact Toolbox adds several features to help your SQL Server Compact development efforts:
Explore!
- Connect to SQL Server Compact 4.0, 3.5 and SQLite database files in Visual Studio "14", 2013, 2012 and 2010
- Lists all SQL Server Compact Data Sources defined in Server Explorer
- Scan current Solution for .sdf files, and add these to the Toolbox
- Displays object properties in Properties window
- Launch directly from Server Explorer
- Explore all database objects: Tables, Columns, Indexes, Keys, Statistics, Merge Subscriptions, Sync Scopes
- Remove invalid Data Sources from the Toolbox (and Server Explorer)
- Rename tables
- Copy the database file for example to your project or any other folder
Script!
- Script entire schema and/or all data from SQL Server Compact, SQLite and SQL Server databases, and choose tables to script
- Import to SQL Server Compact from a SQL Server database or a CSV file
- Migrate a SQL Server Compact database directly to SQL Server (LocalDB/Express)
- Migrate from SQL Server Compact to SQL Server, SQL Azure and SQLite via script
- Migrate from SQL Server to SQL Server Compact, either via script or in a single step
- Create database schema diff scripts, compare with a SQL Server Compact or even a SQL Server database
- Create database table data diff scripts, compare with a SQL Server Compact or even a SQL Server database
- 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
- 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
Generate code!
- Generate Windows Phone LINQ to SQL DataContext classes (.cs or .vb) (for 3.5 only) in the current project, with optional ConnectionStringBuilder class
- Generate desktop LINQ to SQL classes both for 3.5 and 4.0 databases
- Generate an Entity Framework 4.x (VS 2010) or 6 (VS 2012/2013) Entity Data Model (EDMX) in the current project for both SQL Server Compact 3.5 & 4.0 in any applicable project (WPF, WinForms, Class Library) and create configuration for Private Deployment (VS 2010)
- Generate SQLite based sqlite-net code for use in WinRT, Windows Phone and Universal apps
- Full integration with Entity Framework 6.x Tools in VS 2012 and VS 2013 to enable "EF Designer from Database", "Code First from database" and "Generate Database from Model" workflows
Document!
- Add object descriptions to databases, tables and columns
- Generate detailed DGML files for visualizing table columns and relationships (requires VS 2010 Premium/VS 2012 Pro /VS 2013 Pro or higher to view)
- Generate database documentation in HTML or XML formats, courtesy of DB>doc for Microsoft SQL Server
- Data types node with documentation tooltips lists the 18 available data types
Manage versions!
- Database File version check
- Maintain databases: Set password, Verify, Shrink, Compact, Repair
- 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!
- Extensive support for Sync Framework 2.1, including Provisioning, Deprovisioning, Code Generation, Local Database Cache Code Generation and Explorer tree integration
- Create and manage SQL Server Merge Replication subscriptions
For support, full source code, and standalone versions for 4.0 and 3.5 (for VS Express and non-VS users) and feedback, go to:http://sqlcetoolbox.codeplex.com
Command line versions and related Scripting API are available here: http://exportsqlce.codeplex.com
