Devart dbForge Studio 2022 for SQL Server Enterprise Edition 6.3.9 (x64)

Devart dbForge Studio 2022 for SQL Server Enterprise Edition 6.3.9 (x64)
Devart dbForge Studio 2022 for SQL Server Enterprise Edition 6.3.9 (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.3.9 12-Sep-22

General

Connectivity support for SQL Server 2022 CTP 2.1

Expanded keyword suggestions

Added support for CREATE INDEX and ALTER INDEX for SQL Server 2022
Added support for CREATE CLUSTERED INDEX for SQL Server 2022
Added support for CREATE TABLE and ALTER TABLE for SQL Server 2022
Added support for ALTER DATABASE SCOPED CONFIGURATION for SQL server 2022

New query hints and syntax constructs

Added query hints for the DELETE, INSERT, SELECT, UPDATE, and MERGE statements
Added support the BACKUP SYMMETRIC KEY syntax construct
Added support the RESTORE SYMMETRIC KEY syntax construct
Added support for the DATE_BUCKET function in the Completion List, Quick Info, and Parameter Information

Improvements

Improved performance of the Refresh operation in Source Control
Updated the query execution plan for SQL Server 2022

User-reported bug fixes

Fixed incorrect script generation for table-based types in specific environments
Fixed poor Data Editor and Data Viewer performance when operating huge data sets (D89520)
Fixed a syntax error that occurred when using built-in functions (D93017)
Fixed a bug in Table Editor that occurred when changing table options in a script (D93680)
Fixed a syntax error that occurred when accessing columns whose names match the names of the built-in functions (D96131)
Fixed a bug that occurred when working with Query Builder
Fixed symbol duplication that occurred when placing separators (Insert Semicolon) in the script (D92011)
Fixed an issue with fetching data in Data Editor (D90608)
Added support for creating constraints on the computed columns in Table Editor (D89634)
Fixed a bug that occurred when working with Static Data in Source Control (D87477)


Information
Users of Guests are not allowed to comment this publication.