What’s New in dbForge Studio for SQL Server, v5.4

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