dbForge Studio for SQL Server Releases

Released: Sep 12, 2022

Updates in V6.3.9

Features

  • Microsoft SQL Server 2022 - Added support for:
    • 'ALTER DATABASE SCOPED CONFIGURATION'.
    • 'ALTER INDEX'.
    • 'ALTER TABLE'.
    • 'CREATE CLUSTERED INDEX'.
    • 'CREATE INDEX'.
    • 'CREATE TABLE'.
  • Added query hints for 'DELETE', 'INSERT', 'SELECT', 'UPDATE' and 'MERGE' statements.
  • Added support for 'BACKUP SYMMETRIC KEY' syntax construct.
  • Added support for 'RESTORE SYMMETRIC KEY' syntax construct.
  • Added support for 'DATE_BUCKET' function in Completion List, Quick Info and Parameter Information.
  • Source Control...

Released: Jul 20, 2022

Updates in V6.2.52

Fixes

  • Fixed an error that occurred when displaying database schema synchronization script.
  • Fixed an error that occurred when switching between the pages of the Link Database to Source Control wizard.
  • Fixed an error that occurred when connecting to the Azure server.
  • Fixed an issue with hinting objects in the CROSS APPLY context.
  • Fixed an issue with generating a Scripts Folder.
  • Fixed a false positive syntax check error.
  • Fixed an unexpected exception that occurred when dragging and dropping...

Released: Jun 17, 2022

Updates in V6.2.22

Features

  • Added support for new functions in 'Completion List', 'Quick Info', and 'Parameter Information': GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID.'
  • Added support for the FORMATFILE_DATA_SOURCE parameter for 'bulk_options' in OPENROWSET function.
  • Improved support for the comparison of Microsoft SQL Server 2014-2019 backup files.
  • Improved server connection behavior to avoid blocking connected databases.
  • Improved behavior of wildcard-aided searches in a Schema Compare document...

Released: Dec 21, 2021

Updates in V6.1.14

Features

  • Added support for Execution step in Jenkins, TeamCity, and Bamboo plugins.
  • Added support for UPDATETEXT, SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE, and SEMANTICSIMILARITYDETAILSTABLE functions.
  • Added check constraint hints for ALTER TABLE statements.
  • Added support for WAIT_AT_LOW_PRIORITY option for ALTER TABLE ... SWITCH PARTITION statements.
  • Added DISTRIBUTED_AGG hint for SELECT - GROUP BY queries.
  • Added keyword suggestions for ALTER/DROP DATABASE SCOPED CREDENTIAL statements...

Released: Oct 20, 2021

Updates in V6.0.563

Fixes

  • The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update.

Released: Sep 10, 2021

Updates in V6.0.560

Features

  • Added the ability to simultaneously connect to Microsoft Azure SQL Server with different ApplicationIDs.
  • Added the ability to connect with Multi-Factor Authentication (MFA) through a proxy.
  • Improves behavior when linking system databases in Source Control.
  • Improved behavior with the active Paste As New Records command in Data Editor.
  • Improved behavior of active control when changing the current database and executing the query in SQL Document.

Fixes

  • Fixed unexpected exception when...

Released: Jun 16, 2021

Updates in V6.0.470

Features

  • Added support for showing/hiding SQL Document window additional view.
  • Added support for Ctrl+R shortcut.
  • Improved error handling when connecting to Microsoft Active Directory (analytics).
  • Improved connection behavior in Database Explorer when connections fail.
  • Added Alt+X shortcut for Execute command to the Microsoft SQL Server Management Studio keyboard scheme.
  • Object Viewer now supports External table object type.

Fixes

  • Issue with the export of data to Excel 2007.
  • Problem with getting...

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