Devart dbForge Studio 2022 for SQL Server Enterprise Edition 6.2.22 (x64)
Devart dbForge Studio 2022 for SQL Server Enterprise Edition 6.2.22 (x64)
SQL developers and DBAs performing complex database tasks can use the GUI tool to speed up almost any database experience, such as designing databases, writing SQL code, comparing databases, synchronizing schemas and data, generating meaningful test data, and much more.
See how dbForge Studio surpasses SSMS in terms of features
There is no need to waste time searching for or purchasing SQL Server Management Studio (SSMS) plug-ins across the Internet to get your work done – dbForge Studio for SQL Server has everything you need to set up your SQL development environment. Check out the great advantages of our SSMS alternative and make sure you are just one step away from having the best user experience with this MS SQL database client!
Database Development
dbForge Studio for MS SQL Server provides extensive functionality and a bunch of built-in tools that will automate routines and make developers truly agile in the database development process.
Capabilities:
Edit and run queries in a new SQL document
Build queries in a visual designer
Run a large script without loading it into memory
Create unit tests using tSQLt framework
Debug stored procedures and functions
Source-control database changes
Create database objects in a visual editor
Generate database scripts
Database Management
As a robust Microsoft SQL manager, dbForge Studio for SQL Server has a set of database management tools that help DBAs protect data and resolve problems before they harm the database health.
Capabilities:
Compare and synchronize database schemas
Compare and synchronize data of two databases
Copy databases
Generate docs in HTML, PDF, or Markdown formats
Create schema snapshots
Generate test data and instantly populate a database
Export/import table data to a file (CSV, Excel, XML, etc.)
Database Administration
Database administration is a complex and time-consuming work that requires high skills and experience. That's why Studio for SQL Server provides professional SQL Server administration tools for secure database management.
Capabilities:
Set up user accounts and permissions
Copy, move or upgrade a SQL Server database
Back up and restore databases
Monitor SQL Server performance in online mode
Generate schema and database scripts
Diagnose server problems using traces
Find and fix database index fragmentation issues
Data Reports and Analysis
Creation of data reports and pivot tables, as well as data comparison, may take much time and effort. Our MS SQL database client provides the IDE that allows boosting productivity with the help of the following tools:
SQL Server Reporting
Pivot Tables
Data Compare
Master-Detail Browser
6.2.22 17-Jun-22
New features and improvements
Added support for new functions in the 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 the OPENROWSET function
Extended support for the comparison of SQL Server 2014-2019 backup files
Improved the server connection behavior to avoid blocking connected databases (D74074)
Improved the behavior of wildcard-aided search in a Schema Compare document (D71799)
Improved the display of the object type list in the filter window of a Schema Compare document (D71952)
Improved the grid display in the Monitor document (D82617)
Improved the logic of column width auto-adjustment in Data Editor (D76074, D78214, D82337, D84156, D84627, D87466)
Improved the diagnostics of false syntax errors in Query Builder (D79276)
User-reported bug fixes
Fixed an issue that occurred when launching schema comparison (T324200)
Fixed the performance of the source control update operation (D62771, D84389)
Fixed an issue that occurred when working with static data in source control (D69566)
Fixed an issue with the formatting of spatial data types (D68908)
Fixed a text editor issue (D73356)
Fixed an issue that occurred when closing the application (D73602)
Fixed an issue that occurred when comparing data (D75075, D75682, D76230, D85145)
Fixed an index synchronization issue (D79101)
Fixed the performance of the commit and push operations in source control (D62681, D62525)
Fixed an issue that occurred when changing the database in a SQL document (D88476)
Fixed a command-line editor issue (D77983)
Fixed an issue with displaying a container header on a diagram (D77624)
Fixed a documentation generation issue (D75272)
Fixed an issue with displaying text comparison differences (D76473, D83707)
Fixed an issue that occurred when working with the file system (D75991, D88984)
Fixed an issue with displaying nodes in Database Explorer (D75991, D88984)
Fixed a data generation issue (D75991, D88984)
Fixed an issue that occurred when working with transactions during schema synchronization (D75991, D88984)
Fixed an issue with the installation package (D84256)
Fixed an issue with document generation for encrypted procedures and functions in Documenter (D86286)
Fixed an icon display issue in the Monitor document (D83386)
Fixed a log file initialization issue that occurred when opening the application (D78127, D78128, D78072, D77961, D77910, D77911, D77907, D77906, D78249, D78275, D78319, D78405, D79517, D79551, D79665, D79663, D79664)
Fixed an issue with the CONTRACT permission type in Security Manager (D77323)
Fixed an issue with the search and replacement of values in Data Editor (D76642)
Fixed an issue with creating a foreign key on a database diagram (D76810)
Added the capability to control the column width for text data in Profile Server Events (D76014)
Fixed a data filtering issue in Data Editor (D74786, D78200)
Fixed an issue that occurred when opening Data Compare (D73600)
Fixed the Close all unmodified command for object editors (D70727)
Fixed an issue that occurred when opening a Monitor document (D69989)
Fixed an unexpected exception that occurred when copying data to clipboard (D75685, D84443)
Fixed an application uninstallation issue (D75346)
Fixed an unexpected exception that occurred when creating data reports for non-SELECT scripts (D77960)
Fixed an unexpected exception that occurred when building dependencies for Queue objects while generating documentation (D75272)
Fixed an unexpected exception that occurred when describing database objects during search (D74812)
Fixed an unexpected exception that occurred when working under the Azure Active Directory connection (D77811)
Fixed an issue with the interception of external exceptions by SQL Tools (D77546, D77547, D77546, D77458, D79376, D83397, D86339)
Fixed an issue that occurred when performing Analyze Code for a script with NOCOUNT ON (D74550)
Fixed an issue with the display of differences in the XLS comparison reports in Data Compare (D79090)
Fixed an unexpected exception that occurred when generating HTML documentation (D77497)
Fixed the behavior of the Reseed Identity Columns option for Azure connections in Data Compare (D78869)
Fixed an unexpected exception that occurred when exporting data to the Excel format
Fixed an unexpected exception in Data Editor
Fixed an issue with defining columns in a script for Python Generator in Data Generator (D79913)
Fixed an unexpected exception that occurred when describing databases with identical names for Schema and Assembly objects in Documenter (D81020, D83545)
Fixed an issue with connecting a database to a version control system (D69263, D71773)
Fixed an issue with reading data from the server when executing a script
Fixed false syntax errors (D75130, D78201, D76897, D79825, D86199, D87556)
Removed an error report thrown upon switching to the Design tab in cases when the query contained syntax errors or was not supported by Query Builder (D78330, D76412, D88199, D73070)
Fixed an issue that occurred when inserting a drop-down list element into the text (D75243)
Fixed an issue with calculating the Parameter Info of a function that was referred to via a synonym (D77735)
Fixed a script formatting issue (D76716, D88775)
Fixed an issue that occurred when updating the database object cache for hints (D75246, D76809)
Fixed an issue that occurred when loading SSMS extensions (D79550, D79846, D82952, D82953, D83099, D83113, D83332)
Fixed the highlighting of the system statistical functions in SQL Editor (D79825)
Fixed a text editor issue on the Windows Build 22567 or later (D81452, D81480, D81767)
Fixed the behavior of the Parameter Info hint (D73805)
Fixed the behavior of the Quick Info hint
Fixed an issue that occurred when working with the table editor
Fixed the display of data in the login_time and last_batch columns on the Sessions tab in Monitor (D79666)
Fixed an issue that occurred when working with a data comparison document (D81953)
Fixed an issue that occurred when selecting view columns from its query (D80547)
Fixed an issue that occurred when viewing trigger dependencies in Database Explorer
Fixed an issue with loading an SQL script from a saved file to a document
Fixed an issue that occurred when analyzing differences in Queue objects while executing the Get Latest command (D86209, D87487)
New features and improvements
Added support for new functions in the 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 the OPENROWSET function
Extended support for the comparison of SQL Server 2014-2019 backup files
Improved the server connection behavior to avoid blocking connected databases (D74074)
Improved the behavior of wildcard-aided search in a Schema Compare document (D71799)
Improved the display of the object type list in the filter window of a Schema Compare document (D71952)
Improved the grid display in the Monitor document (D82617)
Improved the logic of column width auto-adjustment in Data Editor (D76074, D78214, D82337, D84156, D84627, D87466)
Improved the diagnostics of false syntax errors in Query Builder (D79276)
User-reported bug fixes
Fixed an issue that occurred when launching schema comparison (T324200)
Fixed the performance of the source control update operation (D62771, D84389)
Fixed an issue that occurred when working with static data in source control (D69566)
Fixed an issue with the formatting of spatial data types (D68908)
Fixed a text editor issue (D73356)
Fixed an issue that occurred when closing the application (D73602)
Fixed an issue that occurred when comparing data (D75075, D75682, D76230, D85145)
Fixed an index synchronization issue (D79101)
Fixed the performance of the commit and push operations in source control (D62681, D62525)
Fixed an issue that occurred when changing the database in a SQL document (D88476)
Fixed a command-line editor issue (D77983)
Fixed an issue with displaying a container header on a diagram (D77624)
Fixed a documentation generation issue (D75272)
Fixed an issue with displaying text comparison differences (D76473, D83707)
Fixed an issue that occurred when working with the file system (D75991, D88984)
Fixed an issue with displaying nodes in Database Explorer (D75991, D88984)
Fixed a data generation issue (D75991, D88984)
Fixed an issue that occurred when working with transactions during schema synchronization (D75991, D88984)
Fixed an issue with the installation package (D84256)
Fixed an issue with document generation for encrypted procedures and functions in Documenter (D86286)
Fixed an icon display issue in the Monitor document (D83386)
Fixed a log file initialization issue that occurred when opening the application (D78127, D78128, D78072, D77961, D77910, D77911, D77907, D77906, D78249, D78275, D78319, D78405, D79517, D79551, D79665, D79663, D79664)
Fixed an issue with the CONTRACT permission type in Security Manager (D77323)
Fixed an issue with the search and replacement of values in Data Editor (D76642)
Fixed an issue with creating a foreign key on a database diagram (D76810)
Added the capability to control the column width for text data in Profile Server Events (D76014)
Fixed a data filtering issue in Data Editor (D74786, D78200)
Fixed an issue that occurred when opening Data Compare (D73600)
Fixed the Close all unmodified command for object editors (D70727)
Fixed an issue that occurred when opening a Monitor document (D69989)
Fixed an unexpected exception that occurred when copying data to clipboard (D75685, D84443)
Fixed an application uninstallation issue (D75346)
Fixed an unexpected exception that occurred when creating data reports for non-SELECT scripts (D77960)
Fixed an unexpected exception that occurred when building dependencies for Queue objects while generating documentation (D75272)
Fixed an unexpected exception that occurred when describing database objects during search (D74812)
Fixed an unexpected exception that occurred when working under the Azure Active Directory connection (D77811)
Fixed an issue with the interception of external exceptions by SQL Tools (D77546, D77547, D77546, D77458, D79376, D83397, D86339)
Fixed an issue that occurred when performing Analyze Code for a script with NOCOUNT ON (D74550)
Fixed an issue with the display of differences in the XLS comparison reports in Data Compare (D79090)
Fixed an unexpected exception that occurred when generating HTML documentation (D77497)
Fixed the behavior of the Reseed Identity Columns option for Azure connections in Data Compare (D78869)
Fixed an unexpected exception that occurred when exporting data to the Excel format
Fixed an unexpected exception in Data Editor
Fixed an issue with defining columns in a script for Python Generator in Data Generator (D79913)
Fixed an unexpected exception that occurred when describing databases with identical names for Schema and Assembly objects in Documenter (D81020, D83545)
Fixed an issue with connecting a database to a version control system (D69263, D71773)
Fixed an issue with reading data from the server when executing a script
Fixed false syntax errors (D75130, D78201, D76897, D79825, D86199, D87556)
Removed an error report thrown upon switching to the Design tab in cases when the query contained syntax errors or was not supported by Query Builder (D78330, D76412, D88199, D73070)
Fixed an issue that occurred when inserting a drop-down list element into the text (D75243)
Fixed an issue with calculating the Parameter Info of a function that was referred to via a synonym (D77735)
Fixed a script formatting issue (D76716, D88775)
Fixed an issue that occurred when updating the database object cache for hints (D75246, D76809)
Fixed an issue that occurred when loading SSMS extensions (D79550, D79846, D82952, D82953, D83099, D83113, D83332)
Fixed the highlighting of the system statistical functions in SQL Editor (D79825)
Fixed a text editor issue on the Windows Build 22567 or later (D81452, D81480, D81767)
Fixed the behavior of the Parameter Info hint (D73805)
Fixed the behavior of the Quick Info hint
Fixed an issue that occurred when working with the table editor
Fixed the display of data in the login_time and last_batch columns on the Sessions tab in Monitor (D79666)
Fixed an issue that occurred when working with a data comparison document (D81953)
Fixed an issue that occurred when selecting view columns from its query (D80547)
Fixed an issue that occurred when viewing trigger dependencies in Database Explorer
Fixed an issue with loading an SQL script from a saved file to a document
Fixed an issue that occurred when analyzing differences in Queue objects while executing the Get Latest command (D86209, D87487)
Only for V.I.P Warning! You are not allowed to view this text.