Softpedia >Windows >Internet >Servers >Database Utils >dbForge Studio for SQL Server >  Changelog

dbForge Studio for SQL Server Changelog

What's new in dbForge Studio for SQL Server 6.6.5

Apr 12, 2024
  • Improvement:
  • Integration support for SSMS 20.x
  • 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

New in dbForge Studio for SQL Server 6.5.140 (Dec 28, 2023)

  • 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)

New in dbForge Studio for SQL Server 6.5.16 (Jul 12, 2023)

  • 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)

New in dbForge Studio for SQL Server 6.4.124 (May 12, 2023)

  • 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)

New in dbForge Studio for SQL Server 6.4.7 (Dec 30, 2022)

  • 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 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)
  • Improved syntax check (D97235)
  • Improved query profiling on SQL Server 2019/2022 (p219550)
  • Improved the Backups report in Monitor (D89312)
  • In Source Control, added the ability to link a database to a subfolder in a Git repository
  • 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

New in dbForge Studio for SQL Server 6.3.9 (Sep 12, 2022)

  • 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)

New in dbForge Studio for SQL Server 6.2.52 (Jul 20, 2022)

  • 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

New in dbForge Studio for SQL Server 6.2.22 (Jun 20, 2022)

  • 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 the performance of the commit and push operations in source control (D62681, D62525)
  • 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)

New in dbForge Studio for SQL Server 6.1.14 (May 2, 2022)

  • 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 СREATE/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)