dbForge Studio for SQL Server History

7.0.249 14-Nov-24

User-reported bug fixes

Resolved a parsing issue where SQLCMD commands were treated as procedure names, leading to the use of incorrect parsing logic (D165998, D170973)
Fixed an issue that occurred when processing queries containing JOIN clauses (D164868, D166392)

7.0.210 18-Oct-24

User-reported bug fixes

Fixed an issue that caused dbForge Studio for SQL Server to freeze when parsing expressions with multiple nested function calls (D161799)
Fixed an issue that occurred when working with revision files that have spaces in their paths (D164349)
Improved the activation behavior of the Data tab in SQL Document when the Activate Data Editor after query execution option is enabled (D118496, D130770)
Fixed an issue that occurred when calling the Generate Script As SELECT command on SQL Server 2000 (D164557)
Added Syntax Check in Object Editor for procedures and functions (D161298)
Fixed an issue that occurred when searching for objects after changing the connection (D159340)
Fixed an issue where Security Policy lost dependency on views and added support for building predicates for views (D159546)
Fixed an error that occurred when editing a period column of a temporal table (D164462, D166056)
Improved the display of object lists in text tooltips (D164344, D164397, D164557, D164588, D164636, D164684, D164348, D165956, D167214, D168271, D168964)
Improved the handling of delimiters during object script generation (D165858, D168125)

7.0.158 05-Sep-24

T-SQL Code Analyzer

Updated T-SQL Code Analyzer with new rules

Connectivity

Renamed the Azure Active Directory authentication type to Microsoft Entra ID
Added support for ApsaraDB

DevOps & CLI Automation

Added support for Atlassian Bamboo Data Center
Added CLI automation for Find Invalid Objects
Added Save Command Line for Index Manager
Added generation of comparison reports from the command line

Code Completion

Added support for non-aggregated columns in GROUP BY statements
Added support for viewing the MSDescription property for databases
Added support for the PERSISTENT_LOG_BUFFER construct in CREATE DATABASE statements
Added support for the RSA_OAEP algorithm in CREATE COLUMN ENCRYPTION KEY statements
Added support for the COLUMN MASTER KEY server object
Added support for T-SQL graph functions: EDGE_ID_FROM_PARTS, GRAPH_ID_FROM_EDGE_ID, GRAPH_ID_FROM_NODE_ID, NODE_ID_FROM_PARTS, OBJECT_ID_FROM_EDGE_ID, and OBJECT_ID_FROM_NODE_ID
Added support for the TERTIARY_WEIGHTS function
Extended support for the AVAILABILITY GROUP constructs
Support for Implicit Procedure Execution

Schema Compare

Added the Show Ignored Differences option for schema comparison
Added a new shortcut ALT+(arrow down) that allows going to each subsequent difference in a schema comparison document
Added support for the ADD SENSITIVITY CLASSIFICATION command
Added a new Issues page in Schema and Data Synchronization Wizards
Added a new index option STATISTICS_INCREMENTAL
Added a new group of options called Sequences, comprising Ignore START WITH in sequences and Ignore MIN VALUE in sequences
Added new comparison options: Ignore MIN VALUE, Ignore START WITH, Ignore CYCLE, Ignore INCREMENT BY, and Ignore CACHE

Source Control

Added support for XML and HASH indexes for Azure
Added support for the PERSISTED construct for table variables
Added a Hide empty columns button in the static data diff grid

Database Diagrams

Updated the design of database diagrams with new element skins, opacity controls, and linear zoom factor
Added a new option Clear Waypoints
Added a new option Select All Relations

SQL Query History

Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button
Added the ability to save user-defined column layouts in Query History

Documents

Added options to rearrange tab opening order
Added new options in Tabs and Windows: Tab layout, Show tabs in multiple rows, and Close tabs with middle-click
Added a new option Open Data in Editor
Added a new shortcut CTRL+SHIFT+/ that comments selected pieces of code

Database Explorer

Added the ability to save filter settings for tables in Database Explorer to a file
Added a new option Drop destination object to Duplicate Object
Added support for Search Property Lists in Azure SQL Database

Data Generator

Added a new option Append timestamp to the file name in Data Population Wizard
Added new shortcuts to facilitate search for the required tables and columns

Script Generation

Added automated wrapping of CRUD templates into named regions
Added new options to Generate Scripts: Script DML triggers, Script security permissions, and Script authorization

Data Editor

Added an option to set a cell value to a unique identifier from the shortcut menu

Pivot Tables

Upgraded Chart Designer to a more advanced version with an improved appearance

Find Invalid Objects

Added new buttons Check All and Uncheck All to facilitate selection of databases

Search

Implemented export of search results to CSV

Index Manager

Implemented a shortcut menu to help quickly arrange, sort, group, and filter entries in the grid

Application Startup Time

Added application startup duration to be displayed alongside the startup timestamp

User-reported bug fixes

Fixed the display of the database node icon in the Database Explorer (D98541)
Fixed the shortcut behavior for the Results as Text functionality (D127047)
Extended the retention period for executed SQL queries to 10 years (D130168)
Fixed an error that occurred when editing a query using the Data Report functionality (D132163)
Fixed an error that occurred when opening the context menu on the Constraints tab of the Table Editor (D134602)
Fixed the shortcut functionality for activating SQL Document views (D134564)
Fixed the functionality for restoring open documents when changing the product edition (D139452)
Fixed the functionality for comparing string data containing the backslash character (D135825)
Fixed the behavior of the Go To Definition functionality when using an Azure AD MFA connection (D140894)
Fixed internal application error (D134083)
Improved the functionality for loading the database documentation document when there is no connection (D149128)
Fixed the Query History error that occurred after importing application settings (D113134)
Fixed an issue with reading old snapshots: the synchronization script now executes correctly, ensuring databases are equal after comparison (T264848)
Optimized the parser to reduce CPU load (D51581)
Optimized the algorithm for finding links between declared objects (D101339)
Fixed the display for user datatypes in Database Explorer for the User_Data_Type_Name (Native_Type) columns (D110365)
Changed the default setting for the Find and Replace functionality from "All Open Documents" to "Current Document" (D119376, D120733, D121139, D136325)
Fixed the error report during data export using ODBC when the ODBC connection is closed (D127150, D147616)
Fixed the behavior of formatting via the command line that differed from the formatting in the SQL document due to an unknown ansi_quotes state (D132092)
Fixed the behavior of formatting via the command line that differed from the formatting in SQL Document due to an unknown ansi_quotes state (D132092)
Fixed the parsing of functions with the GROUPING expression (D134900)
Fixed a search error in the Source Control functionality (D133718)
Fixed the display of the number of mapped columns on the Table Mapping page of the Schema Comparison Wizard (D136752)
Fixed an issue with parsing JOIN expressions (D132774, T277481)
Added a wait time for retrieving the list of columns (D134892)
Fixed the error report during data export via command line using ODBC when the ODBC connection is closed (D127150)
Fixed data export via ODBC for existing tables (D127150)
Fixed an issue preventing the deletion of the import file after import (D140100)
Enabled renaming of table names when exporting data to Excel (u47439308)
Resolved the error report issue in the Database Documenter (D141365)
Fixed the display of warnings in the Plan Diagram functionality (D136772)
Fixed the Failed to perform the syntax action error [524297] (D143086, D143350)
Fixed the error report during data export via command line using ODBC when the ODBC connection is closed (D127150)
Fixed data export via ODBC for existing tables (D127150)
Fixed the construction of queries with JOIN expressions in the Query Builder (D146358)
Fixed data import from CSV files (D150169)
Updated shortcuts to match the SSMS schema (T147971)
Added support for selecting multiple files in the Restore wizard (p177814)
Enabled text editing for multi-line selections with the Shift+Alt shortcut (T324921)
Fixed an error that occurred when displaying External Data Source objects in the Object Viewer (T292377)
Significantly improved performance when selecting table column checkboxes in Query Builder (D58143)
Resolved issues with matching the output to the JSON format in data export (D161343)
Fixed the display of table properties for Azure servers in Documenter (T315047)
Added support for the ApplicationName parameter in server connection settings (D93629)
Fixed the error accessing the sql_expression_dependencies view with restricted user permissions in Source Control (D120039)
Expanded the list of conditions in the Filter Editor for string data types in Data Editor (D121088)
Fixed the occasional error updating commands in SQL Document (D129941)
Fixed the error retrieving metadata for server objects in Source Control (D151850)
Resolved the issue with large or boundary values for Sequences properties (D134574)
Added support for displaying External Login and External Group objects in the Security Manager Explorer (D139263, D140392, D141986, D146748, D147384)
Fixed the occasional error in the Object Search functionality (D141088)
Fixed the parser error for view definitions with a large number of JOINs (D140616)
Improved DDL object comparison - the Ignore white spaces option no longer affects literal comparisons (D135726, D143099)
Fixed an issue that caused custom server connection locations to reset in the Database Explorer (D142533)
Resolved an issue with extra blank lines appearing in DDL when committing procedures and functions in Source Control (D144110, D148188)
Set the Append timestamp to the file name checkbox to be selected by default in the Data Export wizard (D115315)
Resolved an issue with describing server objects in Source Control (D148259)
Addressed the Execution Timeout Expired error that occurred during query execution (D144548)
Fixed an issue with renaming indexes in the Database Explorer and Object Editor (D152529)
Addressed the issue with incorrect data editing locks in Data Editor (D153084)
Resolved an issue with dependency search for views that contain the PIVOT clause in the SELECT statement (D123540)
The Disable check constraints option now respects server restrictions and no longer removes NOT NULL from columns where it is restricted (D155250)
Improved parsing of ORDER BY expressions in subqueries (D149478, D148304)
Improved the behavior of the Round float types up to X digits option (D135833)
Fixed an issue with the synchronization button being inactive when the Comparison toolbar was hidden (D144406)
Fixed the shortcut functionality for the GoToBraceExtend command (D146853)
Added support for selecting quoted identifiers with a double-click (D144429, D103331)
Added support for Backup, Restore, and Attach Database operations from removable media (D140566)
Fixed the object suggestions in the Completion List for large queries (D136746)
Resolved an issue with renaming objects in SQL Azure Database (D132068, D133629)
Changed the data output for reports in Data Compare-reports now include original values without quotes and formatting (D131831)
Fixed an error that occurred when describing the schema during script folder creation (D88738)
Optimized schema description in Data Compare-non-schema-bound views are now read only when the Compare views option is enabled (T305596)
Fixed an issue with extended properties missing N prefixes for Unicode values (u36182551)

