dbForge Studio for SQL Server v5.5 release notes

SQL Server support

  • SQL Server 2016 Service Pack 1 (SP1) new syntax support
  • SQL Server 2017 CTP2.0 new syntax support
  • Azure SQL Data Warehouse connectivity support

Code Completion

  • Column match highlighting in the INSERT statement
  • Database element dropping from the prompt in Completion List
  • Possibility to exclude a scheme in the ON condition of the JOIN statement
  • Possibility to connect/disconnect when describing/pre-describing objects of the same database
  • Query surfing
  • CASE END highlighting
  • Extended prompting in the PIVOT/UNPIVOT queries
  • Extended support for CTE
  • Prompt and QI of variables in named transactions
  • Support for CREATE OR ALTER

    SQL Document

  • Query execution history Data Compare
  • Static Data comparison in Script Folder
  • Support for MASKED columns
  • Option to automatically select a key for comparing objects without a suitable unique key
  • Added option to turn ON\OFF Generation of IF NOT EXISTS on inserting
  • Possibility to open the comparison wizard instead of the comparison autorun when opening the dcomp files

    Schema Compare

  • Support for External Objects
  • Support for MASKED columns
  • Azure v.12 Extended Support
  • Support for SECURITY POLICY object
  • Support for Column Encryption Keys
  • Support for Column Master Keys
  • Extended support for comparison of SQL Server 2014-2016 backup files
  • New Database creation through Schema Comparison Master
  • Redesigned logging in command line
  • Possibility to open the comparison wizard instead of the comparison autorun when opening the scomp files

    Documenter

  • Generation of documentation in the Markdown format.

    Data Generator

  • Storing custom generators
  • Generating data by time
  • Generating data to already available data
  • Generating data by a linked table
  • Pre and Post Script Execution

    Source Control

  • Added authentication capability for VS Online
  • TFS 2017 support
  • SourceGear Vault v9.1 support
  • SourceGear Vault v10.0 support
  • Surround SCM support

    Index Manager

  • The Command Prompt provides scan results of index analysis including index name, reason, and fragmentation.

Connectivity

  • Each file creates its own connection
  • Password change on expiry
  • Keyboard shortcut for selecting connection and database assigned Activity Monitor
  • Possibility to monitor CPU and memory utilization
  • Table of data IO
  • Displays information about waits, including its type, resource, a number of waits on this wait type, and more
  • Database metrics
  • Query profiling with top operations and plan in XML format
  • Information about active sessions and database backups

    Other improvements

  • Command-Line Master
  • Generate Script As redesigned
  • Express Edition extended with ability to manage table partition

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?