Devart dbForge Studio 2022 for SQL Server Enterprise Edition v6.4.7
Devart dbForge Studio 2022 for SQL Server Enterprise Edition v6.4.7
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.4.7 30-Dec-22
New features
Optimized system resources consumption when preparing the Quick Info and Code Completion hints
Support for macOS & Linux via CrossOver
Improvements
Added the behavior to open the Objects Filter window when creating a Schema Compare document
Added support for modifying a view comment in the Object Editor (D105577)
Added disk folder cleanup for the Unlink command in Source Control
Added the ability to set the object filter file from the CLI for Schema Compare
Improved Code Completion on the MFA connections
Improved the behavior of the Ctrl+C/Ctrl+X shortcut to copy/cut the entire line of text if nothing is selected
Implemented the output of the original text of the view object for the Modify command (D100805)
Improved the metadata reading behavior - the VIEW DATABASE STATE privilege is no longer required (p135909, T308355, D71423, D98539, D103313)
Improved formatting under the Text Case - Identifier Case - As in the Database configuration (D95432)
Improved syntax check (D97235)
Improved query profiling on SQL Server 2019/2022 (p219550)
Improved the Backups report in Monitor (D89312)
Improved the Source Control informational message displayed in case of the presence of a non-existent schema object
Improved formatting under the Text Case - Identifier Case - As in the Database configuration (D95432)
User-reported bug fixes
Fixed an issue with extended properties in Source Control
Fixed a bug that occurred when importing data (D99244, D99762)
Fixed a bug that occurred when configuring the Table or View generator (D89788)
Fixed the Data Editor issue with the UID data type (D93895)
Fixed the Window menu bug (p218671, D104072)
Fixed the behavior of saving changes in the Table Editor (D93895)
Fixed a bug that occurred after closing the SQL document (D107952)
Fixed the 'Database files are not found' error in Transaction Log (D97365)
Fixed the export of boolean values to JSON format (D99831, D99914)
Fixed a bug that occurred when creating a comparison report in Data Compare
Fixed text color in the ODBC data export grid (D104127)
Fixed a bug that occurred when executing the Generate Script As command (D107166)
Fixed the disappearance of the DESC keyword in Query Builder
Fixed an error that occurred when generating a trigger DML script (D97458)
Fixed 'The connection was not closed' error (D96327)
Fixed an Object Viewer bug (D87706)
Fixed an issue with saving an object in the Object Editor (D86972)
Fixed an error that occurred when working with statements containing the PIVOT/UNPIVOT clause (D95760, D95759, D96164, D100368)
Fixed an error that occurred when getting object metadata on Azure servers (D92385)
Fixed an issue with the hints behavior that occurred when changing the database context in the script using the USE statement (D93742)
Fixed the logic of handling the Description property for Azure SQL Database objects (D92854)
Fixed the logic of handling permissions in Schema Compare (D93289)
Fixed the permissions issues that occurred when comparing database objects with Schema Compare
Fixed an error that occurred after linking a database in Source Control
Fixed an object synchronization error in Schema Compare (D96984)
Fixed a bug that occurred when working with UDT
New features
Optimized system resources consumption when preparing the Quick Info and Code Completion hints
Support for macOS & Linux via CrossOver
Improvements
Added the behavior to open the Objects Filter window when creating a Schema Compare document
Added support for modifying a view comment in the Object Editor (D105577)
Added disk folder cleanup for the Unlink command in Source Control
Added the ability to set the object filter file from the CLI for Schema Compare
Improved Code Completion on the MFA connections
Improved the behavior of the Ctrl+C/Ctrl+X shortcut to copy/cut the entire line of text if nothing is selected
Implemented the output of the original text of the view object for the Modify command (D100805)
Improved the metadata reading behavior - the VIEW DATABASE STATE privilege is no longer required (p135909, T308355, D71423, D98539, D103313)
Improved formatting under the Text Case - Identifier Case - As in the Database configuration (D95432)
Improved syntax check (D97235)
Improved query profiling on SQL Server 2019/2022 (p219550)
Improved the Backups report in Monitor (D89312)
Improved the Source Control informational message displayed in case of the presence of a non-existent schema object
Improved formatting under the Text Case - Identifier Case - As in the Database configuration (D95432)
User-reported bug fixes
Fixed an issue with extended properties in Source Control
Fixed a bug that occurred when importing data (D99244, D99762)
Fixed a bug that occurred when configuring the Table or View generator (D89788)
Fixed the Data Editor issue with the UID data type (D93895)
Fixed the Window menu bug (p218671, D104072)
Fixed the behavior of saving changes in the Table Editor (D93895)
Fixed a bug that occurred after closing the SQL document (D107952)
Fixed the 'Database files are not found' error in Transaction Log (D97365)
Fixed the export of boolean values to JSON format (D99831, D99914)
Fixed a bug that occurred when creating a comparison report in Data Compare
Fixed text color in the ODBC data export grid (D104127)
Fixed a bug that occurred when executing the Generate Script As command (D107166)
Fixed the disappearance of the DESC keyword in Query Builder
Fixed an error that occurred when generating a trigger DML script (D97458)
Fixed 'The connection was not closed' error (D96327)
Fixed an Object Viewer bug (D87706)
Fixed an issue with saving an object in the Object Editor (D86972)
Fixed an error that occurred when working with statements containing the PIVOT/UNPIVOT clause (D95760, D95759, D96164, D100368)
Fixed an error that occurred when getting object metadata on Azure servers (D92385)
Fixed an issue with the hints behavior that occurred when changing the database context in the script using the USE statement (D93742)
Fixed the logic of handling the Description property for Azure SQL Database objects (D92854)
Fixed the logic of handling permissions in Schema Compare (D93289)
Fixed the permissions issues that occurred when comparing database objects with Schema Compare
Fixed an error that occurred after linking a database in Source Control
Fixed an object synchronization error in Schema Compare (D96984)
Fixed a bug that occurred when working with UDT
Only for V.I.P
Warning! You are not allowed to view this text.