6.6.5 12-Apr-24

User-reported bug fixes

Fixed an error associated with importing data from JSON (D148492)
Fixed an issue that occurred when comparing text source objects in Source Control

6.5.140 28-Dec-23

Code Completion improvements

Added support for the CREATE TABLE AS SELECT statement in Azure Synapse

User reported bug fixes

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

6.5.16 12-Jul-23

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 (D121052)
Resolved an error related to reading server event profiling templates (D116911)
Fixed an error that occurred when the SQL document was closed while processing the parameter list for functions (D124026)
Fixed an error that could occur when launching the synchronization wizard in Schema Compare (D123931)
Resolved an error that occurred when trying to open Security Manager while connected to SQL Server 2022 (D114821, D124984, D105374)
Expanded the list of conditions in the Filter Editor for columns of type int in the Data Editor (D121088)
Fixed an error that occurred when debugging a script containing a system procedure (D119466)
Resolved a freezing issue that occurred when editing values in large tables in Data Editor (D117549)
Improved the reading of JSON files, detection of NULL values, and error handling within the Data Import feature (D113524)
Fixed a false warning in the Data Editor that incorrectly indicated missing unique keys for SQL Server 2000 (D107866)
Fixed an issue with sudden crashes that occurred during complex script editing (D121390)

6.4.124 12-May-23

User-reported bug fixes

Added DML triggers sorting in Source Control
Added 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 (D112390)
Fixed an issue that occurred when displaying the informational window (D113970, D113980)
Fixed an issue with the text search across DDL objects in Object Search (D100434)
Fixed an error that occurred when using the Google Sheets data export template (D116015)
Fixed the behavior of the Ignore History Table option
Fixed the display of the datetime data type in the data comparison grid (D105732)
Fixed the display of the Generate Script As command for an empty table
Supported the EXEC command in Syntax Check (D115075)

6.4.7 30-Dec-22

New features

Optimized system resources consumption when preparing the Quick Info and Code Completion hints
Support for macOS & Linux via CrossOver

Improvements

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 (D105577)
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/cut the entire line of text if nothing is selected
Implemented the output of the original text of the view object for the Modify command (D100805)
Improved the metadata reading behavior - the VIEW DATABASE STATE privilege is no longer required (p135909, T308355, D71423, D98539, D103313)
Improved formatting under the Text Case - Identifier Case - As in the Database configuration (D95432)
Improved syntax check (D97235)
Improved query profiling on SQL Server 2019/2022 (p219550)
Improved the Backups report in Monitor (D89312)
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 (D95432)

User-reported bug fixes

Fixed an issue with extended properties in Source Control
Fixed a bug that occurred when importing data (D99244, D99762)
Fixed a bug that occurred when configuring the Table or View generator (D89788)
Fixed the Data Editor issue with the UID data type (D93895)
Fixed the Window menu bug (p218671, D104072)
Fixed the behavior of saving changes in the Table Editor (D93895)
Fixed a bug that occurred after closing the SQL document (D107952)
Fixed the 'Database files are not found' error in Transaction Log (D97365)
Fixed the export of boolean values to JSON format (D99831, D99914)
Fixed a bug that occurred when creating a comparison report in Data Compare
Fixed text color in the ODBC data export grid (D104127)
Fixed a bug that occurred when executing the Generate Script As command (D107166)
Fixed the disappearance of the DESC keyword in Query Builder
Fixed an error that occurred when generating a trigger DML script (D97458)
Fixed 'The connection was not closed' error (D96327)
Fixed an Object Viewer bug (D87706)
Fixed an issue with saving an object in the Object Editor (D86972)
Fixed an error that occurred when working with statements containing the PIVOT/UNPIVOT clause (D95760, D95759, D96164, D100368)
Fixed an error that occurred when getting object metadata on Azure servers (D92385)
Fixed an issue with the hints behavior that occurred when changing the database context in the script using the USE statement (D93742)
Fixed the logic of handling the Description property for Azure SQL Database objects (D92854)
Fixed the logic of handling permissions in Schema Compare (D93289)
Fixed the permissions issues that occurred when comparing database objects with Schema Compare
Fixed an error that occurred after linking a database in Source Control
Fixed an object synchronization error in Schema Compare (D96984)
Fixed a bug that occurred when working with UDT

6.3.9 12-Sep-22

General

Connectivity support for SQL Server 2022 CTP 2.1

Expanded keyword suggestions

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

New query hints and syntax constructs

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

Improvements

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

User-reported bug fixes

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

6.2.52 20-Jul-22

User-reported bug fixes

Fixed an error that occurred when displaying database schema synchronization script (D81624)
Fixed an error that occurred when switching between the pages of the Link Database to Source Control wizard
Fixed an error that occurred when connecting to the Azure server
Fixed an issue with hinting objects in the CROSS APPLY context (D87172)
Fixed an issue with generating a Scripts Folder (D88738)
Fixed a false positive syntax check error
Fixed an unexpected exception that occurred when dragging and dropping database objects
Fixed a bug with editing functions (D83115)
Fixed the behavior of shortcuts in SQL Editor (D86899)
Fixed incorrect comparison of extended properties in Schema Compare
Fixed static data processing in Source Control
Fixed the processing of shortcuts for Outline commands (D86402)
Fixed an error in executing the Generate Script As command for a trigger

6.2.22 17-Jun-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 (D74074)
Improved the behavior of wildcard-aided search in a Schema Compare document (D71799)
Improved the display of the object type list in the filter window of a Schema Compare document (D71952)
Improved the grid display in the Monitor document (D82617)
Improved the logic of column width auto-adjustment in Data Editor (D76074, D78214, D82337, D84156, D84627, D87466)
Improved the diagnostics of false syntax errors in Query Builder (D79276)

User-reported bug fixes

Fixed an issue that occurred when launching schema comparison (T324200)
Fixed the performance of the source control update operation (D62771, D84389)
Fixed an issue that occurred when working with static data in source control (D69566)
Fixed an issue with the formatting of spatial data types (D68908)
Fixed a text editor issue (D73356)
Fixed an issue that occurred when closing the application (D73602)
Fixed an issue that occurred when comparing data (D75075, D75682, D76230, D85145)
Fixed an index synchronization issue (D79101)
Fixed an issue that occurred when changing the database in a SQL document (D88476)
Fixed a command-line editor issue (D77983)
Fixed an issue with displaying a container header on a diagram (D77624)
Fixed a documentation generation issue (D75272)
Fixed an issue with displaying text comparison differences (D76473, D83707)
Fixed an issue that occurred when working with the file system (D75991, D88984)
Fixed an issue with displaying nodes in Database Explorer (D75991, D88984)
Fixed a data generation issue (D75991, D88984)
Fixed an issue that occurred when working with transactions during schema synchronization (D75991, D88984)
Fixed an issue with the installation package (D84256)
Fixed an issue with document generation for encrypted procedures and functions in Documenter (D86286)
Fixed an icon display issue in the Monitor document (D83386)
Fixed a log file initialization issue that occurred when opening the application (D78127, D78128, D78072, D77961, D77910, D77911, D77907, D77906, D78249, D78275, D78319, D78405, D79517, D79551, D79665, D79663, D79664)
Fixed an issue with the CONTRACT permission type in Security Manager (D77323)
Fixed an issue with the search and replacement of values in Data Editor (D76642)
Fixed an issue with creating a foreign key on a database diagram (D76810)
Added the capability to control the column width for text data in Profile Server Events (D76014)
Fixed a data filtering issue in Data Editor (D74786, D78200)
Fixed an issue that occurred when opening Data Compare (D73600)
Fixed the Close all unmodified command for object editors (D70727)
Fixed an issue that occurred when opening a Monitor document (D69989)
Fixed an unexpected exception that occurred when copying data to clipboard (D75685, D84443)
Fixed an application uninstallation issue (D75346)
Fixed an unexpected exception that occurred when creating data reports for non-SELECT scripts (D77960)
Fixed an unexpected exception that occurred when building dependencies for Queue objects while generating documentation (D75272)
Fixed an unexpected exception that occurred when describing database objects during search (D74812)
Fixed an unexpected exception that occurred when working under the Azure Active Directory connection (D77811)
Fixed an issue with the interception of external exceptions by SQL Tools (D77546, D77547, D77546, D77458, D79376, D83397, D86339)
Fixed an issue that occurred when performing Analyze Code for a script with NOCOUNT ON (D74550)
Fixed an issue with the display of differences in the XLS comparison reports in Data Compare (D79090)
Fixed an unexpected exception that occurred when generating HTML documentation (D77497)
Fixed the behavior of the Reseed Identity Columns option for Azure connections in Data Compare (D78869)
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 (D79913)
Fixed an unexpected exception that occurred when describing databases with identical names for Schema and Assembly objects in Documenter (D81020, D83545)
Fixed an issue with connecting a database to a version control system (D69263, D71773)
Fixed an issue with reading data from the server when executing a script
Fixed false syntax errors (D75130, D78201, D76897, D79825, D86199, D87556)
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 (D78330, D76412, D88199, D73070)
Fixed an issue that occurred when inserting a drop-down list element into the text (D75243)
Fixed an issue with calculating the Parameter Info of a function that was referred to via a synonym (D77735)
Fixed a script formatting issue (D76716, D88775)
Fixed an issue that occurred when updating the database object cache for hints (D75246, D76809)
Fixed an issue that occurred when loading SSMS extensions (D79550, D79846, D82952, D82953, D83099, D83113, D83332)
Fixed the highlighting of the system statistical functions in SQL Editor (D79825)
Fixed a text editor issue on the Windows Build 22567 or later (D81452, D81480, D81767)
Fixed the behavior of the Parameter Info hint (D73805)
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 (D79666)
Fixed an issue that occurred when working with a data comparison document (D81953)
Fixed an issue that occurred when selecting view columns from its query (D80547)
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 (D86209, D87487)

6.1.14 21-Dec-21

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 (D67473)
Improved the display of table relationships on the Query Builder diagram
Improved the error diagnosis when working with Source Control (D53631)
Added the ability to resize the search text field (D62750)
Added a warning when trying to save read-only files with the applied changes (D69226)

