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

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?