dbForge Studio for SQL Server

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