User-reported bug fixes

Excluded collations from elements falling into the category of identifiers when working out the Enclose identifiers within square brackets option (U36183154)
Fixed search behavior for the UNIQUEIDENTIFIER columns
Fixed unexpected exception thrown when creating a connection
Fixed unexpected exception thrown when generating database documentation
Fixed unexpected exception thrown when closing the SQL Document with the running Query Profiler (D63649)
Fixed unexpected exception thrown when running the application tracer (D65699)
Fixed an issue with saving changes in the table editor (D65875)
Fixed a request to get events in Event Profiler (D61344)
Fixed a definition of columns and data for importing data from a JSON file in which JSON properties are missing
Fixed an issue that occurred when starting the application with the Object Viewer open and the Database Explorer closed
Fixed an issue with getting the name of the branch for the Git repository (D72020)
Fixed the 'Connection Timeout' error in the SQL Document (D70626)
Fixed the 'The connection is closed' error in the SQL Document (D67071)
Fixed an issue with data export freezing on a database with a large quantity of objects (D69906)
Fixed an issue with reading comparison parameters in console mode in Data Compare
Fixed a query execution error in the SQL Document in Data Compare
Fixed an issue with using the object names mapping options in Data Compare (D63567)
Fixed an issue with defining unique keys when using object names in different registers in Data Editor (D62788, D64041, D72841)
Fixed a bug in the Link Database to Source Control wizard in Source Control
Fixed an issue with synchronizing the list of connections to database servers
Fixed an error in the document service that occurred when starting the application
Fixed an issue with accessing partition functions for SQL Server 2000 Storage options in Object Editor
Fixed an issue with generating Excel and HTML reports when the 'Hide unmodified columns' option is enabled in Data Compare (D64284)
Fixed the behavior of Code Completion on case sensitive servers (D60623)
Fixed false positives of Syntax Check (D62561, D62657, D60973, D63678, D66470, D64267, D67458, D66843, D67785, D68835, D69263)
Fixed an issue with calculating Quick Info (D60901)
Fixed an issue with launching Monitor (D62856)
Fixed an issue with highlighting associated IF/ELSE keywords (D63180)
Fixed an issue with calculating Parameter Info when accessing the procedure using a synonym
Fixed an issue that occurred when performing Refresh Suggestions (D64316)
Fixed an issue with Output that occurred when working with SQL Tools versions integrated into SSMS (D61727, D71212)
Fixed an issue with data import through templates (D38859)
Fixed an issue with navigating to the similarly named triggers in different schemas (D64267)
Fixed an issue with calculating Parameter Info
Fixed an issue with creating an incorrect tooltip for a connection element when starting the application (D57177)
Fixed an error that occurred with comparing data (D62718)
Fixed an issue with comparing user-defined object schemas that differ only in spaces (D67700, D67719, D61019, D63262, D66282)
Fixed an issue with reading data in the table editor (D65022, D68332)
Fixed an issue that occurred when comparing a database with the Script Folder (D65701, D66830)
Fixed an issue with synchronizing objects with data recovery when comparing schemas (D67275, D74100, D63960)
Fixed an issue with renaming a snippets folder (D63346)
Fixed an error that occurred when starting SSMS (D63430, D63691, D64227, D65835, D73719, D74067, D74157, D74403, D74538, D74539, D74540)
Fixed an issue that occurred when creating a connection with custom parameters
Fixed an issue that occurred when starting the application (D65371)
Fixed an issue when starting the application with the opened Start Page (D64626)
Fixed an problem with poor performance when working with TFS
Fixed the OutOfMemoryException error that occurred when synchronizing schemas
Fixed an issue with generating a data comparison report in the XLS format
Fixed an issue that occurred when closing the application (D66790)
Fixed a syntax error in the STRING_AGG construction (D66843)
Fixed an error that occurred when comparing a database with an empty folder (D65701, D66830)
Fixed an issue in Source Control when working with a case sensitive database server (D60192)
Fixed the behavior of keyboard shortcuts
Fixed an error that occurred when starting the SQL Server Monitoring Tool (D66673)
Fixed an issue with zooming text in the SQL Server Monitoring Tool (D63946)
Returned the capability to insert a JOIN condition after an open parenthesis (D64037)

6.0.563 20-Oct-21

User-reported bug fixes

The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update

6.0.560 10-Sep-21

New features and improvements

Ability to simultaneously connect with different ApplicationIDs to Azure SQL Server

User-reported bug fixes

Unexpected exception when selecting Style in Documenter on Azure connection (D55517)
Unexpected exception when changing a database on the connection
Error during the data export to an Excel file (D62513)
Unexpected exception with the filter in Documenter
Error during the data export through ODBC (D57386)
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 SQL Server 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 (D59481)
Error with closing a parallel connection in Data Editor (D53577)
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 (D57818)
Error when completing the procedure with parameters in Data Editor (D57682, D61911)
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 (D56348)
Description of the column in Database Explorer (p45705)
Issue with deploying a tSQLt framework on the Azure SQL database (D58747)
Invalid response to syntax check (D60052, D59176, D60241)
Issue with saving changes in the procedure to the server (D59244)
Error with closing SQL documents (D55637, D58342)
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, D60596)
Bug when launching Data Compare from the command line
Update of a procedure script after modification (D56348)
Processing of the Ctrl+A, Ctrl+C shortcuts in Data Viewer (D56062)
Bug with Commit in Source Control
Added the ability to connect with MFA through a proxy (D59810)
Errors in the synchronization script in Schema Compare (D55541)
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

6.0.470 16-Jun-21

User-reported and internal bug fixes

Issue with the export of data to Excel 2007 (D53493)
Problem with getting metadata for PARTITION FUNCTION in Documenter (D52462)
Problem with getting index metadata in Documenter (D54163)
The button to call the dialog window for saving the export file in the Data Export Wizard was restored (D53562)
Issue with Syntax Check detecting an error in the correct query that uses string_agg function (D56325, D57163)
Issue with Syntax Check detecting an error in the correct CTE with CHANGE_TRACKING_CONTEXT clause (D55892)
Issue with Syntax Check treating incorrectly the identifiers delimited by double quotation marks (D55000)
Visual Editor failure with identical names of table components (T318602)
Application failure on showing Parameter Info (D54136)
The shortcut Alt+X for the Execute command was added to the Microsoft SQL Server Management Studio keyboard scheme (D52976)
Visual Editor failure on editing a table-valued function (D52479)
The Close All Unmodified command didn't work (D51741)
Application failure on displaying the Quick Info hint (D51490, D51581)
SQL Editor failure to highlight the fragments of the script (T321082)
Query Builder failure to open Document Outline pane (T321742)
Issue with renaming aliases (T316445)
Critical error when reading NULL values from metadata query results (D54216, D54216, D56849)
Possible conflicts between assembly versions (D52876)
Problem with reading values from the is_nested_triggers_on column (D3832, D54581, D54856, D54881)
Incorrect behavior of the mask editor for filtering columns in the Data Comparison wizard (D51233)
Critical error when reading metadata for PARTITION FUNCTION (p52354)
Error when parsing a stored procedure (D52442)
Error with Extended Properties synchronization (D52288)
Issue with pasting data from Clipboard into Data Editor (D56101)
Issue with multiple errors handling in the Refresh operation in Source Control (D52766, D52765)
Object Viewer now supports the External table object type (D49588)
Issue with setting a database in the Foreign Key Lookup window in Data Editor
The support for the command to show and hide the additional view of the SQL Document window and the default shortcut Ctrl+R were added (T310489, T311598, T313831, T314664, T316210, T316330)
Error with describing indexes in Source Control, Documenter, and SQL Complete (D54114)
Error handling when connecting to Active Directory was improved (analytics)
The connection behavior in Database Explorer on connection failure was improved (D51306)
Issue with focusing on active view when switching between documents (D49633)
Problem with displaying data when sorting in Data Editor (D50393)
Incorrect behavior of the Enable Shadows option in Query Builder (D50877)

6.0.383 08-Apr-21

User-reported and internal bug fixes

ALTER for views was generated incorrectly (D50117)
Error with duplicating the max size for varchar, nvarchar, and varbinary when generating CREATE (D50864)
Critical error when reading metadata for an external table (D49588)
Error with processing a procedure during synchronization (D49768)
Temporary Schema Compare synchronization script files duplicated in Recent Files
Error with closing the Data Comparison document (D49634)
Error with the report generation (D49812)
Critical error when processing mapping during comparison (T323990, T325780)
Mechanism of deletion of temporary folders
Critical error with processing metadata for nullable columns (D49618)
Error with working with documents when closing the application (T318978)
Display of the 'Hide unmodified columns' button in the comparison document (D49665)
Issue with activation of the application (T315315)
Issue with opening SqlDocument when navigating from the Error List window (T325542)
Issue with the 'Create or Alter' command when copying to clipboard (D51024)
Issue with opening the trigger editor from another schema (D51545)
Query execution with USE in SqlDocument (D50513)
Behavior in the view editor when working with Query Design was tweaked (D50392, D51024)
Behavior when editing a query with comments in Query Builder was tweaked (D49999)
Inputting fractional values in the parameter editor when executing a procedure (D49702)
Error with working the TFS version control system (D48453)
Error with starting the application (T309571)
Error when changing the connection status in SqlDocument (T309932, T310344, T315727)
Date and time formats for data editor were improved (D51303)
Option for enclosing identifiers within square brackets when generating scripts was added (T325976)
Incorrect parsing of types enclosed within square brackets (D49781)
Possible error with closing IDE with a floating document (T312231)
Customized toolbar buttons order was not restored after restarting IDE
Code completion failed to suggest columns from CTE (D49633)
IFF function was not highlighted by the code editor (D49633)
Build step of Azure for Release pipeline failed to proceed (D49798)
IDE failed to parse specific complex scripts (D49781)
Incorrect syntax check for AT TIME ZONE clauses (D49282)
Code completion failed to suggest objects from schemas except for the default one (D49165)
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 (D50724)
Unexpected exception when saving document cache (T305769)
Exception occurred during the application activation (T316455)
Exit codes output in the command line for the unit testing functionality

6.0.330 25-Feb-21

User-reported bug fixes

Error with loading the application with certain OS (D49539, D49498)

