Database

Devart dbForge Studio for SQL Server Enterprise Edition v6.5.140

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.

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

SQL Coding Assistance
Writing code in SQL Editor takes lot of time while you can be more productive with the help of:

Code completion — to create whole SQL statement in a few keystrokes.
SQL formatting — to follow common coding style (standard).
T-SQL Analyzer — to improve quality of your code with configurable rules.
SQL snippets — to save time storing and reusing repeated code fragments.
Quick object information — to show hints with info on database objects.
Code navigation — to quickly jump by F12 to variable declaration, object editor, etc.

Source Control
Incorporate source control system into your database development and deployment processes. With dbForge Studio, version controlling of SQL databases becomes smooth and flawless. The feature allows users to:

Link database to the most popular source control systems
Source-control a working folder
Perform all source-controlling tasks visually in a handy interface
Track changes history
Resolve conflicts

Index Manager
A handy tool for analyzing the status of SQL indexes and fixing issues with index fragmentation...

Description

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.

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

SQL Coding Assistance
Writing code in SQL Editor takes lot of time while you can be more productive with the help of:

Code completion — to create whole SQL statement in a few keystrokes.
SQL formatting — to follow common coding style (standard).
T-SQL Analyzer — to improve quality of your code with configurable rules.
SQL snippets — to save time storing and reusing repeated code fragments.
Quick object information — to show hints with info on database objects.
Code navigation — to quickly jump by F12 to variable declaration, object editor, etc.

Source Control
Incorporate source control system into your database development and deployment processes. With dbForge Studio, version controlling of SQL databases becomes smooth and flawless. The feature allows users to:

Link database to the most popular source control systems
Source-control a working folder
Perform all source-controlling tasks visually in a handy interface
Track changes history
Resolve conflicts

Index Manager
A handy tool for analyzing the status of SQL indexes and fixing issues with index fragmentation. Index Manager allows you to quickly collect index fragmentation statistics and detect databases that require maintenance. You can instantly rebuild and reorganize SQL indexes in a visual mode or generate SQL script for future use.

Unit Test
An intuitive and convenient tool for implementing automated unit tests. The tool is based on the open-source tSQLt framework, so SQL developers can benefit from writing unit tests in regular T-SQL. Unit Test rich functionality allows developing stable and reliable code that can be properly regression tested at the unit level.

Table Designer
Table is a key object in any database and is the most difficult one to configure. The elaborated SQL Table Designer allows to:

Quickly set table properties in the visual editors.
Edit a script that creates the table.
Rebuild tables when complex changes are introduced.
Preview changes before modification of an SQL database object.

Database Designer
An incomparable set of visual database tools allowing to visualize, create and edit SQL Server databases without writing code. Drag & drop the database on the diagram and get its basic objects and their connections neatly displayed. The Database Designer feature provides:

Database diagrams and scaling.
Printing large diagrams.
Virtual connections.
Visual Database Editor.

T-SQL Debugger
A must-have SQL database development tool for server-side logic. It's integrated into the stored procedure editor. Start debugging by clicking on the Database Explorer tree.

Schema Compare
Give the Schema Compare a try, and you will use this tool for any major changes in the database structure. Our tool will help you to:

Synchronize database schemas with complex object dependencies.
Detect development errors early.
Create schema snapshots to capture database structure.
Detect drift on production databases.
Create deployment scripts targeting different SQL Server editions.

6.5.140 28-Dec-23
Code Completion improvements

Added support for the CREATE TABLE AS SELECT statement in Azure Synapse
User reported bug fixes

Fixed an error that occurred when comparing databases with full-text indexes(D130144, D130304, D130854, D131571)
Improved the behavior of the Enclose identifiers within square brackets option when generating triggers(D130773)
Improved the parsing of the Output Clause in DML statements(D125969)
Enhanced the functionality of the Paging Mode in the Data Editor Card View(D137521)
Improved the behavior of the restoration of the Template Card settings in the Data Editor Card View when re-executing a SELECT query(D137528)
Fixed an issue with the data input popup window in the Data Editor closing unexpectedly(D136101, D138262)
In Source Control, DDL object comparison now considers whitespace characters; previously, they were ignored(D135726)
Fixed an error that occurred when exporting data to Google Sheets(D134795)
Fixed an issue with the connection lists to the server disappearing when multiple Studios are used concurrently(D126273)
Fixed an error that occurred when expanding the MEMORY_OPTIMIZED table nodes in Database Explorer(D127985)
Fixed the UI issues that occurred when working with the Studio launched under Crossover on MacOS(D135252)
Fixed an error that occurred when executing scripts containing a variable named @go(D97509)
Fixed an internal application error that occurred when retrieving database properties(D125077)

Additional Information