Released: Apr 8, 2021

Updates in V6.0.383

Features

• Improved date and time formats for data editor.
• Added an option for enclosing identifiers within square brackets when generating scripts.

Fixes

• ALTER for views was generated incorrectly.
• Error with duplicating the max size for varchar, nvarchar, and varbinary when generating CREATE.
• Critical error when reading metadata for an external table.
• Error with processing a procedure during synchronization.
• Temporary Schema Compare synchronization script files duplicated in Recent Files.
• Error...

Released: Feb 25, 2021

Updates in V6.0.330

Fixes

• Error with loading the application with certain OS.

Released: Feb 23, 2021

Updates in V6.0.237

Features

The DevOps Automation feature

• dbForge Studio for SQL Server now performs DevOps Automation. On the start page, in the DevOps tab, links have been added to install the following plugins:
  • Plugin for Jenkins.
  • Plugin for TeamCity.
  • Plugin for Azure DevOps.
  • Plugin for Bamboo.
  • PowerShell module helps organize database DevOps processes for your Microsoft SQL Server databases. It allows you to develop, source-control and safely automate the deployment of database changes using dbForge for SQL...

Released: Jun 2, 2020

Updates in V5.8.127

Fixes

• Fixed problem with Generate Script As on SQL Server 2019.
• Fixed problem connecting to azure managed instance.
• Fixed problem with freezing on refresh Source Folder.
• Fixed problem displaying comparison result.
• Other User-reported bugs are fixed.

Released: Oct 10, 2019

Updates in V5.8.107

Features

• Data Compare improvements
  • Redesigned data compare control.
  • Redesigned data comparison report window.
  • Redesigned data comparison report in CSV.
• Schema Compare improvements
  • Object filter.
  • Redesigned objects text diff control.
  • Redesigned schema comparison report window.
  • Redesigned schema comparison report in HTML.

Fixes

• Problem with execution of push command is fixed.
• Problem with virtual relation on database diagram is fixed.
• Problem with constraint renaming is fixed.
• Problem with data...

Released: Feb 20, 2019

Updates in V5.7.31

Features

• Improved comparison performance.
• Added support for Active Directory - Universal with MFA (Multi-factor authentication).

Fixes

• Problem with column order is fixed.
• Problem with error messages is fixed.
• Problem with lost user shortcuts is fixed.
• Problem with check constraints is fixed.
• Problems with drag and drop several tables to diagram are fixed.

Released: Nov 21, 2018

Updates in V5.6.62

Features

• Full connectivity support for SQL Server 2019.
• Support for TFS 2018.
• Foreign Key Generator - dbForge Studio for SQL Server now provides users with the ability to generate values for a group of unique table columns.

Released: Jan 9, 2018

Updates in V5.5.327

Fixes

• Random crashes during work fixed.
• Exception on application launch fixed.
• Documenter issue with PDF export fixed.
• Data Editor and Viewer issue fixed.
• Issue with documents session restore fixed.
• 'Index 301 is either negative or above rows count' error message fixed.
• Exception when working on closed connection fixed.

Released: Sep 13, 2017

Updates in V5.5.279

Features

SQL Server support

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

Code Completion

• Column match highlighting in INSERT statements.
• Database element dropping from the prompt in Completion List.
• Exclude a scheme in the ON condition of the JOIN statement.
• Connect/disconnect when describing/pre-describing objects of the same database.
• Query navigation.
• CASE END pairs highlighting.
• Extended...

Released: Feb 1, 2017

Updates in V5.4.211

Features

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...