6.0.237 23-Feb-21

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 (T298178)
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)

5.8.127 02-Jun-20

User-reported bug fixes

Problem with Generate Script As on SQL Server 2019 is fixed (T307185, T307074, T308312)
Problem with connecting to azure managed instance is fixed (T297967)
Problem with freezing on refresh Source Folder is fixed (T293433)
Problem with displaying comparison result is fixed (T277907, T277941)
Other User-reported bugs are fixed (T306139, T307733, T309221, T307914, T269638, T304872, T304901, T302787, T298055, T297493, T297275, T294154)

5.8.107 10-Oct-19

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 (T292846)
Problem with virtual relation on database diagram is fixed (T288965)
Problem with constraint renaming is fixed (T286474)
Problem with data view in data editor is fixed (T284175)
Other User-reported bugs are fixed (T284451, T284262)

5.7.99 09-Jul-19

User-reported bug fixes

Problems with data refreshing in data editor are fixed (T285600, T285647, T285758, T286030, T286024, T285711, T285689, T285731,T285795, T285808, T285865)
NRE in view editor is fixed (T284100)

5.7.98 27-Jun-19

User-reported bug fixes

Problem with connecting to GIT using proxy is resolved (T277904)
Problems with incorrect query generation are fixed (T283725, T282337)
Problem with procedure creating in the editor is fixed (T282922)
Problems with connecting to repository are fixed (T282216, T284863)
Problems with parser error are fixed (T282922, T276299)
Problems with opening database diagram are fixed (T278476, T283686, T284676)
Problems with saving changes when modifying an object in the object editor are fixed (T277981, T281265, T277981)
Other User-reported bugs are fixed (T283089, T265967, T277449, T277182, T280740, T283249, T276209, T275715, T268716)

5.7.31 20-Feb-19

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 (MSSQL-2022)
Problem with wrong error messages is fixed (MSSQL-1951)
Problem with lost user shortcuts is fixed (T274411)
Problem with check constraints is fixed (T271271)
Problems with drag and drop several tables to diagram are fixed (T273449, T274448)

5.6.104 22-Dec-18

User-reported bug fixes

Problems with a virtual relation on a database diagram are fixed (T271894, T272071)
Problem with the connection to Azure is fixed (T271314)
Problem with mapping a foreign key on a database diagram is fixed (T271145)
Problem with loosing user shortcuts is fixed (T270810)
Problem with wrong differences after data comparing is fixed (T264940)

5.6.62 20-Nov-18

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 (T267144)
Problem with false different records is fixed (T266252)
Problem with view renaming is fixed (T266141)
Problem with script generating for system-versioned table is fixed (T265461)
Problem with connect to TFS is fixed (T264436)
Problem with inserting data in data editor is fixed (T261847)
Problem with editing table structure is fixed (T260284)
Problem with renaming file for data export to CSV is fixed (T249813)
Problem with documentation generation is fixed (T244811)
Problem with object duplicate is fixed (T231938)
Problems with activation are fixed (T233019, T234213, T234539)
Other User-reported bugs are fixed (T232028, T252201, T235330, T237472, T266540, T266900, T266817, T254841, T264940, T262969, T262602, T262633, T268124, T249106, T238923, T242947, T267512)

5.5.369 17-Jul-18

User-reported bug fixes

Problem with popup menu in database explorer is fixed (T261545)

5.5.365 11-Jul-18

User-reported bug fixes

Schema synchronization issues are fixed (T258709, T242956, T259209)
Execution SQL statement issue is fixed (T259555, T228900, T245576)
Database Explorer issues are fixed (T258393, T258410)
Problem with Code snippet manager is fixed (T256537)
Problem with Document Outline is fixed (T256497)
Unexpected symbol issue is fixed (T252546)
Problem with wrong error message is fixed (T255112)
Problems with check constraint editor are fixed (T254968, T259838, T246863)
Problem with data import is fixed (T254774)
Problems with table editor are fixed (T253907, T253773, T249948, T245333)
Editing Database Diagram issue is fixed (T252100)
Source Control issues are fixed (T247362, T239241)
Query Builder issues are fixed (T246119, T248784)
Editing trigger issue is fixed (T244206)
Data Comparison issue is fixed (T248921)
Problem with view editor is fixed (T242658)
Data Editor issue is fixed (T239833)
Encrypted Objects issue is fixed (T235301)
Other User-reported bugs are fixed (T213963, T237472, T238161, T257871, T254314, T248018, T258345, T250352, T258692, T252199,T251540, T255421, T257578, T256004, T258577, T249983, T248018, T246960, T244558, T244897, T247813, T249648, T249669, T250332, T242730, T241843)

5.5.327 09-Jan-18

User-reported bug fixes

Random crashes during work are fixed (T232121, T220110, T228505, T233433, T229704, T234029, T234397,T228655, T234887, T235420, T237934, T238758, T236881)
Exception on application launch is fixed (T241470, T241475, T241479, T241487, T235868)
Documenter issue with PDF export is fixed (T237938)
Data Editor and Viewer issue is fixed (T238062)
Issue with documents session restore is fixed (T236102, T240840)
'Index 301 is either negative or above rows count' error message is fixed (T236381)
Exception when working on closed connection is fixed (T237934)

5.5.311 13-Oct-17

User-reported bug fixes

Known data import issues are fixed (T233402, T233763, T233872, T234419)
Copy-Paste from Excel issue for Data Editor is fixed (T230734)
Check for update issue in Express edition is fixed (T216853)
Other User-reported bugs are fixed (T232233, T232259, T231703)

5.5.279 13-Sep-17

User-reported bug fixes

Issues with random application crash reported by some users are fixed (T205713, T211526, T212740, T214078, T216866, T198231, T219097, T219548, T220110, T221342, T216853, T221516, T227369, T228141, T229704)
Object Editors issues are fixed (T230078, T231019, T229805, T229124, T231638, T231887, T229595, T229704, T228665, T228504, T230499, T231020, T231792, T227934)
Skin issues are fixed (T228171, T228519, T228622, T229229, T229296, T228071, T228065, T228806)
Code Completion issues are fixed (T230164, T228164, T230695)
Data Editor and Viewer issues are fixes (T229714, T228704, T229393)
Data Export\Import issues are fixed (T230213, T218898)
Documenter issues are fixed (T231460, T229061, T228416)
Object Editors issues are fixed (T230078, T231019, T229805, T229124, T231638, T231887, T229595, T229704, T228665, T228504, T230499, T231020, T231792, T227934)
Schema Compare issues are fixed (T229012, T228567)
Script Generator issues are fixed (T228598, T228496)
SQL Document issues are fixed (T231337, T228073, T228427, T228973, T213935, T177249, T181353, T183867, T187059, T228896)
Other User-reported bugs are fixed (T228495, T231133, T231611, T231496)

5.5.196 03-Aug-17

SQL Server support

SQL Server 2016 Service Pack 1 (SP1) new syntax support
SQL Server 2017 support
SQL Server installed on Linux support
Azure SQL Data Warehouse connectivity support

Code Completion

Column match highlighting in the INSERT statement
Database element dropping from the prompt in Completion List
Possibility to exclude a scheme in the ON condition of the JOIN statement
Possibility to connect/disconnect when describing/pre-describing objects of the same database
Query navigation
CASE END pairs highlighting
Extended suggestion in the PIVOT/UNPIVOT queries
Extended support for CTE
Prompt and QI of variables in named transactions
CREATE OR ALTER statement support
Support of the following statements:

DROP RULE
ALTER SERVICE
ALTER QUEUE
DROP SERVICE
DROP CONTRACT
ALTER EXTERNAL RESOURCE POOL
CREATE EXTERNAL TABLE AS SELECT
CREATE REMOTE TABLE AS SELECT
ALTER EXTERNAL DATA SOURCE
ALLOW_ENCRYPTED_VALUE_MODIFICATIONS at CREATE USER

SQL Document

New query execution history feature saves information about SQL statement you run

Data Compare

Static Data comparison in Script Folder
Support for MASKED columns
Option to automatically select a key for comparing objects without a suitable unique key
Added option to turn ON\OFF Generation of IF NOT EXISTS on inserting
Possibility to open the comparison wizard instead of the comparison autorun when opening the dcomp files

Schema Compare

Support for External Objects
Support for MASKED columns
Azure v.12 Extended Support
Support for SECURITY POLICY object
Support for Column Encryption Keys
Support for Column Master Keys
Extended support for comparison of SQL Server 2014-2016 backup files
New Database creation through Schema Comparison Master
Redesigned logging in command line
Possibility to open the comparison wizard instead of the comparison autorun when opening the scomp files

Documenter

Documenter tool now supports generation to Markdown format

Data Generator

Storing custom generators
Generating data by time
Generating data to existing tables already populated with data
Generating data using linked table
Pre and Post Script Execution

Source Control

Added authentication capability for VS Online
TFS 2017 support
SourceGear Vault v9.1 support
SourceGear Vault v10.0 support
Surround SCM support

Index Manager

The Command Prompt provides scan results of index analysis including index name, reason, and fragmentation

Connectivity

Each document uses its own connection
Password change on expiry
Keyboard shortcut for selecting connection and assigned database

Monitor

New tool to monitor SQL Server performance in the online mode
Possibility to monitor CPU and memory utilization
Data IO information
Displays information about waits, including its type, resource, a number of waits on this wait type, and more
Database metrics
Query profiling with top operations and plan in XML format
Information about active sessions and database backups

Other improvements

Command-Line Master which greatly simplifies command-line usage
Generate Script As redesigned
Express Edition extended with ability to manage table partition

User-reported bug fixes

SQL Document and Code Completion issues are fixed (T212521, T217146, T221380, T222709, T219960, T226952, T222386, T213940, T199661)
Data Compare issues are fixed (T224823, T224823, T209269, T208150, 147588)
Data Editor and Viewer issues are fixed (T214008, T213028, T205958)
Data Export\Import issues are fixed (T226797, T218898, T213239, T211014, T206194)
Data Generator issues are fixed (T219021, T170551)
Documenter issues are fixed (T216527, T220436, T215062, T216226)
Issue with silent deployment is fixed (T220237)
Issue with duration column sorting in Event Profiler is fixed (T216076)
Other Event Profiler issues are fixed (T224298, T225426)
Database Diagram issues are fixed (T221788, T204480)
Database Explorer issues are fixed (T219962, T221151, T210297, T218283, T222082)
Schema Compare issues are fixed (T223850, T223945, T222900, T214774, T211201)
Source Control issues are fixed (T211201, T172965, T204839, T190431, T209045, T209085)
Syntax Check issues are fixed (T223151, T215949, T197334, T198481, T118226)
T-SQL Analyzer gives proper suggestions for TRUNCATE of table variables (T217114, T217113)
Object Search displays table name in which the column is found (T195564)
Other User-reported bugs are fixed (T208833, T226549, T223847, T223920, T213935, T215396, T214560, T208354, T226553, T227176, T226082, T211436, T208792, T203501, T159851, T136506)

