dbForge Studio for SQL Server

A SQL Server IDE for efficient database development.

Published by Devart
Distributed by ComponentSource since 2005

Prices from: $ 323.35 Version: 6.3.9 NEW Updated: Sep 12, 2022 4.50 Star Average Review4.50 Star Average Review4.50 Star Average Review4.50 Star Average Review4.50 Star Average Review (4)

Screenshot of dbForge Studio for SQL Server

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

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

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

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

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

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

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

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