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.
7.0.158 05-Sep-24
T-SQL Code Analyzer
Updated T-SQL Code Analyzer with new rules
Connectivity
Renamed the Azure Active Directory authentication type to Microsoft Entra ID
Added support for ApsaraDB
DevOps & CLI Automation
Added support for Atlassian Bamboo Data Center
Added CLI automation for Find Invalid Objects
Added Save Command Line for Index Manager
Added generation of comparison reports from the command line
Code Completion
Added support for non-aggregated columns in GROUP BY statements
Added support for viewing the MSDescription property for databases
Added support for the PERSISTENT_LOG_BUFFER construct in CREATE DATABASE statements
Added support for the RSA_OAEP algorithm in CREATE COLUMN ENCRYPTION KEY statements
Added support for the COLUMN MASTER KEY server object
Added support for T-SQL graph functions: EDGE_ID_FROM_PARTS, GRAPH_ID_FROM_EDGE_ID, GRAPH_ID_FROM_NODE_ID, NODE_ID_FROM_PARTS, OBJECT_ID_FROM_EDGE_ID, and OBJECT_ID_FROM_NODE_ID
Added support for the TERTIARY_WEIGHTS function
Extended support for the AVAILABILITY GROUP constructs
Support for Implicit Procedure Execution
Schema Compare
Added the Show Ignored Differences option for schema comparison
Added a new shortcut ALT+(arrow down) that allows going to each subsequent difference in a schema comparison document
Added support for the ADD SENSITIVITY CLASSIFICATION command
Added a new Issues page in Schema and Data Synchronization Wizards
Added a new index option STATISTICS_INCREMENTAL
Added a new group of options called Sequences, comprising Ignore START WITH in sequences and Ignore MIN VALUE in sequences
Added new comparison options: Ignore MIN VALUE, Ignore START WITH, Ignore CYCLE, Ignore INCREMENT BY, and Ignore CACHE
Source Control
Added support for XML and HASH indexes for Azure
Added support for the PERSISTED construct for table variables
Added a Hide empty columns button in the static data diff grid
Database Diagrams
Updated the design of database diagrams with new element skins, opacity controls, and linear zoom factor
Added a new option Clear Waypoints
Added a new option Select All Relations
SQL Query History
Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button
Added the ability to save user-defined column layouts in Query History
Documents
Added options to rearrange tab opening order
Added new options in Tabs and Windows: Tab layout, Show tabs in multiple rows, and Close tabs with middle-click
Added a new option Open Data in Editor
Added a new shortcut CTRL+SHIFT+/ that comments selected pieces of code
Database Explorer
Added the ability to save filter settings for tables in Database Explorer to a file
Added a new option Drop destination object to Duplicate Object
Added support for Search Property Lists in Azure SQL Database
Data Generator
Added a new option Append timestamp to the file name in Data Population Wizard
Added new shortcuts to facilitate search for the required tables and columns
Script Generation
Added automated wrapping of CRUD templates into named regions
Added new options to Generate Scripts: Script DML triggers, Script security permissions, and Script authorization
Data Editor
Added an option to set a cell value to a unique identifier from the shortcut menu
Pivot Tables
Upgraded Chart Designer to a more advanced version with an improved appearance
Find Invalid Objects
Added new buttons Check All and Uncheck All to facilitate selection of databases
Search
Implemented export of search results to CSV
Index Manager
Implemented a shortcut menu to help quickly arrange, sort, group, and filter entries in the grid
Application Startup Time
Added application startup duration to be displayed alongside the startup timestamp
User-reported bug fixes
Fixed the display of the database node icon in the Database Explorer (D98541)
Fixed the shortcut behavior for the Results as Text functionality (D127047)
Extended the retention period for executed SQL queries to 10 years (D130168)
Fixed an error that occurred when editing a query using the Data Report functionality (D132163)
Fixed an error that occurred when opening the context menu on the Constraints tab of the Table Editor (D134602)
Fixed the shortcut functionality for activating SQL Document views (D134564)
Fixed the functionality for restoring open documents when changing the product edition (D139452)
Fixed the functionality for comparing string data containing the backslash character (D135825)
Fixed the behavior of the Go To Definition functionality when using an Azure AD MFA connection (D140894)
Fixed internal application error (D134083)
Improved the functionality for loading the database documentation document when there is no connection (D149128)
Fixed the Query History error that occurred after importing application settings (D113134)
Fixed an issue with reading old snapshots: the synchronization script now executes correctly, ensuring databases are equal after comparison (T264848)
Optimized the parser to reduce CPU load (D51581)
Optimized the algorithm for finding links between declared objects (D101339)
Fixed the display for user datatypes in Database Explorer for the User_Data_Type_Name (Native_Type) columns (D110365)
Changed the default setting for the Find and Replace functionality from "All Open Documents" to "Current Document" (D119376, D120733, D121139, D136325)
Fixed the error report during data export using ODBC when the ODBC connection is closed (D127150, D147616)
Fixed the behavior of formatting via the command line that differed from the formatting in the SQL document due to an unknown ansi_quotes state (D132092)
Fixed the behavior of formatting via the command line that differed from the formatting in SQL Document due to an unknown ansi_quotes state (D132092)
Fixed the parsing of functions with the GROUPING expression (D134900)
Fixed a search error in the Source Control functionality (D133718)
Fixed the display of the number of mapped columns on the Table Mapping page of the Schema Comparison Wizard (D136752)
Fixed an issue with parsing JOIN expressions (D132774, T277481)
Added a wait time for retrieving the list of columns (D134892)
Fixed the error report during data export via command line using ODBC when the ODBC connection is closed (D127150)
Fixed data export via ODBC for existing tables (D127150)
Fixed an issue preventing the deletion of the import file after import (D140100)
Enabled renaming of table names when exporting data to Excel (u47439308)
Resolved the error report issue in the Database Documenter (D141365)
Fixed the display of warnings in the Plan Diagram functionality (D136772)
Fixed the Failed to perform the syntax action error [524297] (D143086, D143350)
Fixed the error report during data export via command line using ODBC when the ODBC connection is closed (D127150)
Fixed data export via ODBC for existing tables (D127150)
Fixed the construction of queries with JOIN expressions in the Query Builder (D146358)
Fixed data import from CSV files (D150169)
Updated shortcuts to match the SSMS schema (T147971)
Added support for selecting multiple files in the Restore wizard (p177814)
Enabled text editing for multi-line selections with the Shift+Alt shortcut (T324921)
Fixed an error that occurred when displaying External Data Source objects in the Object Viewer (T292377)
Significantly improved performance when selecting table column checkboxes in Query Builder (D58143)
Resolved issues with matching the output to the JSON format in data export (D161343)
Fixed the display of table properties for Azure servers in Documenter (T315047)
Added support for the ApplicationName parameter in server connection settings (D93629)
Fixed the error accessing the sql_expression_dependencies view with restricted user permissions in Source Control (D120039)
Expanded the list of conditions in the Filter Editor for string data types in Data Editor (D121088)
Fixed the occasional error updating commands in SQL Document (D129941)
Fixed the error retrieving metadata for server objects in Source Control (D151850)
Resolved the issue with large or boundary values for Sequences properties (D134574)
Added support for displaying External Login and External Group objects in the Security Manager Explorer (D139263, D140392, D141986, D146748, D147384)
Fixed the occasional error in the Object Search functionality (D141088)
Fixed the parser error for view definitions with a large number of JOINs (D140616)
Improved DDL object comparison - the Ignore white spaces option no longer affects literal comparisons (D135726, D143099)
Fixed an issue that caused custom server connection locations to reset in the Database Explorer (D142533)
Resolved an issue with extra blank lines appearing in DDL when committing procedures and functions in Source Control (D144110, D148188)
Set the Append timestamp to the file name checkbox to be selected by default in the Data Export wizard (D115315)
Resolved an issue with describing server objects in Source Control (D148259)
Addressed the Execution Timeout Expired error that occurred during query execution (D144548)
Fixed an issue with renaming indexes in the Database Explorer and Object Editor (D152529)
Addressed the issue with incorrect data editing locks in Data Editor (D153084)
Resolved an issue with dependency search for views that contain the PIVOT clause in the SELECT statement (D123540)
The Disable check constraints option now respects server restrictions and no longer removes NOT NULL from columns where it is restricted (D155250)
Improved parsing of ORDER BY expressions in subqueries (D149478, D148304)
Improved the behavior of the Round float types up to X digits option (D135833)
Fixed an issue with the synchronization button being inactive when the Comparison toolbar was hidden (D144406)
Fixed the shortcut functionality for the GoToBraceExtend command (D146853)
Added support for selecting quoted identifiers with a double-click (D144429, D103331)
Added support for Backup, Restore, and Attach Database operations from removable media (D140566)
Fixed the object suggestions in the Completion List for large queries (D136746)
Resolved an issue with renaming objects in SQL Azure Database (D132068, D133629)
Changed the data output for reports in Data Compare-reports now include original values without quotes and formatting (D131831)
Fixed an error that occurred when describing the schema during script folder creation (D88738)
Optimized schema description in Data Compare-non-schema-bound views are now read only when the Compare views option is enabled (T305596)
Fixed an issue with extended properties missing N prefixes for Unicode values (u36182551)