5.4.275 17-Mar-17

User-reported issues with application launch for PRO edition are fixed (T211422, T211365, T211446, T211363)
Documenter issue with databases selection is fixed (T211485)
Index Manager issue with database names that contain a dot is fixed (T211440)

5.4.270 15-Mar-17

User-reported issue with activation lost on midnight is fixed (T207634, T210225, T210589, T210570, T210567)
Schema Compare synchronization issue is fixed (T206405)
Data Compare NRE is fixed (T210444)
Documenter issue with generating report on specific database is fixed (T210158)
SQL Profiler issue is fixed (T208176)

5.4.257 03-Mar-17

Known activation issues are fixed
User-reported issues with stored procedure edit are fixed (T177600, T186810, T207194, T206791, T208179, T208582)
Source control issues are fixed (T204643, T205417)
Documenter issue with 'CHAR' type is fixed (T207828)
SQL Profiler issue is fixed (T207608)
Query builder issue with 'collation=case' sensitive is fixed (T190330)
Script generator issue with timestamp field always generated upper-case is fixed (T208664)
'WITH' statement issue in Data Editor and Viewer is fixed (T205258)
Mapping issue in Data Compare with 'BIT' type is fixed (T207184)
Other User-reported issues are fixed (T208831, T204251, T202885)

5.4.215 10-Feb-17

Issues with SQL Server 2016 Express and temporal tables are fixed (T205271, T205283, T205332, T205416, T205619, T205854, T206193, T206345)
Issues with Excel import are fixed (T205904, T205294)
Azure Active Directory Authentication issue with dbo schema is fixed (T205260)
Source objects are modified using ALTER statement instead of DROP/CREATE now
Some issues with saving Schema Compare document in Pro edition are fixed (T20590, T205906)
Other User-reported issues are fixed (T206037, T190330)

5.4.211 1-Feb-17

User-reported issues with product activation are fixed (T205231)

5.4.209 31-Jan-17

Schema and Data Comparison

New comparison options
Comparison and synchronization of memory-optimized tables
Command-line interface for the scripts folder comparison
Extended comparison reports functionality
Support for SECURITY POLICY objects
Data comparison and synchronization of system-visioned tables

Query Profiler

Live query statistics
Wait Stats tab
Saving/Opening execution plan files
Table I/O
Highlighting potentially resource-intensive statements
Displaying clustered columnstore indexes in execution plan

Data Export/Import

Dramatically improved data import performance
Export/import of JSON data
Redesigned export/import of XML data
Preview of the generated UPDATE script in the wizard
Detection of column types when importing data from the Excel format
Execution of SET IDENTITY_INSERT ON when the Repopulate option is enabled during data import

Data Generator

Generation of country-specific data
The ISJSON function in Check Constraint generator
10+ new generators, including ICD-10 Codes
Data generation for databases already filled with data
Improved DateTime generators

Source Control

Defining object file name format in Source Control and Scripts Folder creation
Creation of the script folder via the command-line interface

Data Viewer and Editor

Data Viewer and Editor features a new Geometry view, that helps to visualize spatial geometry data

SQL Document

CTRL+W shortcut for closing current tab
Opening new tabs next to current one
CTRL+N shortcut for opening new SQL window with inherited server and database of the current window
Showing the connection coloring in the status bar

Code Completion

Support of the following statements:

BULK INSERT
ALTER APPLICATION ROLE
DROP APPLICATION ROLE
DROP DATABASE
DROP DEFAULT
DROP QUEUE
ALTER LOGIN, DROP LOGIN
CREATE APPLICATION ROLE
RECEIVE
DROP STATISTICS
CREATE FULLTEXT STOPLIST
CREATE DEFAULT
CREATE XML SCHEMA COLLECTION

Suggestion improvements:

Filegroups suggestion
System versioning
Transactions Suggestions
Stretch tables
Always encrypted
Dynamic data masking
Row-level security

Fully qualifying a table with the server name is supported
Suggestion of databases created in script is supported
Column suggestion for CTE is improved
JOIN synonym suggestion is implemented

Other Improvements

Support for Power Shell
Trial product activation
Greatly improved visual style of the application with high DPI support (T167078)
Specific exit codes are added (T179285)
Compliance with the Federal Information Processing Standard (FIPS) (T202683, T200652, T202683)
Connection to Microsoft Azure SQL Database by using identities in Azure Active Directory (T178327, T181021, T181011)

User-reported bug fixes

Data Export\Import issues are fixed (T190439, T189279, T178258, T190648, T196941, T197426, T204476, T115423, T175888)
Data Editor and Viewer issues are fixed (T190439, T172102, T183426, T185281, T197463, T195972, T77205, T117784)
Data and Schema Compare issues are fixed (T186801, T181511)
Source Control issues are fixed (T172102, T177400)
SQL Document and Code Completion issues are fixed (T153278, T198273, T199012, T199912, T191374, T200841)
Documenter issues are fixed (T201750, 189300, T202830, T193233)
Object Editors issues are fixed (T199529, T188135, T182349)
Query Builder issue with case sensitive collation is fixed (T190330)
Other User-reported bugs are fixed (T191375, T203304, T198944, T200583, T171987)

5.3.56 22-Sep-16

Enterprise Edition is extended with new Documenter for SQL Server tool

Obtain an overview of the database schema
Include self-documenting SQL objects
View inter-object and inter-database dependencies
Customize documentation styles
Generate documents in HTML and PDF files

Improved Data Generator

XML generator improved
Foreign Key generator improved
Check Constraint generator improved
15+ new and improved meaningful generators

Data Editor and Viewer Window

XML View improved
JSON View added

Other improvements

Vault 9 is supported for Source Control (T178241)
Styled icons are used by default

User-reported bug fixes

Code Completion issues are fixed (T185155, T180117, T177271, T184761, T185098, T184379, T177334, T177416, T178455, T179742, T179820, T179930, T179970, T180425, T181171, T184619, T184754, T185283)
ER when removing part of the SQL code is fixed (T181154, T181758, T181826, T184121, T184755)
SQL Formatter issues are fixed (T183452, T181719, T184667, T180134, T179811, T179371, T181156)
Syntax Check issues are fixed (T184373, T184290, T183512, T180123, T181621, T180247, T179121, T180247, T180568, T181811, T184884)
Database Diagram layout issues are fixed (T177122, T183120, T185937)
Object Editors issues are fixed (T177773, T184027, T182524, T183432, T182168, T182500, T182168, T182500, T179382, T179382, T172102)
Data Export\Import issues are fixed (T178233, T178258, T178344, T182347)
Other User-reported bugs are fixed (T181941, T182741, T174109, T178473, T178238, T177717, T165386, T148503)

5.2.177 24-June-16

Final version released

5.2.125 beta 20-May-16

New version contains numerous improvements!

SQL Server 2016 support
Totally redesigned Database Search (objects and data)
Redesigned Visual Table Editor
Visual View Editor
tSQLt Framework updated to the latest version
Index Manager functionality is now available via command line

Improved SQL Completion

Objects suggestions in CROSS/OUTER APPLY statement
Suggestion of compound phrases
Greatly improved suggestion performance
Several new formatter options and profiles
Both objects and schemas suggestions in Completion List when writing cross-database queries are shown

Improved and enhanced Schema Comparison Tool

Many new comparison and synchronization options added
Enhanced backup support
Sequences support greatly improved
Improved security during synchronization process
Valid support of "WITH CHECK" and "WITH NOCHECK" constraints

Improved Source Control

Plastic SCM predefined template
Undo Local Changes
Support for version control command line client

Improved Data Generation

Updated RegExp and Python generators
JSON generator
Check Constraint generator
15+ new meaningful generators

User-reported bug fixes and improvements

Generate INSERT / UPDATE statements based on result grid have been added (T160960)
Generate Script As now supports selection of multiple objects (T165365)
Shortcut for Delete entire editor line (Ctrl + Y) has been added (T160960)
Generate WHERE IN () clause based on result grid has been added (T160960)
Popup menu for Copy Special in Data Editor has been added (T160960)
Display grid column types in Data Editor have been added (T160960)
Schema Compare and Sync Logging through the command line has been expanded
ArgumentNullException during creation SQL Document at the Studio start has been fixed (T161053)
The 'Index was outside the bounds of the array' error during schema comparison has been fixed (T159084)
IndexOutOfRangeException while comparing schemas of two databases has been fixed (T158788)
FileNotFoundException when restoring a database has been fixed (T158169, T161597)
Installation hangup has been fixed (T145722, T148482)
Bug with script generation for index creation has been fixed (T144431)
During schema sync, ALTER for scalar and table functions is generated if types in source and target coincide (T167604)
Option to save settings for "Object Filter" has been added (T163632)
Error with the database comparison parameters has been fixed (T163466)
InvalidCastException while comparing schemas of two snapshots has been fixed (T162316)
Bug with schema synchronization when ddl generation has been fixed (162173)
Ignore Semicolons option in schema comparison has been added (T160775)
NullReferenceException while comparing schemas has been fixed (157891)
Issue with integrated security when referencing an .SCOMP file during schema comparison has been fixed (T156509)
Schema Comparison Sync bug has been fixed (T159626)
Duplication of information in the Output window has been fixed (T167254)
IncludeIdenticalObjects option in the command line has been fixed (167846)
Outlining mode when editing a store procedure has been fixed (T163634)

5.1.178 18-Dec-15

Final version released with numerous improvements!

Data Generator updated to latest version
Schema comparison performance increased
TFS 2005, TFS 2008, TFS 2013 and TFS 2015 are now supported by Source Control
Installation Wizard redesigned

User-reported bug fixes

