Create and manage SQL Server Merge Replication subscriptionsįor support, full source code, and standalone versions for 4.0 and 3.5 (for VS Express and non-VS users) and feedback, go to: - the source code also includes a scripting API and command line versions of many of the features in the Toolbox.SQLite and PostgreSQL are among the most widely used relational database management systems (RDMS).Extensive support for Sync Framework 2.1, including Provisioning, Deprovisioning, Code Generation, Local Database Cache Code Generation and Explorer tree integration.Upgrade version 3.1/3.5 files to version 4.0 in a single step.About box with detailed SQL Server Compact engine version information.Maintain databases: Set password, Verify, Shrink, Compact, Repair (SQLCE), Vaccum, Reindex (SQLite).Data types node with documentation tooltips lists the 18 available data types in SQL Server Compact.Generate database documentation in HTML or XML formats, courtesy of DB>doc for Microsoft SQL Server.Add object descriptions to databases, tables and columns- Generate detailed DGML files for visualizing table columns and relationships (requires VS Community or Pro to view).Full integration with Entity Framework 6.x Tools in VS 2012 and later to enable "EF Designer from Database", "Code First from database" and "Generate Database from Model" workflows for SQL Server Compact 4.0 and SQLite.Generate SQLite based sqlite-net code for use in WinRT, Windows Phone and Universal apps.Generate desktop LINQ to SQL classes for SQL Server Compact 3.5 and 4.0 databases.vb) (for SQLCE 3.5 only) in the current project, with optional ConnectionStringBuilder class Generate Windows Phone LINQ to SQL DataContext classes (.cs or.View table data as a report, with options to page through data, print and export as Excel/Word/PDF.Edit table data in a grid, with column sorting, clever column sizing, image import/export, quick search and free form query.Explore query results with filtering, sorting and grouping.Display graphical estimated and actual execution plan.Basic, free form query execution in editor with syntax coloring, support for large files, and built-in search with result highlighting.Build CREATE TABLE scripts, and Index/Column and Foreign Key scripts from the UI.Create database table data diff scripts, compare with a SQL Server Compact or even a SQL Server database.Create database schema diff scripts, compare with a SQL Server Compact or even a SQL Server database.Migrate from SQL Server or SQLite to SQL Server Compact, either via script or in a single step.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |