dbForge Studio for SQL Server 5.4.211

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.