Schema comparison mapping issues are fixed (T149758, T149718, T150099, T152184, T152702)
Performance issues are fixed (T142424, T146879)
Express edition issues are fixed (T149813, T149762, T150369, T150835, T150920, T150163, T151008, T151475, T154369)
Layout issues are fixed (T151053, T154476)
Data import issue is fixed (T151027)
Database Connection Properties form issues are fixed (T149712, T150269, T150241, T150835, T152614, T153484, T154154)
Data Editor and Viewer issues are fixed (T150741, T155092, T155642, T150088, T153835, T154305, T155329)
Snippets issues are fixed (T150855, T150982, T151172, T151861, T152219, T153128, T153756, T155212, T155445)
SQL document issues are fixed (T150956, T151008, T151840, T152134)
Query Builder issue is fixed (T151378)
Debugger behavior is fixed (T152152, T152908)
Other stability improvements and bug fixes (T150877, T155473, T152324, T133575, T131790, T153278, T140900, T155604, T131513, T132137, T153630, T145111, T132953, T150143, T154084, T140633, T154235, T150337, T153139, T153234, T133587, T153620, T137810, T145345, T152489, T132567, T151942, T149488, T128653, T150061, T150335, T150320, T150921, T149767, T150873, T149436)

5.1.71 beta 24-Oct-15

Index Manager

Multiple Databases Scan
Maintenance Recommendations
Export of Scan Results
Customizable Index Fragmentation Thresholds
Script Generation

Unit Test

tSQLt Framework for Implementing Tests
No Affect on Actual Database
In-isolation Testing
Run Multiple Tests in Less Time
Built-in unit testing examples

5.0.337 20-Oct-15

Final version released!

Minor bug fixes and improvements
User-reported bug fixes (T145884, T128186, T70220)

5.0.286 beta 02-Sep-15

The extended Standard Edition substitutes the discontinued Data edition. The Enterprise Edition is introduced.

Source Control

Support of Subversion (SVN), Team Foundation Server (including TFS Cloud), Git, Perforce, Mercurial, SourceGear Vault systems
Repository Manager
Source Control Manager
Link Database To Source Control Wizard

Code Completion

New snippets
UPDATE statement expansion
Custom alias mapping
Pair highlighting
SQL refactoring
Semicolon insertion

Schema Comparison and Synchronization

Database script folder creation and comparison
Comparison with database script folder in version control

Data Generator

Enhanced RegExp generator
Support of composite foreign keys
180+ meaningful generators
Extended matching for more intelligent table mapping
User-Defined Generators
Command-line interface

4.5.79 5-Jun-15

Deleting issue in paginal mode is fixed (T132764)
NRE during debug is fixed (T127037)
Query Builder issue is fixed (T132264)
Code Completion not working in Data Editor is fixed (T131816)
Dark theme issues are fixed (T131781)
Find and Replace issue is fixed (T132953)
Data Generator NRE is fixed (T129887)
Doesn't save the window size and location on exit issue is fixed (T128392)
Other User-reported bug fixes (T130215, T131703, T127964, T127805, T127262)

4.5.60 23-Mar-15

Improved application startup time
NRE during debug is fixed (T127037)
Issues during stored procedure execution is fixed (T126569, T127608, T127463)
Issue when adding a new trigger to a table is fixed (T127318)
Issue when querying linked server without showplan permission is fixed (T122938)
Issue with Find and Replace is fixed (T127590)

4.5.40 26-Feb-15

SQL Server Data Generator

Fast generation of large volumes of test data
Parameters customization for each column data type
Preview of test data to be generated
Generated data can be executed against a database or exported to SQL script

Schema Compare and Sync

Improved text comparer
Option to show text comparer in a detached window
Preview tooltip for previewing differences in statements with a large number of lines
Information pane for indication of comparison and synchronization source and target
Redesigned display of database objects in the grid

Data Compare and Sync

Information pane for indication of comparison and synchronization source and target
Redesigned display of database objects in grid

Data Export and Import

Displaying progress bar for data import/export process

User-reported bug fixes

Issue with queries with more then 32 columns is fixed (T120823, T121353, T121979, T122309, T122657, T122926, T123323, T124468, T120345)
Some issues when using filters in database explorer and data viewer are fixed (T117993, T119291, T124479, T123737, T121449, T122917)
NRE in Query Builder is fixed (T125435)
Debug issues in x64 systems are fixed (T124967)
Export and import issues are fixed (T124220, T124453)
Ability to attach a database using custom path is implemented (T124297)
Issue with generating synchronization scripts via command line is fixed (T121501)
NRE in Event Profiler is fixed (T121590)
NRE in Data Comparison is fixed (T120723)
Issue with CONCAT function is fixed (T120002)
Issues in Object Editor are fixed (T120689, T120704)
NRE in Find Object is fixed (T119110, T120530)
Other bug fixes and improvements (T122969, T122938, T122018, T121709, T121172, T120938, T121172)

4.0.52 12-Dec-14

User-reported bug fixes

Issue with editing FLOAT data type is fixed (T119295)
Error when server Default Backup Path is unavailable is fixed (T119286)
Issue with using multiline filters in Database Explorer is fixed (T119271)
Issue with scroll arrow is fixed (T119146)
Issue with search functionality is fixed (T119092)
Issue with stored procedure that contains compile errors (T118943)
Errors when creating a snapshot are fixed (T117992, T118124)
Issue with selecting a big number of columns is fixed (T118918)
Issue with SQL Server 2000 schemes is fixed (T118835)
User-reported NRE is fixed (T118715)
Issues with Data Viewer and HEX view are fixed (T118625, T119221, T119509, T119511)
Issue with updating the statistics is fixed (T118480)
Issue with CSV export is fixed (T118369)
Issue with exporting to SQL with 'Open the result file after export' option on (T118896)
Some issues with useless implicit code completion blocks are fixed (T118333)
Issue with 'Check for object existence' option for default constraint (T118197)
Column filter issues are fixed (T117972, T118400)

4.0.35 17-Nov-14

User-reported bug fixes

Some users reported crash on using Product Update Manager (T117601, T117698)
Code formatting issue (T117843)
Issues when using search window (T117835, T117842)
Other minor fixes and stability improvements

4.0.24 10-Nov-14

SQL Server Event Profiler

Create a trace
Watch the trace results as the trace runs
Store the trace results in a table
Start, stop and modify the trace results as necessary

T-SQL Code Analyzer

Identify possible code defects
Check T-SQL code for compliance with best practices
Code analysis profiles

SQL Editing and Execution

Command-line interface for SQL formatting
Changing a snippets folder location
Query execution pane
Easy way to hide data results
Encoding switch in the /execute command-line operation
MERGE statement support (syntax checking, formatting)
Phrase completion
Updated Find&Replace feature in documents and files

Database Explorer

Creating new schemas and displaying all existing ones
Alternative ways to create a new object
Generate Script As shortcut menu item for check and default constraints
Sending objects to a database diagram
Renaming columns
Displaying the objects number

Object Editors

Completely redesigned Index Editor
Updated Check Constraint Editor
Updated Database Editor
Support of user types when working with tables

Schema Comparison

Custom mapping for tables
Updated Synchronization wizard
Zooming font size in Text Comparer

Data Comparison

Show white spaces option
Ignore computed columns option
Zooming font size in Data Viewer

Data Reporting

Support of report parameters in command-line interface

Query Profiler

Diagram printing options for a Query Profiler Plan Diagram

Data Editor

Data Viewer, LOB Editor, and Redirect Data to Output are combined in a single control
Zooming font size in Data Viewer and Editor Window

Data Export and Import

Updated Import and Export wizard

Generate Scripts

SQL Azure support

Security Manager

Creating and editing schemas

User Interface

Support of multiple monitors

Other Features and Improvements

Create Schema Snapshot and Data Report wizard windows are modeless
Improved application performance when executing a query, opening a table, designing a diagram, and building a query in the Query Builder
Windows 10 support

3.8.218 01-Sep-14

User-reported bug fixes

Issue with Parameter Info is fixed (T109367, T109953, T111272, T112079)
Issue with script formatting is fixed (T109197)
Issue with table editor is fixed (T105940)
Issue with data comparison is fixed (T111041)
Several issues with dark themes are fixed
Some other stability improvements

3.8.180 17-Jun-14

Final Version Released!

Minor bugfixes and improvements

3.8.171 beta 29-May-14

SQL Server 2014 support

Now dbForge Studio for SQL Server supports the latest SQL Server 2014

Database

Generate Script As shortcut menu option is added
Database Visual Editor is added
Database Backup and Restore features are added
Possibility to attach and detach a database is added
Take Offline and Bring Online database states are added
Copying a database from one server to another using the MS Agent is possible now

Generate Schema Script

Saving the options setting for future use
Support of command line interface
Automatic archiving of schema export scripts
Writing a report about the process into a log file
Automatic old files removal based on date or quantity

Database Explorer

Filter settings are available now
Objects' dependencies view is supported
Possibility to duplicate an object is added
Renaming a table through the Database Explorer is possible
Delete shortcut menu command is available for all objects' types
Disable and enable trigger's menu options are added
Each database state has its corresponding icon now
Changing a database object name is now possible

Object Editors

Database Visual Editor is added
Statistics Properties visual editor is added
Code preview when editing columns, indexes, etc. is possible now
Index editor is improved

Code Completion

New CREATE COLUMNSTORE INDEX statement syntax is supported
New keywords in the CREATE TABLE statement are supported
New keywords in the CREATE INDEX statement are supported
New keywords in the CREATE PROCEDURE statement are supported
Members prompt for user-defined table type is supported
Refactoring aliases is possible now

Data Compare/Schema Compare

COLUMNSTORE index is supported
Check for object existence option is added to the synchronization wizard
Ignore column order in indexes option is added
ALTER SCHEMA feature for objects transferring between the schemas is supported
Include print comments option is added
Exclude comments option is added

SQL Profiler

Query plans can be saved visually
Results comparison is executed when the required elements are selected
Various queries plans can be shown vertically in one view when comparing
Buffer and plans cache refresh options are added
Zoom menu in the Profiler diagram is available

User Interface

Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
SSMS shortcut schema availability

Other Features and Improvements

Coloring a database connection according to the document category is possible now
Database connection properties are expanded
SET connection options in query execution are added
Possibility to switch from the wizard page to the main application window is added
Find Objects feature is expanded
Restoring the documents opened in the last session is possible now
SQL document zooming by holding the CTRL key and rotating the mouse wheel is added

3.5.93 12-Mar-14

User-reported bug fixes

Problem with shortcuts is fixed (T98504, T98550, T98774, T98773, T98843, T98932, T98935, T98938, T98985, T99377, T99402, T99657)
Problem with identity columns in Data Export is fixed (T98894)
T-SQL configuration function @@SERVERNAME is supported (R34372)

3.5.86 18-Feb-14

New code formatter features

New Option: Add empty line after GO
New Option: Enclose identifiers within square brackets []
New Option: Add parentheses when inserting functions
New Option: Enable autoformat words while typing
New Option: Alias Text Case - As in declaration
Code formatter functionality is available even if SQL Complete is disabled
Do not format tag is implemented. Now it is possible to format a whole SQL document in the editor ignoring selected code fragments which you do not want to be formatted.

Refresh suggestions cache

Automatic refresh suggestions cache by specified time is added
New option: Refresh suggestions cache on detecting changes on a server

New code completion features

SET IDENTITY INSERT tables suggestion is added
XML variables suggestion in the FROM statement is added
Column suggestion in the VALUES statement is added
Object suggestion for linked servers on SQL Azure is added

Minor improvements

Formatting CASE options are redesigned
Objects describe performance is improved
New snippets are added

User-reported bug fixes

Problem with unreadable characters in Schema Compare is fixed (R30785)
Behavior in Find Object window is improved (R31054)
Problem with empty file name in Data Compare is fixed (T73310)
OverflowException in Database Diagram is fixed (T91517, T92597)
ArgumentNullException during launching the application is fixed (T84639)
NullReferenceException in Data Compare is fixed (T94442, T95211)
Incorrect behavior with card mode in Data Editor is fixed (R28778)
Problem on editing table without unique key in Data Editor is fixed (T93383)
NullReferenceException during synchronization in Schema Compare ix fixed (T72231)
NullReferenceException during canceling data comparison is fixed (T67964)
NullReferenceException on parsing script in object editor is fixed (T95245)
NullReferenceException on mapping objects in Data Comparison is fixed (T68493, T68722, T98526)
Ability to control-scroll zoom text size is added (T83910)
Problem on installing the product is fixed (R28557)
InvalidOperationException in Data Compare is fixed (T94736)
Incorrect behavior with cycled dependencies during in Schema Compare is fixed (T95144)
IndexOutOfRangeException on exporting data into ODBC format in Data Export is fixed (T92435)
Problem with database list in Data Compare wizard is fixed (T98144)
Problem with completed connection transaction is fixed (T92273)
Command 'Create Unique Key' in Database Explorer and table editor is added (T92867)
ArgumentException in Data Compare is fixed (T95958, T98204)
Text colors in SQL Document are improved (SSMS like style) (T72785, T83910)
NullReferenceException in Schema Compare is fixed (T92437, T98377)
Problem with snapshot format in Schema Compare is fixed (T97363, T97834, T98493)

3.0.248 21-Nov-13

NullReferenceException on hitting the Update Database button in the Stored Procedure editor is fixed (T90279)
NullReferenceException on editing data in the Data Editor is fixed (T89961)
ArgumentException on loading a .dit file in the Data Import wizard is fixed (T89844)
The problem with the New Relation command on the Database Diagram toolbar is fixed (T89138)
An option that allows to synchronize objects with square parenthesis is added (T89073)
OutOfMemoryException on searching data in Data Editor is fixed (T88817)
TypeLoadException while describing database objects is fixed (T88526, T88531)
An error on creating a stored procedure using the Object Editor is fixed (T88094)
The syntax error in the CREATE SEQUENCE statement is fixed (T90082, T90081)
Wrong behavior on comparing parameters in CLR function is fixed (R27916)
Problem with the installation of the product is fixed (R28557)
Wrong behavior on synchronizing data with a target database in Data Compare is fixed (T90112)
The navigation from the Error List to the specific error in a script is fixed (T88471)

3.0.238 15-Oct-13

An exception while comparing schemas (on condition that before schema comparison the data comparison process was implemented) is fixed (T84523, T87411)
InvalidOperationException while executing queries on SQL Azure is fixed (T84559)
A problem related to the focus, while executing several statements is fixed (T84632)
A problem with highlighting of the IIF function is fixed (T84653)
NullReferenceException while working with a query that contains PIVOT (in Query Builder) is fixed (T84919)
Data export functionality to a CSV file is added. Now you can use column separator: tab, space, custom (T86071)
OverflowException while editing a table that contains an identifier column with assigned BIGINT type, is fixed (R28330)
TypeLoadException on comparing ASSEMBLY is fixed (T88526, T88531)
A problem related to the searching and replacing tabs and whitespaces is fixed (R28253)

3.0.230 19-Sep-13

NullReferenceException on adding rows in Data Editor is fixed (T84511)
NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed (T74907, T75124, T75355, T75356, T75357, T75440, T83022)
NullReferenceException on editing a table is fixed (T84516)
Error on applying table structure changes in Data Editor is fixed (T84565)
NullReferenceException on detecting a cyclic dependency is fixed (T66662)
Problem with saving a file's encoding is fixed (T83954)
NullReferenceException on attempting to perform synchronization into a snapshot via the command line interface is fixed (T83705)
NullReferenceException on executing a query is fixed (T83825, T84358, T84425, T84827)
Problem with removing a record in Data Editor is fixed (R26432)
Computed columns are now excluded from synchronization by default (T83409)
Error report when Estimated Rows exceeds the limits of integer in the Profiler document view is fixed (T83219)
Problem with generating a schema name when exporting data using the MERGE mode is fixed (T77218)
NullReferenceException on invoking Snippets Manager from the Code Snippets tool window is fixed (T84639)

3.0.217 23-Aug-13

Problem with defining input parameters on debugging a procedure with parameters of user-defined type is fixed (R10865)
Error on opening schema synchronization script in external editor is fixed (R24795)
Problem on importing data from Excel 2007 file is fixed (T75056)
Problem in data editor with not assigning default values is fixed (T70859, R10060)
NullReferenceException on renaming invalid snippet is fixed (T69969)
NullReferenceException on working with snippet template is fixed (R21124)
Problem with clearing memory on selecting data from table is fixed (T71228)
FileNotFoundException on restarting debug is fixed (R26004)
Problem with committing changes in version control system is fixed (T75228)
Problem with application freezing on switching between tabs after data synchronization script generation is fixed (T75272)
Problem with running the application on .NET Framework 4.5 is fixed (T75603)
Problem with showing semi-transparent hints is fixed (T75871)

3.0.205 12-Jul-13

Problem with connecting to TFS on visualstudio.com is fixed (R24383)
The information is added to the report, while detecting the circular reference (T72560)
Syntax check failure for RAISERROR is fixed (T74355)
The 'select db..' statement failure is fixed in SQL Complete (T74397)
NullReferenceException on editing a table in the editor is fixed (T73420)
NullReferenceException on invoking Help in the Command Line is fixed (R23315)
The error related to inappropriate columns displaying while changing a query type on the Insert Values ( in the Database Diagram) is fixed (T72173)
"Statistics norecompute" options translation is fixed in Russian Edition (T69944)
TFS 2010 connection failure is fixed (T73129)
Error on changing connection in SQL document is fixed (R23354)
NullReferenceException on executing a function from Find Object Results Window is fixed (T72506)
Work with memory is improved while redirecting data to the Output window (R22051)
The problem with inaccurate title of filter in schema comparison document is fixed (T68928)
InvalidCastException on editing a subquery in Query Builder is fixed (R20279)
InvalidCastException on refreshing procedure node in Database Explorer is fixed (R20986)
The problem with applying a filter in Data Editor is fixed (T70060)
The 'Round float types up to 3 digits' option is added in data comparison wizard (R21962)
Ability to create snapshots is added to the Standard edition (R22633)
NullReferenceException on drag-n-dropping a table to Database Designer is fixed (T72478)
Incorrect behavior with identity columns on adding data in Data Editor is fixed (T69095)

3.0.185 15-Apr-13

The problem with the temporary table on schema synchronizing is fixed (T66662, T69085, T69895, T69951)
The problem with procedure's dependencies determination on schema comparison is fixed (T67595)
InvalidOperationException on executing a script is fixed (T69522)
ArgumentException on saving command line arguments in the Data Comparison wizard is fixed (R20898)

3.0.180 09-Apr-13

Database Diagram is included in the Standard edition without any limitations now
The problem with saving the Splitting options is fixed (T60064)
InvalidOperationException on executing a script is fixed (R17828)
NullReferenceException on debugging a procedure is fixed (T67893)
NullReferenceException on closing the procedure editor after debugging is fixed (R19529)
The problem with changing options for code editor is fixed (T65707)
Incorrect behavior on synchronizing a function in Schema Comparer is fixed (T66941)
NullReferenceException on trying to find a search pattern in a document is fixed (R19287)
InvalidOperationException on editing data in Data Editor is fixed (T67547)
The problem with connection to TFS 11 is fixed (T61250)
ArgumentOutOfRangeException on saving changes in the procedure editor is fixed (T66641, T69375, T69490)
The problem with the name of a temporary table is fixed (T66662, T69085)
The problem with punctuation's visibility in code editor with black background being set is fixed (T65696)
NullReferenceException on executing a script is fixed (T65230)
Syntax error on executing the current statement using the Execute Current Statement command is fixed (T68993)
Problems with mixed case named indexes are fixed (T66552, T68265)
Wrong displaying of NULL values in comparison reports is fixed (T68678)
NullReferenceException on choosing invalid file as a snapshot file is fixed (R18487)
Syntax error on executing a script with @@ variables is fixed (T62139)
The problem with using store procedures as Custom Query in data comparison is fixed (T66152)
NullReferenceException on switching to the Mapping page in the Data Comparison wizard is fixed (T66404)
The problem with saving a comment in the table editor is fixed (T65161, T66267)
OverflowException on scrolling a database diagram is fixed (T66729)
The error on choosing a snapshot in the Schema Comparison wizard is fixed (T66590, T67465)

3.0.161 16-Jan-13

NullReferenceException on comparing schemas of SQL Azure is fixed (T65593)
Error on default schema mapping is fixed (R17170)

