-
Latest Version
dbForge Studio for SQL Server Professional 7.0.249 LATEST
-
Review by
-
Operating System
Windows 7 / Windows 8 / Windows 10 / Windows 11
-
User Rating
Click to vote -
Author / Product
SQL developers and DBAs performing complex database tasks can use the 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.
There is no need to waste time searching for and purchase SSMS plugins across the Internet to get your work done – dbForge Studio SQL Server for Windows PC has it all.
DevOps Automation - NEW
A simple way to release databases faster
Implement database CI/CD and improve performance by automating build and deployment processes using the dbForge Studio for SQL Server
Features and Highlights
Database Development
Database development is a sophisticated process that covers many steps and techniques, not just creating tables and filling them with data.
dbForge Studio for 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.
- Edit and run queries in a new SQL document
- Build queries in a visual designer
- Run a large script without loading it into memory
- Track changes in a production database
- 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
Database management tools included in dbForgeStudio for SQL Server (Windows Edition) help DBAs to protect data and resolve problems before they harm your database health.
- Compare and synchronize database schemas
- Compare and synchronize data of two databases
- Copy databases
- Generate database documentation in HTML, PDF, or Markdown file format
- Create schema snapshots
- Generate test data and instantly populate a database
- Export/import table data to a file (CSV, Excel, XML, etc.)
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.
- Automate deployment to a production server
- Set up user accounts and permissions
- Copy, move or upgrade an SQL Server database
- Backup 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
Pricing
Choose from four editions based on your needs:
Enterprise: Full-featured, ideal for advanced users. Subscription: $479.95
Professional: Offers advanced features for professionals. Subscription: $329.95
Standard: Essential features for standard users. Subscription: $229.95
Express: Free with basic functionality, activated after the trial period expires.
All editions provide compatibility with SQL Server 2022 and earlier, along with essential tools like SQL coding assistance, database design, and administration features tailored to each edition’s scope.
Requirements
Microsoft Windows 7/8/8.1/10/11
Windows Server 2008/2012/2016/2019/2022
.NET Framework 4.7.2 or higher installed.
Note
.NET Framework is pre-installed in Microsoft Windows 7/8/8.1/10/11.
Microsoft SQL Server compatibility
- SQL Server 2022
- SQL Server 2019, 2017, 2016 SP1, 2016, 2014, 2012, LocalDB
- SQL Server 2008, 2008R2 (including Express edition)
- SQL Server 2005 (including Express edition)
- SQL Server 2000 (limited support)
- SQL Server installed on Linux
- SQL Server on Amazon Relational Database Service (Amazon RDS)
- ApsaraDB RDS
- Azure SQL Database (SQL DB)
- Azure Synapse Analytics (formerly known as Azure SQL Data Warehouse (SQL DW))
- Azure SQL Managed Instance (SQL MI)
- Azure Active Directory (Azure AD) multi-factor authentication (MFA)
- Azure Private Link for Azure SQL Database
- Heroku Cloud
- Intuitive and User-Friendly Interface
- Advanced SQL Coding Assistance
- Comprehensive Database Management Tools
- Powerful Data Analysis Features
- Seamless Integration with Source Control
- Limited Cross-Platform Compatibility
- Requires Moderate Hardware Resources
- Licensing Can Be Expensive
- Occasional Performance Lag with Large Databases
- Steeper Learning Curve for Beginners
What's new in this version:
dbForge Studio for SQL Server Professional 7.0.249
Fixed:
- Resolved a parsing issue where SQLCMD commands were treated as procedure names, leading to the use of incorrect parsing logic
- Fixed an issue that occurred when processing queries containing JOIN clauses
dbForge Studio for SQL Server Professional 7.0.210
Added:
- Added Syntax Check in Object Editor for procedures and functions
Improved:
- Improved the activation behavior of the Data tab in SQL Document when the Activate Data Editor after query execution option is enabled
- Improved the display of object lists in text tooltips
- Improved the handling of delimiters during object script generation
Fixed:
- Fixed an issue that caused dbForge Studio for SQL Server to freeze when parsing expressions with multiple nested function calls
- Fixed an issue that occurred when working with revision files that have spaces in their paths
- Fixed an issue that occurred when calling the Generate Script As SELECT command on SQL Server 2000
- Fixed an issue that occurred when searching for objects after changing the connection
- Fixed an issue where Security Policy lost dependency on views and added support for building predicates for views
- Fixed an error that occurred when editing a period column of a temporal table
dbForge Studio for SQL Server Professional 7.0.158
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+↓ 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
- Fixed the shortcut behavior for the Results as Text functionality
- Extended the retention period for executed SQL queries to 10 years
- Fixed an error that occurred when editing a query using the Data Report functionality
- Fixed an error that occurred when opening the context menu on the Constraints tab of the Table Editor
- Fixed the shortcut functionality for activating SQL Document views
- Fixed the functionality for restoring open documents when changing the product edition
- Fixed the functionality for comparing string data containing the backslash character
- Fixed the behavior of the Go To Definition functionality when using an Azure AD MFA connection
- Fixed internal application error
- Improved the functionality for loading the database documentation document when there is no connection
- Fixed the Query History error that occurred after importing application settings
- Fixed an issue with reading old snapshots: the synchronization script now executes correctly, ensuring databases are equal after comparison
- Optimized the parser to reduce CPU load
- Optimized the algorithm for finding links between declared objects
- Fixed the display for user datatypes in Database Explorer for the User_Data_Type_Name
- Changed the default setting for the Find and Replace functionality from "All Open Documents" to "Current Document"
- Fixed the error report during data export using ODBC when the ODBC connection is closed
- 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
- Fixed the behavior of formatting via the command line that differed from the formatting in SQL Document due to an unknown ansi_quotes state
- Fixed the parsing of functions with the GROUPING expression
- Fixed a search error in the Source Control functionality
- Fixed the display of the number of mapped columns on the Table Mapping page of the Schema Comparison Wizard
- Fixed an issue with parsing JOIN expressions
- Added a wait time for retrieving the list of columns
- Fixed the error report during data export via command line using ODBC when the ODBC connection is closed
- Fixed data export via ODBC for existing tables
- Fixed an issue preventing the deletion of the import file after import
- Enabled renaming of table names when exporting data to Excel
- Resolved the error report issue in the Database Documenter
- Fixed the display of warnings in the Plan Diagram functionality
- Fixed the Failed to perform the syntax action error [524297]
- Fixed the error report during data export via command line using ODBC when the ODBC connection is closed
- Fixed data export via ODBC for existing tables
- Fixed the construction of queries with JOIN expressions in the Query Builder
- Fixed data import from CSV files
- Updated shortcuts to match the SSMS schema
- Added support for selecting multiple files in the Restore wizard
- Enabled text editing for multi-line selections with the Shift+Alt shortcut
- Fixed an error that occurred when displaying External Data Source objects in the Object Viewer
- Significantly improved performance when selecting table column checkboxes in Query Builder
- Resolved issues with matching the output to the JSON format in data export
- Fixed the display of table properties for Azure servers in Documenter
- Added support for the ApplicationName parameter in server connection settings
- Fixed the error accessing the sql_expression_dependencies view with restricted user permissions in Source Control
- Expanded the list of conditions in the Filter Editor for string data types in Data Editor
- Fixed the occasional error updating commands in SQL Document
- Fixed the error retrieving metadata for server objects in Source Control
- Resolved the issue with large or boundary values for Sequences properties
- Added support for displaying External Login and External Group objects in the Security Manager Explorer
- Fixed the occasional error in the Object Search functionality
- Fixed the parser error for view definitions with a large number of JOINs
- Improved DDL object comparison—the Ignore white spaces option no longer affects literal comparisons
- Fixed an issue that caused custom server connection locations to reset in the Database Explorer
- Resolved an issue with extra blank lines appearing in DDL when committing procedures and functions in Source Control
- Set the Append timestamp to the file name checkbox to be selected by default in the Data Export wizard
- Resolved an issue with describing server objects in Source Control
- Addressed the Execution Timeout Expired error that occurred during query execution
- Fixed an issue with renaming indexes in the Database Explorer and Object Editor
- Addressed the issue with incorrect data editing locks in Data Editor
- Resolved an issue with dependency search for views that contain the PIVOT clause in the SELECT statement
- The Disable check constraints option now respects server restrictions and no longer removes NOT NULL from columns where it is restricted
- Improved parsing of ORDER BY expressions in subqueries
- Improved the behavior of the Round float types up to X digits option
- Fixed an issue with the synchronization button being inactive when the Comparison toolbar was hidden
- Fixed the shortcut functionality for the GoToBraceExtend command
- Added support for selecting quoted identifiers with a double-click
- Added support for Backup, Restore, and Attach Database operations from removable media
- Fixed the object suggestions in the Completion List for large queries
- Resolved an issue with renaming objects in SQL Azure Database
- Changed the data output for reports in Data Compare—reports now include original values without quotes and formatting
- Fixed an error that occurred when describing the schema during script folder creation
- Optimized schema description in Data Compare—non-schema-bound views are now read only when the Compare views option is enabled
- Fixed an issue with extended properties missing N prefixes for Unicode values
dbForge Studio for SQL Server Professional 6.6.5
Improved:
- Integration support for SSMS 20.x
Fixed:
- Fixed an error associated with importing data from JSON
- Fixed an issue that occurred when comparing text source objects in Source Control
dbForge Studio for SQL Server Professional 6.5.140
- Added support for the CREATE TABLE AS SELECT statement in Azure Synapse
Fixed:
- Fixed an error that occurred when comparing databases with full-text indexes
- Improved the behavior of the Enclose identifiers within square brackets option when generating triggers
- Improved the parsing of the Output Clause in DML statements
- Enhanced the functionality of the Paging Mode in the Data Editor Card View
- Improved the behavior of the restoration of the Template Card settings in the Data Editor Card View when re-executing a SELECT query
- Fixed an issue with the data input popup window in the Data Editor closing unexpectedly
- In Source Control, DDL object comparison now considers whitespace characters; previously, they were ignored
- Fixed an error that occurred when exporting data to Google Sheets
- Fixed an issue with the connection lists to the server disappearing when multiple Studios are used concurrently
- Fixed an error that occurred when expanding the MEMORY_OPTIMIZED table nodes in Database Explorer
- Fixed the UI issues that occurred when working with the Studio launched under Crossover on MacOS
- Fixed an error that occurred when executing scripts containing a variable named @go
- Fixed an internal application error that occurred when retrieving database properties
dbForge Studio for SQL Server Professional 6.5.16
Code Completion improvements:
- Added support for the GENERATE_SERIES and OPENQUERY relational operators
- Added support for the following functions: LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT, GET_BIT, and SET_BIT
- Added support for the APPROX_PERCENTILE_CONT and APPROX_PERCENTILE_DISC aggregate functions
- Added support for the DATETRUNC function
Schema/Data Compares and Source Control:
- Optimized the process of describing scripts folders
User-reported bug fixes:
- Fixed a data loss issue that occurred during XML import
- Resolved an error related to reading server event profiling templates
- Fixed an error that occurred when the SQL document was closed while processing the parameter list for functions
- Fixed an error that could occur when launching the synchronization wizard in Schema Compare
- Resolved an error that occurred when trying to open Security Manager while connected to SQL Server 2022
- Expanded the list of conditions in the Filter Editor for columns of type int in the Data Editor
- Fixed an error that occurred when debugging a script containing a system procedure
- Resolved a freezing issue that occurred when editing values in large tables in Data Editor
- Improved the reading of JSON files, detection of NULL values, and error handling within the Data Import feature
- Fixed a false warning in the Data Editor that incorrectly indicated missing unique keys for SQL Server 2000
- Fixed an issue with sudden crashes that occurred during complex script editing
dbForge Studio for SQL Server Professional 6.4.124
Added:
- DML triggers sorting in Source Control
- the syntax support for calling procedures/functions without the EXEC/EXECUTE keyword
Fixed:
- an issue with locking the user interface when switching between SQL Document windows
- an issue that occurred when displaying the informational window
- an issue with the text search across DDL objects in Object Search
- an error that occurred when using the Google Sheets data export template
- the behavior of the Ignore History Table option
- the display of the datetime data type in the data comparison grid
- the display of the Generate Script As command for an empty table
- Supported the EXEC command in Syntax Check
dbForge Studio for SQL Server Professional 6.4.7
New features:
- Optimized system resources consumption when preparing the Quick Info and Code Completion hints
- Support for macOS & Linux via CrossOver
Improved:
- 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
- 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 the entire line of text if nothing is selected
- Implemented the output of the original text of the view object for the MoDify command
- Improved the metadata reading behavior - the VIEW DATABASE STATE privilege is no longer required
- Improved formatting under the Text Case - Identifier Case - As in the Database configuration
- Improved syntax check
- Improved query profiling on SQL Server 2019/2022
- Improved the Backups report in Monitor
- 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
- Improved syntax check
- Improved query profiling on SQL Server 2019/2022
- Improved the Backups report in Monitor
- In Source Control, added the ability to link a database to a subfolder in a Git repository
Fixed:
- an issue with extended properties in Source Control
- a bug that occurred when importing data
- a bug that occurred when configuring the Table or View generator
- the Data Editor issue with the UID data type
- the Window menu bug
- the behavior of saving changes in the Table Editor
- a bug that occurred after closing the SQL document
- the 'Database files are not found' error in Transaction Log
- the export of boolean values to JSON format
- a bug that occurred when creating a comparison report in Data Compare
- text color in the ODBC data export grid
- a bug that occurred when executing the Generate Script As command
- the disappearance of the DESC keyword in Query Builder
- an error that occurred when generating a trigger DML script
- 'The connection was not closed' error
- an Object Viewer bug
- an issue with saving an object in the Object Editor
- an error that occurred when working with statements containing the PIVOT/UNPIVOT clause
- an error that occurred when getting object metadata on Azure servers
- an issue with the hints behavior that occurred when changing the database context in the script using the USE statement
- the logic of handling the Description property for Azure SQL Database objects
- the logic of handling permissions in Schema Compare
- the permissions issues that occurred when comparing database objects with Schema Compare
- an error that occurred after linking a database in Source Control
- an object synchronization error in Schema Compare
- a bug that occurred when working with UDT
dbForge Studio for SQL Server Professional 6.3.9
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
- Fixed a syntax error that occurred when using built-in functions
- Fixed a bug in Table Editor that occurred when changing table options in a script
- Fixed a syntax error that occurred when accessing columns whose names match the names of the built-in functions
- Fixed a bug that occurred when working with Query Builder
- Fixed symbol duplication that occurred when placing separators (Insert Semicolon) in the script
- Fixed an issue with fetching data in Data Editor
- Added support for creating constraints on the computed columns in Table Editor
- Fixed a bug that occurred when working with Static Data in Source Control
dbForge Studio for SQL Server Professional 6.2.52
Fixed:
- an error that occurred when displaying database schema synchronization script
- an error that occurred when switching between the pages of the Link Database to Source Control wizard
- an error that occurred when connecting to the Azure server
- an issue with hinting objects in the CROSS APPLY context
- an issue with generating a Scripts Folder
- a false positive syntax check error
- an unexpected exception that occurred when dragging and dropping database objects
- a bug with editing functions
- the behavior of shortcuts in SQL Editor
- incorrect comparison of extended properties in Schema Compare
- static data processing in Source Control
- the processing of shortcuts for Outline commands
- an error in executing the Generate Script As command for a trigger
dbForge Studio for SQL Server Professional 6.2.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
- Improved the behavior of wildcard-aided search in a Schema Compare document
- Improved the display of the object type list in the filter window of a Schema Compare document
- Improved the grid display in the Monitor document
- Improved the logic of column width auto-adjustment in Data Editor
- Improved the diagnostics of false syntax errors in Query Builder
User-reported bug fixes:
- Fixed an issue that occurred when launching schema comparison
- Fixed the performance of the source control update operation
- Fixed an issue that occurred when working with static data in source control
- Fixed an issue with the formatting of spatial data types
- Fixed a text editor issue
- Fixed an issue that occurred when closing the application
- Fixed an issue that occurred when comparing data
- Fixed an index synchronization issue
- Fixed the performance of the commit and push operations in source control
- Fixed an issue that occurred when changing the database in a SQL document
- Fixed a command-line editor issue
- Fixed an issue with displaying a container header on a diagram
- Fixed a documentation generation issue
- Fixed an issue with displaying text comparison differences
- Fixed an issue that occurred when working with the file system
- Fixed an issue with displaying nodes in Database Explorer
- Fixed a data generation issue
- Fixed an issue that occurred when working with transactions during schema synchronization
- Fixed an issue with the installation package
- Fixed an issue with document generation for encrypted procedures and functions in Documenter
- Fixed an icon display issue in the Monitor document
- Fixed a log file initialization issue that occurred when opening the application
- Fixed an issue with the CONTRACT permission type in Security Manager
- Fixed an issue with the search and replacement of values in Data Editor
- Fixed an issue with creating a foreign key on a database diagram
- Added the capability to control the column width for text data in Profile Server Events
- Fixed a data filtering issue in Data Editor
- Fixed an issue that occurred when opening Data Compare
- Fixed the Close all unmodified command for object editors
- Fixed an issue that occurred when opening a Monitor document
- Fixed an unexpected exception that occurred when copying data to clipboard
- Fixed an application uninstallation issue
- Fixed an unexpected exception that occurred when creating data reports for non-SELECT scripts
- Fixed an unexpected exception that occurred when building dependencies for Queue objects while generating documentation
- Fixed an unexpected exception that occurred when describing database objects during search
- Fixed an unexpected exception that occurred when working under the Azure Active Directory connection
- Fixed an issue with the interception of external exceptions by SQL Tools
- Fixed an issue that occurred when performing Analyze Code for a script with NOCOUNT ON
- Fixed an issue with the display of differences in the XLS comparison reports in Data Compare
- Fixed an unexpected exception that occurred when generating HTML documentation
- Fixed the behavior of the Reseed Identity Columns option for Azure connections in Data Compare
- 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
- Fixed an unexpected exception that occurred when describing databases with identical names for Schema and Assembly objects in Documenter
- Fixed an issue with connecting a database to a version control system
- Fixed an issue with reading data from the server when executing a script
- Fixed false syntax errors
- 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
- Fixed an issue that occurred when inserting a drop-down list element into the text
- Fixed an issue with calculating the Parameter Info of a function that was referred to via a synonym
- Fixed a script formatting issue
- Fixed an issue that occurred when updating the database object cache for hints
- Fixed an issue that occurred when loading SSMS extensions
- Fixed the highlighting of the system statistical functions in SQL Editor
- Fixed a text editor issue on the Windows Build 22567 or later
- Fixed the behavior of the Parameter Info hint
- 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
- Fixed an issue that occurred when working with a data comparison document
- Fixed an issue that occurred when selecting view columns from its query
- 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
dbForge Studio for SQL Server Professional 6.1.14
New features and improvements:
- Support for the Execution step for the Jenkins, TeamCity, and Bamboo plugins
- Support for the UPDATETEXT, SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE, and SEMANTICSIMILARITYDETAILSTABLE functions
- Added the check constraints hints for the ALTER TABLE statements
- Support for the WAIT_AT_LOW_PRIORITY option for the ALTER TABLE ... SWITCH PARTITION statements
- Added the DISTRIBUTED_AGG hint for the SELECT - GROUP BY queries
- Added the suggestion of keywords for ALTER/DROP DATABASE SCOPED CREDENTIAL statements
- Added the suggestion of keywords for the ALTER DATABASE SCOPED CONFIGURATION statement
- Added the suggestion of keywords for MEMORY_OPTIMIZED in the ALTER SERVER CONFIGURATION statements
- Support for the CREATE/ALTER/DROP EVENT SESSION session_name ON DATABASE statements
- Support for Query Store options in the ALTER DATABASE statements
- Improved the behavior of data sorting in Data Editor
- Improved the display of table relationships on the Query Builder diagram
- Improved the error diagnosis when working with Source Control
- Added the ability to resize the search text field
- Added a warning when trying to save read-only files with the applied changes
Fixed:
- Excluded collations from elements falling into the category of identifiers when working out the Enclose identifiers within square brackets option (U36183154)
- search behavior for the UNIQUEIDENTIFIER columns
- unexpected exception thrown when creating a connection
- unexpected exception thrown when generating database documentation
- unexpected exception thrown when closing the SQL Document with the running Query Profiler
- unexpected exception thrown when running the application tracer
- an issue with saving changes in the table editor
- a request to get events in Event Profiler
- a definition of columns and data for importing data from a JSON file in which JSON properties are missing
- an issue that occurred when starting the application with the Object Viewer open and the Database Explorer closed
- an issue with getting the name of the branch for the Git repository
- the 'Connection Timeout' error in the SQL Document
- the 'The connection is closed' error in the SQL Document
- an issue with data export freezing on a database with a large quantity of objects
- an issue with reading comparison parameters in console mode in Data Compare
- a query execution error in the SQL Document in Data Compare
- an issue with using the object names mapping options in Data Compare
- an issue with defining unique keys when using object names in different registers in Data Editor
- a bug in the Link Database to Source Control wizard in Source Control
- an issue with synchronizing the list of connections to database servers
- an error in the document service that occurred when starting the application
- an issue with accessing partition functions for SQL Server 2000 Storage options in Object Editor
- an issue with generating Excel and HTML reports when the 'Hide unmodified columns' option is enabled in Data Compare
- the behavior of Code Completion on case sensitive servers
- false positives of Syntax Check
- an issue with calculating Quick Info
- an issue with launching Monitor
- an issue with highlighting associated IF/ELSE keywords
- an issue with calculating Parameter Info when accessing the procedure using a synonym
- an issue that occurred when performing Refresh Suggestions
- an issue with Output that occurred when working with SQL Tools versions integrated into SSMS
- an issue with data import through templates
- an issue with navigating to the similarly named triggers in different schemas
- an issue with calculating Parameter Info
- an issue with creating an incorrect tooltip for a connection element when starting the application
- an error that occurred with comparing data
- an issue with comparing user-defined object schemas that differ only in spaces
- an issue with reading data in the table editor
- an issue that occurred when comparing a database with the Script Folder
- an issue with synchronizing objects with data recovery when comparing schemas
- an issue with renaming a snippets folder
- an error that occurred when starting SSMS
- an issue that occurred when creating a connection with custom parameters
- an issue that occurred when starting the application
- an issue when starting the application with the opened Start Page
- an problem with poor performance when working with TFS
- the OutOfMemoryException error that occurred when synchronizing schemas
- an issue with generating a data comparison report in the XLS format
- an issue that occurred when closing the application
- a syntax error in the STRING_AGG construction
- an error that occurred when comparing a database with an empty folder
- an issue in Source Control when working with a case sensitive database server
- the behavior of keyboard shortcuts
- an error that occurred when starting the SQL Server Monitoring Tool
- an issue with zooming text in the SQL Server Monitoring Tool
- Returned the capability to insert a JOIN condition after an open parenthesis
dbForge Studio for SQL Server Professional 6.0.563
- The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update
dbForge Studio for SQL Server Professional 6.0.560
New features and improvements:
- Ability to simultaneously connect with different ApplicationIDs to Azure SQL Server
Fixed:
- Unexpected exception when selecting Style in Documenter on Azure connection (Z55517)
- Unexpected exception when changing a database on the connection
- Error during the data export to an Excel file (Z62513)
- Unexpected exception with the filter in Documenter
- Error during the data export through ODBC (Z57386)
- During data import, the values from default constraints for the columns of the target table were ignored
- Error during the data generation for the tables with composite primary keys
- Error with the integration of several add-ins
- Improved behavior of linking system databases in Source Control
- Error with updating a document in Source Control
- Error with getting a list of schemas on the SqlServer 2000
- Error with getting a list of files in the Browse for Folder window
- Error with canceling the operation in Data Editor
- Error with changing databases on the SQL Server connection
- Error with editing data for the selection from tables of different schemas in Data Editor
- Typos in the Filter window of Data Editor (Z59481)
- Error with closing a parallel connection in Data Editor (Z53577)
- Improved behavior with the active Paste As New Records command in Data Editor (p195068)
- Error when executing the Go To Definition command to a remote connection to the server
- Improved behavior of active control of changing the current database when executing the query in SQL Document
- Coloring of cells with the NULL values in Data Editor (Z57818)
- Error when completing the procedure with parameters in Data Editor (Z57682, Z61911)
- Error when executing a query with parameters of the Date type in Paginal Mode in Data Editor
- Error with specifying an incorrect value in the Filter window in Data Editor
- Error with updating transaction operations in a SQL Document
- Error with closing wizards when getting a list of databases
- Generation of a DDL trigger when executing a command from Database Explorer (Z56348)
- Description of the column in Database Explorer (p45705)
- Issue with deploying a tSQLt framework on the Azure SQL database (Z58747)
- Invalid response to syntax check (Z60052, Z59176, Z60241)
- Issue with saving changes in the procedure to the server (Z59244)
- Error with closing SQL documents (Z55637, Z58342)
- Error with updating a table
- Bug when scrolling the drop-down list with the mouse wheel
- Incorrect change of a query when updating it in Query Builder (p196244, Z60596)
- Bug when launching Data Compare from the command line
- Update of a procedure script after modification (Z56348)
- Processing of the Ctrl+A, Ctrl+C shortcuts in Data Viewer (Z56062)
- Bug with Commit in Source Control
- Added the ability to connect with MFA through a proxy (Z59810)
- Errors in the synchronization script in Schema Compare (Z55541)
- Bug when deleting a column in the table editor
- Handling of CTRL + 0 on the numeric keyboard (p194936)
- Error with synchronizing Extended Properties for views
dbForge Studio for SQL Server Professional 6.0.383
- ALTER for views was generated incorrectly
- Error with duplicating the max size for varchar, nvarchar, and varbinary when generating CREATE
- Critical error when reading metadata for an external table
- Error with processing a procedure during synchronization
- Temporary Schema Compare synchronization script files duplicated in Recent Files
- Error with closing the Data Comparison document
- Error with the report generation
- Critical error when processing mapping during comparison
- Mechanism of deletion of temporary folders
- Critical error with processing metadata for nullable columns
- Error with working with documents when closing the application
- Display of the 'Hide unmodified columns' button in the comparison document
- Issue with activation of the application
- Issue with opening SqlDocument when navigating from the Error List window
- Issue with the 'Create or Alter' command when copying to clipboard
- Issue with opening the trigger editor from another schema
- Query execution with USE in SqlDocument
- Behavior in the view editor when working with Query Design was tweaked
- Behavior when editing a query with comments in Query Builder was tweaked
- Inputting fractional values in the parameter editor when executing a procedure
- Error with working the TFS version control system
- Error with starting the application
- Error when changing the connection status in SqlDocument,
- Date and time formats for data editor were improved
- Option for enclosing identifiers within square brackets when generating scripts was added
- Incorrect parsing of types enclosed within square brackets
- Possible error with closing IDE with a floating document
- Customized toolbar buttons order was not restored after restarting IDE
- Code completion failed to suggest columns from CTE
- IFF function was not highlighted by the code editor
- Build step of Azure for Release pipeline failed to proceed
- IDE failed to parse specific complex scripts
- Incorrect syntax check for AT TIME ZONE clauses
- Code completion failed to suggest objects from schemas except for the default one
- Pressing Backspace within the search dialog led to the selection of the last character from the remaining text
- Text from the clipboard was pasted to incorrect locations in case of the multiline selection
- Error when exporting to ODBC Dynamics Driver
- Unexpected exception when saving document cache
- Exception occurred during the application activation
- Exit codes output in the command line for the unit testing functionality
dbForge Studio for SQL Server Professional 6.0.330
User-reported bug fixes:
- Error with loading the application with certain OS (Z49539, Z49498)
dbForge Studio for SQL Server Professional 6.0.237
The DevOps Automation feature:
Now dbForge Studio for SQL Server takes part in DevOps Automation. On the start page, in the DevOps tab, added links to install the following plugins:
- Plugin for Jenkins
- Plugin for TeamCity
- Plugin for Azure DevOps
- Plugin for Bamboo
- PowerShell module that helps with organizing database DevOps processes for your SQL Server databases. It allows you to develop, source-control, and safely automate the deployment of database changes by using dbForge for SQL Server tools via the PowerShell interface.
Connectivity improvements:
- Heroku Cloud connectivity support
- Display of the SQL Server version when testing connection
Code Completion improvements:
- Column sensitivity classification information available in the completion list and Quick Info
- Support for functions: NEWSEQUENTIALID, CERTPRIVATEKEY, CERTENCODED, PWDENCRYPT, PWDCOMPARE, MIN_ACTIVE_ROWVERSION
- Support for statement: GRANT ALTER ANY SECURITY POLICY
- Support for statement: GRANT ALTER ANY SENSITIVITY CLASSIFICATION
- Support for statement: GRANT ALTER ANY DATABASE SCOPED CONFIGURATION
- Support for statement: GRANT ALTER ANY COLUMN MASTER KEY
- Support for statement: GRANT ALTER ANY COLUMN ENCRYPTION KEY
- Support for statement: GRANT EXECUTE ANY EXTERNAL SCRIPT
- Support for statement: GRANT ALTER ANY EXTERNAL DATA SOURCE
- Support for statement: GRANT ALTER ANY EXTERNAL FILE FORMAT
- Support for statement: GRANT ALTER ANY EXTERNAL LANGUAGE
- Support for statement: GRANT ALTER ANY EXTERNAL LIBRARY
- Support for statement: GRANT ADMINISTER DATABASE BULK OPERATIONS
- Support for statement: CREATE/ALTER/DROP EXTERNAL LANGUAGE for SQL Server 2019
- Expanded support for the function PREDICT for SQL Server 2019
- Expanded support for CREATE USER for Azure SQL Database
- Expanded support for CREATE INDEX for SQL Server 2019
- Expanded support for CREATE EXTERNAL LIBRARY for SQL Server 2019
- Expanded support for ALTER DATABASE for SQL Server 2019
- Expanded support for ALTER TABLE for SQL server 2019
- Expanded support for ALTER EXTERNAL LIBRARY for SQL Server 2019
- Expanded support for ALTER AVAILABILITY GROUP for SQL server 2019
- Expanded support for DROP EXTERNAL RESOURCE POOL for SQL Server 2019
- Expanded support for DROP EXTERNAL LIBRARY for SQL Server 2019
- Expanded support for ACCELERATED_DATABASE_RECOVERY in ALTER DATABASE for SQL Server 2019
- Temporary tables suggestion
- OPENJSON objects suggestion
- Properties suggestion for built-in metadata functions
- Prompting hints names for the USE HINT option
- Prompting time zones in AT TIME ZONE
- Displaying MS_Description for SQL Azure database objects
- Prompting objects in the context of DBCC SHOW_STATISTICS
- New options suggestion for the ALTER DATABASE SCOPED CONFIGURATION statement
- Code Refactoring improvements:
- Converting stored routines execution into a script
- Unwrapping dynamic SQL into parameterized queries
- Find Invalid Objects to get to know if any objects are referencing objects that have been dropped and no longer exist in the database
- Code Navigation improvements:
- Jump between CASE/END
- Jump between BEGIN TRY/END TRY
- Jump between BEGIN CATCH/END CATCH
- Extend INSERT Highlight Occurrences feature to show a popup with the column name in the values area
- Code Execution improvements:
- Run a single script against multiple databases in parallel or serial mode
- Execution Warnings to warn of UPDATE or DELETE statements without a WHERE clause as well as TRUNCATE and DROP statements
- Export of execution history to CSV file format
SQL Formatter improvements:
- New formatting profiles introduced: Collapsed; Commas before; Compact; Extended; Indented; MSDN SQL; Right aligned; Stack compact
- Quick select formatting profile from context menu of SQL file
Data Editor improvements:
- Cached Updates Mode to defer posting updates to a table to a later time
- New Web view for Data Viewer
- Unified display of DATE in the Results Grid and Data Viewer
- Ability to customize colors for Data Viewer JSON view in the dark skin
- Export data from a data grid to the CSV, XML, HTML, and JSON formats
- Settings for the export data from a data grid to the CSV
- Copy data as CSV, XML, HTML, and JSON formats to clipboard as well as to a file
- Keyboard shortcut for the Apply Changes command
Data Export/Import improvements:
- Data Export/Import to Google Sheets
- Output Settings tab is added to Data Export Wizard
- Information about the export format is added to the Data Export Wizard header
- Remember the Save an Export Project checkbox value
Schema Compare improvements:
- Redesigned Progress Window for schema comparison and synchronization
- In-place SQL Formatting option for the text compare control
- Pre/Post-scripts execution tab in Schema Synchronization Wizard
- Append Timestamp to the File Name option in Schema Synchronization Wizard
- Colors for Modified, Added, and Deleted blocks are changed in the text compare control
Data Compare improvements:
- Redesigned Progress window for data comparison and synchronization
- Exclude newly added objects option in Data Compare Wizard
- Ignore Whitespaces option in Data Compare Wizard
- Tolerance Interval option in Data Compare Wizard
- Pre/Post-scripts execution tab in Data Synchronization Wizard
- Hide empty columns options for Only in Source and Only in Target view of Data Compare document
Data Generator improvements:
- Redesigned Progress Window for data generation
- Documenter improvements<
- Auto-line-break of long headings
Other improvements:
- Generate Script As for DML Commands
- Access to SQL Designer from the context menu is added
- Search for options is introduced
- Remember the size of the column properties window
- DevExpress controls updated to v20
- New vector HiDPI skins
User-reported and internal bug fixes:
- The "Arithmetic operation resulted in an overflow." issue is SQL Profiler (T310029)
- Unexpected exception occurred when generating data via the command line(T320298)
- The freeze when describing user database in Data Generator (T319445)
- Improved generation of data previews in the data generator for tables with composite indexes (T316409)
- Bug during generation of data preview in Data Import (T308286)
- Unexpected exception occurred during data generation for tables with circular dependencies (T278700)
- Improved object search. When editing a search query, a new search occurred according to the previous query (T304247)
- Changes to the Description field in the generated documentation were not saved in Documenter (T293113)
- Unexpected exception was thrown when opening any execution plan saved in SQL Server 2012 (T294320)
- Display of controls in dark skin in the table editor (T277001)
- Mapping settings when comparing data in backups (T323655)
- Critical parsing error (T312403)
- Error with displaying data in the Data Compare grid (T319144, T297723)
- Critical error with mapping when opening the data compare document (T306175)
- Error occurred in Comparison Wizard when connecting to TFS (T308893)
- Incorrect parsing of the FUNCTION parameters (T317519)
- An option to exclude versioned tables from comparison is added (T309869)
- Error with setting connection in the Script Folder creation form (T294568)
- Initial values were missing for SEQUENCE when retrieving DDL (T307257)
- Error with defining compatibility of the columnstore indexes when working with Azure SQL (T306938)
- Error with parsing DDL script of objects containing brackets (T303303)
- Script parsing error occurred (T283445)
- Incorrect synchronization script was generated when setting IDENTITY for the NOT NULL column (T275640)
- Data display in the Data Compare document (T268482)
- Generation of CREATE and CREATE OR ALTER scripts (T267680)
- Display of equal objects (T293657)
- The Insert Semicolons menu item put semicolons in wrong places making the script invalid (T323877)
- Incorrect behavior of the split/combined layout toggle when retrieving data for tables from Database Explorer (T318219)
- Code Completion did not suggest columns for table aliases (T304419, T305484)
- When selecting the dark color scheme and applying the dark mode in the Windows settings, the text in an SQL document remained black (T309895)
- The Edit.GotoBeginEnd command was missing from shortcuts configuration table
- Possible critical error after printing an SQL document (T317747)
- The Unexpected Object Already Exists errors were popping up frequently within the database objects editor (T304855)
- The procedure script was reformatted unexpectedly when trying to modify the latest (T304521)
- The multiline string was incorrectly highlighted within an SQL document
- The toolbar customizations are lost after restarting the program (T298461)
- The modify method for the XML data type was treated incorrectly by the syntax checker (T297890, T297936)
- Possible critical error within text comparison module when comparing database schemas (T297377, T297515, T297919, T298365, T298573,T302658, T304732, T305199, T305378, T305599, T306396, T309922)
- The FOR JSON clause was not allowed in the CURSOR statement (T289629, T320446, T314673)
- It was impossible to select multiple lines at once within an SQL document (T281370)
- The syntax checker did not accept user variables within the SEND statement (T283619)
- The syntax checker did not accept the FORCESEEK hint with the brackets
- Items in the completion list were scrolled by pixels but not rows, thus it was impossible to use mouse wheel for navigation (T280133)
- The formatter failed to process queries containing column aliases defined via the 'alias = column' syntax
- The Alt + R accelerator in the Find and Replace window did not work (T270967)
- The JSON_QUERY was not recognized correctly by the syntax checker (T266900)
- Incorrect statement was highlighted with the error marker when profiling specific statements (T264205)
- The WHERE keyword was not highlighted in case the JOIN condition was incomplete (T263709)
- Improved generation of DDL script of a trigger for the Modify command in Database Explorer (T318082)
- Error with defining the server version in (T309862, T309689)
- Description of the Schema Export options is improved (T313400)
- Error occurred when updating the values of the joined tables in Data Editor (Modif298178)
- Behavior with the window focus when executing queries in SQL document is tweaked (T294116)
- Error occurred when opening the Database Diagram file in the previous version (T294212)
- The work of the Filter Editor window in Data Editor is tweaked (T276373)
- Support for the SSDT folder structure in Script Folder and Source Control (T251625)
- Issue with connecting to the cloud Git repositories (T306465)
- Error when working with a SEQUENCE with large values (T281220)
- Improved performance when displaying data with a large number of columns (T283046, T289442)
- Formatting was disabled when generating the script objects script
- Error when executing SELECT queries with the FOR JSON clause (T244543, T264914, T272571)
dbForge Studio for SQL Server Professional 5.8.127
Bug fixes:
- Problem with Generate Script As on SQL Server 2019 is fixed
- Problem with connecting to azure managed instance is fixed
- Problem with freezing on refresh Source Folder is fixed
- Problem with displaying comperison result is fixed
- Other User-reported bugs are fixed
dbForge Studio for SQL Server Professional 5.8.107
Data Compare improvements:
- Redesigned data compare control
- Redesigned data comparison report window
- Redesigned data comparison report in CSV
Schema Compare improvements:
- Object filter
- Redesigned objects text diff control
- Redesigned schema comparison report window
- Redesigned schema comparison report in HTML
User reported bug fixes:
- Problem with execution of push command is fixed
- Problem with virtual relation on database diagram is fixed
- Problem with constraint renaming is fixed
- Problem with data view in data editor is fixed
- Other user reported bugs are fixed
dbForge Studio for SQL Server Professional 5.7.99
Fixed bugs:
- Problems with data refreshing in data editor are fixed
- NRE in view editor is fixed
dbForge Studio for SQL Server Professional 5.7.98
Fixed:
- Problem with connecting to GIT using proxy is resolved
- Problems with incorrect query generation are fixed
- Problem with procedure creating in the editor is fixed
- Problems with conneting to repository are fixed
- Problems with parser error are fixed
- Problems with opening database diagram are fixed
- Problems with saving changes when modifying an object in the object editor are fixed
- Other user reported bugs are fixed
dbForge Studio for SQL Server Professional 5.7.31
Connection:
- Support for the Active Directory - Universal with MFA authentication
Schema & Data Compare:
- Comparison performance improved dramatically
User reported bug fixes:
- Problem with column order is fixed
- Problem with wrong error messages is fixed
- Problem with lost user shortcuts is fixed
- Problem with check constraints is fixed
- Problems with drag and drop several tables to diagram are fixed
dbForge Studio for SQL Server Professional 5.6.104
Bugs fixed:
- Problems with a virtual relation on a database diagram
- Problem with the connection to Azure
- Problem with mapping a foreign key on a database diagram
- Problem with shortcuts
- Problem with wrong differences after data comparing
dbForge Studio for SQL Server Professional 5.6.62
SQL Server support:
- Connectivity support for SQL Server 2019
- Lots of Azure improvements implemented
Data Generator
- Foreign Key Generator for a group of unique table columns
Source Control:
- Support for TFS 2018
User reported bug fixes:
- Synchronization issue using command line is fixed
- Problem with false different records is fixed
- Problem with view renaming is fixed
- Problem with script generating for system-versioned table is fixed
- Problem with connect to TFS is fixed
- Problem with inserting data in data editor is fixed
- Problem with editing table structure is fixed
- Problem with renaming file for data export to CSV is fixed
- Problem with documentation generation is fixed
- Problem with object duplicate is fixed
- Problems with activation are fixed
- Other user reported bugs are fixed
dbForge Studio for SQL Server Profesional 5.5.369
- Problem with popup menu in database explorer is fixed
- OperaOpera 115.0 Build 5322.109 (64-bit)
- 4K Download4K Video Downloader+ 1.10.3 (64-bit)
- PhotoshopAdobe Photoshop CC 2025 26.2 (64-bit)
- OKXOKX - Buy Bitcoin or Ethereum
- iTop VPNiTop VPN 6.2.0 - Fast, Safe & Secure
- Premiere ProAdobe Premiere Pro CC 2025 25.1
- BlueStacksBlueStacks 10.41.642.1001
- Hero WarsHero Wars - Online Action Game
- TradingViewTradingView - Trusted by 60 Million Traders
- LockWiperiMyFone LockWiper (Android) 5.7.2
Comments and User Reviews