特性
Schema and Data Comparison
- New comparison options.
- Comparison and synchronization of memory-optimized tables.
- Command-line interface for the scripts folder comparison.
- Extended comparison reports functionality.
- Support for SECURITY POLICY objects.
- Data comparison and synchronization of system-visioned tables.
Query Profiler
- Live query statistics.
- Wait Stats tab.
- Saving/Opening execution plan files.
- Table I/O.
- Highlighting potentially resource-intensive statements.
- Displaying clustered columnstore indexes in execution plan.
Data Export/Import
- Dramatically improved data import performance.
- Export/import of JSON data.
- Redesigned export/import of XML data.
- Preview of the generated UPDATE script in the wizard.
- Detection of column types when importing data from Excel.
- Execution of SET IDENTITY_INSERT ON when the Repopulate option is enabled during data import.
Data Generator
- Generation of country-specific data.
- The ISJSON function in Check Constraint generator.
- 10+ new generators, including ICD-10 Codes.
- Data generation for databases already filled with data.
- Improved DateTime generators.
Database Documenter
- Now you can optimize generation of database documentation with help of the command-line interface.
Source Control
- Defining object file name format in Source Control and Scripts Folder creation.
- Creation of the script folder via the command-line interface.
Data Viewer and Editor
- New Spatial View - Geometry, that helps to visualize spatial geometry data.
SQL Document
- CTRL+W shortcut for closing current tab.
- Opening new tabs next to current one.
- CTRL+N shortcut for opening new SQL window with inherited server and database of the current window.
- Showing the connection coloring in the status bar.
Other Improvements
- Support for PowerShell.
- Trial product activation.
- Greatly improved visual style of the application.
- Specific exit codes added.
- Compliance with the Federal Information Processing Standard (FIPS). FIPS is a United States Government standard that provides a benchmark for implementing cryptographic software.
- Connection to MicrosoftAzure SQL Database by using identities in Azure Active Directory.
用于高效数据库开发的 SQL Server IDE。
自 2005 的官方分销商