dbForge Studio for SQL Server v5.4 release notes

Schema and Data Comparison

• New comparison options
• Comparison and synchronization of memory-optimized tables
• Command-line interface for the scripts folder comparison
• Database creation right in the Schema Comparison Wizard
• 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 the Excel format
• 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

• Support for 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

• Spatial View - Geometry

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 color in the status bar

Other Improvements

• Support for Power Shell
• Trial product activation
• Greatly improved visual style of the application
• Specific exit codes are added
• Compliance with FIPS
• Support for Azure Active Directory Authentication