3.0.160 15-Jan-13

New Features

Ability to create primary fields that are not IDENTITY fields is added.

User-reported bug fixes

ArgumentException error on clicking Save As My Defaults in the synchronization wizard is fixed (T64077)
Problem with displaying options in the Data Import wizard is fixed (T63344)
Saving of changes in object mapping to *.dcomp files is fixed (T63179, T63753)
ArgumentException on describing view columns is fixed (T38076)
Error on searching stored routines names of which contain the '_' symbol is fixed (T62907)
NullReferenceException on pressing Ctrl+Shift+Z on a diagram is fixed (T16602)
NullReferenceException on calling 'Edit source object' on the schema comparison page is fixed (R15128)
The SqlTypeException on executing stored procedure with data entered out of the permissible range is fixed (T64333)
The error on working with Team Foundation Server is fixed (T61250)
NullReferenceException on setting 'Computed' for columns on diagram is fixed (R16496)
InvalidCastException on double-clicking a table in Database Explorer is fixed (T64179)
NullReferenceException on double-clicking an element in Suggestions List is fixed (T61512)
Error on generating script for indexes is fixed (R13720)
Error on setting alias name in upper case is fixed (R15105)
NullReferenceException in Query Builder is fixed (T62199, T63974)
Incorrect tables comparison when the 'Ignore Unique Key' option is on is fixed (R15118)
NullReferenceException error on comparing schemas of backup copies is fixed (R15144)
NullReferenceException on editing roles is fixed (R15126)
InvalidCastException on editing views is fixed (T59437)
Error connected with absence of a table on a diagram if this table is available in the database is fixed (R16585)
Error on generation of incorrect schema synchronization script when an account with restricted rights is used is fixed (T63740)
NullReferenceException on opening a *.dcomp file is fixed (T65066)
NullReferenceException error on creating a SELECT query in Query Builder is fixed (T63549)
Error 8623 on schema comparison is fixed (T39594)
The 'Cannot browse data in Master-Detail' error is fixed (T59563)

3.0.136 08-Nov-12

SQL Server 2012 LocalDB is now supported (R14621)
Schema comparison performance is improved (T39594)
Synchronization of procedure with dependencies is fixed (R11464)
ArgumentException on opening a file through the command line is fixed (T45824)
ArgumentException on synchronizing databases in Schema Compare is fixed (T50581, T59826, T60281)
Application's hanging when comparing snapshots is fixed (T51789)
TargetInvocationException in the Schema Comparison wizard is fixed (R13555)
Incorrect creating of foreign keys is fixed (T59065)
Incorrect trial on Windows 8 is fixed (T59119, T59496, T59563, T59698, T59827, T59847)
ArgumentNullException on finding the next occurrence in text is fixed (R13847)
NullReferenceException on profiling a query is fixed (T59489)
Old warnings that occurred during comparison are removed now (T59484)
Incorrect values on generating DELETE statements in Data Compare are fixed (T59583)
NullReferenceException on searching a text in SQL document is fixed (T59700)
Option "Disable Check Constraints" is saved in the Data Comparison document now (R14047)
NullReferenceException on applying the filter and removing it after refresh in the Schema Comparison document are fixed (T59720)
NullReferenceException on opening recent Schema Comparison document is fixed (T59751)
TargetInvocationException on getting schemas with insufficient privileges in the Schema Comparison wizard is fixed
Incorrect behavior on saving a procedure with errors in its text is fixed (T59939)
Error on saving a valid procedure with table variable in its text is fixed (T60026)
Incorrect error positions in object editors are fixed (T60129)
NullReferenceException on saving Data Comparison document is fixed (T60313)
Incorrect behavior on saving stored procedure is fixed (R14530)
Non-working command line on operating systems with only .NET Framework 4 installed is fixed (T61027)
ComponentNotRegisteredException on comparing data with a backup as a source or target is fixed (T61163)
Incorrect behavior with specifying file groups in synchronization scripts is fixed (T60183)
Use ALTER will be used instead of DROP/CREATE for stored procedure in all editing features (R13499)
Incorrect saving of the length of a column in Column Editor is fixed (T60382)
InvalidOperationException on refreshing nodes in Database Explorer with opened Database Diagram document is fixed (T60588)
Losing privileges on source objects after editing or synchronizing databases in Schema Compare is fixed (T59672)
InvalidOperationException on closing a connection with invalid transaction is fixed (R14818)

3.0.117 18-Sep-12

ArgumentException in Pivot Table with spatial data types is fixed (R13561)
Incorrect feedback URL in main menu is fixed (R13578)
NullReferenceException on creating DDL trigger in the object editor is fixed (R13560)
Incorrect behavior with table functions in Query Builder is fixed (R13570)
InvalidOperationException on opening the mapping page in Data Export wizard is fixed (R13552)
NullReferenceException on opening Data Viewer window in Data Editor is fixed (R13608)

3.0.114 13-Sep-12 (first release of dbForge Studio for SQL Server)

Data Studio for SQL Server is now known as dbForge Studio for SQL Server and incorporates such tools as SQL Complete, Data Studio, Schema Compare, Data Compare and Query Builder for SQL Server.

Product Editions

dbForge Studio for SQL Server comes in 4 editions:

Free Express edition with basic functionality for database development
Standard edition extends the Express edition's functionality with T-SQL Debugger, Query Profiler, advanced SQL Coding Assistance features, etc
Professional fully-featured edition that provides additional functionality
Data edition includes all the functionality of the discontinued Data Studio for SQL Server

Major New features

Table Designer:
- Visual editors for table properties
- Editor for table creation script
- Rebuild tables when complex changes are introduced
- Preview changes before modifying a database object
Database Diagram:
- Visual editing, easy manipulation and scaling
- Containers for grouping objects
- Printing large diagrams
- Virtual connections
T-SQL Debugger integrated into the stored procedure editor allows to start debugging from the Database Explorer tree
Query Profiler for locating bottlenecks and optimizing query execution time with advanced options unavailable in a standard tool
Security Manager that incorporates visual editors for logins, users, and roles; batch object editing, etc

Other features

Generate Script As in Database Explorer feature added
Procedure, function, synonym and sequence editors added

2.0.47 18-Jul-12 (last release of dbForge Data Studio for SQL Server)

Error while running Microsoft SQL Server Management Studio is fixed (T39149)
Error "Object cannot be cast from DBNull to other types" on SQL server 2012 is fixed (T42098)
Start page scrolling bug is fixed
Problem with report generating is fixed (T41645)
Error "Key cannot be null" is fixed (T41340)
"Create synonym with default schema" bug is fixed
Error "Incorrect syntax near..." during search object is fixed (T40345)
Problem with creating report using .rdb file is fixed
Error "Object cannot be cast from DBNull to other types" is fixed (T40064)
Problem with messages in trial is fixed

2.0.35 27-Apr-12

Some corrections in documentation are made (T34205)
Incorrect warning message during synchronization is fixed (R9043)
ArgumentException on importing data from MS Excel 2007 is fixed (T34901)
Other small fixes in different features are made

2.0.17 05-Apr-12

SQL Intellisense

Context-sensitive code completion and object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements
Smart filtering of the suggestion list based on user input
Parameter information for functions
Quick object information available from SQL editor
SQL formatting with rich options (limited to the set of statements mentioned above)
A few other minor features

Query builder can now work with INSERT, UPDATE, and DELETE statements

Thanks to the Visual Query Builder users can create INSERT, UPDATE and DELETE statements. Together with extending the types of edited queries, we have improve general usability of the tool and fixed many bugs.
The updated query builder facilitates the process of creating queries and makes it even more intuitive.

Automated data report delivery

A format for report generation can be chosen
"Report delivery" method can be chosen: e-mail, ftp, or shared folder

Data export to SQL statements

Possibility to export data to INSERT, UPDATE, and MERGE statements
Ability to export data from a table or data grid using a wizard
Quick export from data grid without opening wizard

Data Compare

New extended data reports
Custom query result comparison (the results of specific queries can be compared)
"One-to-many" objects mapping when addressing columns that were separated as a table in the target database
Possibility to include objects into comparison by mask, which is useful when comparing groups of tables
Improved analysis of comparison results
Improved data synchronization

Convenient work with result sets of several SELECT queries

If there is more than one SELECT statement in a document, query results will be displayed on separate tabs in the Data window after execution.

SQL Server 2012 and SQL Azure Support

New release of Data Studio includes full support for new version of SQL Server and functionality allowing users to work with Microsoft Cloud SQL services, knows as SQL Azure.

Other improvements

User interface skins support is added

1.00.134 28-Apr-11

ArgumentNullException on refreshing database list in Data Import Wizard is fixed (T28123)

1.00.133 08-Apr-11

Saving of columns aliases in Data Export template files fixed (T27551)
Incorrect drawing of some UI elements on x64 systems fixed

1.00.129 09-Mar-11

The problem with Data Editor on Microsoft Windows 2000 fixed (T26756)

1.00.128 16-Jan-11

The problem with updating the Standard edition fixed (T26317)

1.00.127 12-Jan-11

NullReferenceException on opening a large SQL file fixed (T25207)
NullReferenceException on applying a custom filter in Data Editor fixed (T25168)
NullReferenceException on editing a subquery in Query Builder fixed (T25205)
Incorrect behavior on pressing Ctrl+End to fetch all data in Data Editor fixed (58046)

1.00.123 20-Dec-10

Fixed the problem with empty column names in Data Editor on executing SELECT statements (57826)
Fixed UI defects in the Data Editor navigator (56597, 57124)
Fixed NullReferenceException on opening a file with a database report in IDE without any connection (57828)
Fixed problem of layout removing on uninstall when the corresponding option is enabled (57829)
Now DML triggers are displayed with schema names in Database Explorer (57831)
New logo is added in Data Report wizard (57832)
Fixed incorrect behavior on drag-and-dropping synonyms on Query Builder (57825)
Fixed NullReferenceException on switching the search mode in the Find Objects window when no connections exists in Database Explorer (57843)
Fixed NullReferenceException on executing changed SQL statement and showing data in Data Editor (57845)
Fixed automatic disabling of server-side operations if such operations are not valid for SQL Server (57846)

1.00.117 16-Dec-10

First release of dbForge Data Studio for SQL Server