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

dbForge Studio for SQL Server Enterprise Changelog

What's new in dbForge Studio for SQL Server Enterprise 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 Enterprise 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 Enterprise 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 Enterprise 6.4.124 (May 12, 2023)

  • 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 Enterprise 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 Enterprise 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 Enterprise 6.2.52 (Jul 21, 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 Enterprise 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 Enterprise 6.1.14 (Dec 21, 2021)

  • 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 (Z67473)
  • Improved the display of table relationships on the Query Builder diagram
  • Improved the error diagnosis when working with Source Control (Z53631)
  • Added the ability to resize the search text field (Z62750)
  • Added a warning when trying to save read-only files with the applied changes (Z69226)
  • 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 (Z63649)
  • Fixed unexpected exception thrown when running the application tracer (Z65699)
  • Fixed an issue with saving changes in the table editor (Z65875)
  • Fixed a request to get events in Event Profiler (Z61344)
  • 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 (Z72020)
  • Fixed the 'Connection Timeout' error in the SQL Document (Z70626)
  • Fixed the 'The connection is closed' error in the SQL Document (Z67071)
  • Fixed an issue with data export freezing on a database with a large quantity of objects (z69906)
  • 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 (Z63567)
  • Fixed an issue with defining unique keys when using object names in different registers in Data Editor (Z62788, Z64041, Z72841)
  • 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 (Z64284)
  • Fixed the behavior of Code Completion on case sensitive servers (Z60623)
  • Fixed false positives of Syntax Check (Z62561, Z62657, Z60973, Z63678, Z66470, Z64267, Z67458, Z66843, Z67785, Z68835, Z69263)
  • Fixed an issue with calculating Quick Info (Z60901)
  • Fixed an issue with launching Monitor (Z62856)
  • Fixed an issue with highlighting associated IF/ELSE keywords (Z63180)
  • Fixed an issue with calculating Parameter Info when accessing the procedure using a synonym
  • Fixed an issue that occurred when performing Refresh Suggestions (Z64316)
  • Fixed an issue with Output that occurred when working with SQL Tools versions integrated into SSMS (Z61727, Z71212)
  • Fixed an issue with data import through templates (z38859)
  • Fixed an issue with navigating to the similarly named triggers in different schemas (Z64267)
  • Fixed an issue with calculating Parameter Info
  • Fixed an issue with creating an incorrect tooltip for a connection element when starting the application (Z57177)
  • Fixed an error that occurred with comparing data (Z62718)
  • Fixed an issue with comparing user-defined object schemas that differ only in spaces (Z67700, Z67719, z61019, z63262, z66282)
  • Fixed an issue with reading data in the table editor (Z65022, Z68332)
  • Fixed an issue that occurred when comparing a database with the Script Folder (Z65701, Z66830)
  • Fixed an issue with synchronizing objects with data recovery when comparing schemas (Z67275, Z74100, Z63960)
  • Fixed an issue with renaming a snippets folder (Z63346)
  • Fixed an error that occurred when starting SSMS (Z63430, Z63691, Z64227, Z65835, Z73719, Z74067, Z74157, Z74403, Z74538, Z74539, Z74540)
  • Fixed an issue that occurred when creating a connection with custom parameters
  • Fixed an issue that occurred when starting the application (Z65371)
  • Fixed an issue when starting the application with the opened Start Page (Z64626)
  • 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 (Z66790)
  • Fixed a syntax error in the STRING_AGG construction (Z66843)
  • Fixed an error that occurred when comparing a database with an empty folder (Z65701, Z66830)
  • Fixed an issue in Source Control when working with a case sensitive database server (Z60192)
  • Fixed the behavior of keyboard shortcuts
  • Fixed an error that occurred when starting the SQL Server Monitoring Tool (Z66673)
  • Fixed an issue with zooming text in the SQL Server Monitoring Tool (Z63946)
  • Returned the capability to insert a JOIN condition after an open parenthesis (Z64037)

New in dbForge Studio for SQL Server Enterprise 6.0.563 (Oct 20, 2021)

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

New in dbForge Studio for SQL Server Enterprise 6.0.560 (Sep 10, 2021)

  • 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 (Z55517)
  • Unexpected exception when changing a database on the connection
  • Error during the data export to an Excel file (Z62513)
  • Unexpected exception with the filter in Documenter
  • Error during the data export through ODBC (Z57386)
  • During data import, the values from default constraints for the columns of the target table were ignored
  • Error during the data generation for the tables with composite primary keys
  • Error with the integration of several add-ins
  • Improved behavior of linking system databases in Source Control
  • Error with updating a document in Source Control
  • Error with getting a list of schemas on the SqlServer 2000
  • Error with getting a list of files in the Browse for Folder window
  • Error with canceling the operation in Data Editor
  • Error with changing databases on the SQL Server connection
  • Error with editing data for the selection from tables of different schemas in Data Editor
  • Typos in the Filter window of Data Editor (Z59481)
  • Error with closing a parallel connection in Data Editor (Z53577)
  • Improved behavior with the active Paste As New Records command in Data Editor (p195068)
  • Error when executing the Go To Definition command to a remote connection to the server
  • Improved behavior of active control of changing the current database when executing the query in SQL Document
  • Coloring of cells with the NULL values in Data Editor (Z57818)
  • Error when completing the procedure with parameters in Data Editor (Z57682, Z61911)
  • Error when executing a query with parameters of the Date type in Paginal Mode in Data Editor
  • Error with specifying an incorrect value in the Filter window in Data Editor
  • Error with updating transaction operations in a SQL Document
  • Error with closing wizards when getting a list of databases
  • Generation of a DDL trigger when executing a command from Database Explorer (Z56348)
  • Description of the column in Database Explorer (p45705)
  • Issue with deploying a tSQLt framework on the Azure SQL database (Z58747)
  • Invalid response to syntax check (Z60052, Z59176, Z60241)
  • Issue with saving changes in the procedure to the server (Z59244)
  • Error with closing SQL documents (Z55637, Z58342)
  • Error with updating a table
  • Bug when scrolling the drop-down list with the mouse wheel
  • Incorrect change of a query when updating it in Query Builder (p196244, Z60596)
  • Bug when launching Data Compare from the command line
  • Update of a procedure script after modification (Z56348)
  • Processing of the Ctrl+A, Ctrl+C shortcuts in Data Viewer (Z56062)
  • Bug with Commit in Source Control
  • Added the ability to connect with MFA through a proxy (Z59810)
  • Errors in the synchronization script in Schema Compare (Z55541)
  • Bug when deleting a column in the table editor
  • Handling of CTRL + 0 on the numeric keyboard (p194936)
  • Error with synchronizing Extended Properties for views

New in dbForge Studio for SQL Server Enterprise 6.0.383 (Apr 8, 2021)

  • User-reported and internal bug fixes:
  • ALTER for views was generated incorrectly
  • Error with duplicating the max size for varchar, nvarchar, and varbinary when generating CREATE
  • Critical error when reading metadata for an external table
  • Error with processing a procedure during synchronization
  • Temporary Schema Compare synchronization script files duplicated in Recent Files
  • Error with closing the Data Comparison document
  • Error with the report generation
  • Critical error when processing mapping during comparison (T323990, T325780)
  • Mechanism of deletion of temporary folders
  • Critical error with processing metadata for nullable columns
  • Error with working with documents when closing the application (T318978)
  • Display of the 'Hide unmodified columns' button in the comparison document
  • 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
  • Issue with opening the trigger editor from another schema
  • Query execution with USE in SqlDocument
  • Behavior in the view editor when working with Query Design was tweaked
  • Behavior when editing a query with comments in Query Builder was tweaked
  • Inputting fractional values in the parameter editor when executing a procedure
  • Error with working the TFS version control system
  • Error with starting the application (T309571)
  • Error when changing the connection status in SqlDocument (T309932, T310344, T315727)
  • Date and time formats for data editor were improved
  • Option for enclosing identifiers within square brackets when generating scripts was added (T325976)
  • Incorrect parsing of types enclosed within square brackets
  • 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
  • IFF function was not highlighted by the code editor
  • Build step of Azure for Release pipeline failed to proceed
  • IDE failed to parse specific complex scripts
  • Incorrect syntax check for ��� AT TIME ZONE clauses
  • Code completion failed to suggest objects from schemas except for the default one
  • Pressing Backspace within the search dialog led to the selection of the last character from the remaining text
  • Text from the clipboard was pasted to incorrect locations in case of the multiline selection
  • Error when exporting to ODBC Dynamics Drive
  • 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

New in dbForge Studio for SQL Server Enterprise 6.0.330 (Feb 26, 2021)

  • User-reported bug fixes:
  • Error with loading the application with certain OS (Z49539, Z49498)

New in dbForge Studio for SQL Server Enterprise 6.0.237 (Feb 26, 2021)

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

New in dbForge Studio for SQL Server Enterprise 5.8.127 (Jun 4, 2020)

  • 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 comperison result is fixed (T277907, T277941)
  • Other User-reported bugs are fixed (T306139, T307733, T309221, T307914, T269638, T304872, T304901, T302787, T298055, T297493, T297275, T294154)

New in dbForge Studio for SQL Server Enterprise 5.8.107 (Oct 10, 2019)

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

New in dbForge Studio for SQL Server Enterprise 5.7.99 (Jul 9, 2019)

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

New in dbForge Studio for SQL Server Enterprise 5.7.98 (Jul 1, 2019)

  • Problem with connecting to GIT using proxy is resolved (T277904)
  • Problems with generation incorrect query are fixed (T283725, T282337)
  • Problem with creating procedure in editor is fixed (T282922)
  • Problems with conneting 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 modified in editor database objects are fixed (T277981, T281265, T277981)
  • Other user reported bugs are fixed (T283089, T265967, T277449, T277182, T280740, T283249, T276209, T275715, T268716)

New in dbForge Studio for SQL Server Enterprise 5.7.31 (Feb 20, 2019)

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

New in dbForge Studio for SQL Server Enterprise 5.6.104 (Dec 24, 2018)

  • 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 shortcuts is fixed (T270810)
  • Problem with wrong differences after data comparing is fixed (T264940)

New in dbForge Studio for SQL Server Enterprise 5.6.62 (Nov 21, 2018)

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

New in dbForge Studio for SQL Server Enterprise 5.5.369 (Jul 17, 2018)

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

New in dbForge Studio for SQL Server Enterprise 5.5.365 (Jul 11, 2018)

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

New in dbForge Studio for SQL Server Enterprise 5.5.327 (Jan 9, 2018)

  • Random crashes during work are fixed (T232121, 23190, 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)

New in dbForge Studio for SQL Server Enterprise 5.5.311 (Oct 13, 2017)

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

New in dbForge Studio for SQL Server Enterprise 5.5.279 (Sep 14, 2017)

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

New in dbForge Studio for SQL Server Enterprise 5.5.196 (Aug 3, 2017)

  • SQL Server support:
  • SQL Server 2016 Service Pack 1 (SP1) new syntax support
  • SQL Server 2017 CTP2 new syntax 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 ONOFF 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

New in dbForge Studio for SQL Server Enterprise 5.4.275 (Apr 6, 2017)

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

New in dbForge Studio for SQL Server Enterprise 5.4.211 (Feb 3, 2017)

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

New in dbForge Studio for SQL Server Enterprise 5.4.209 (Feb 3, 2017)

  • Schema and Data Comparison:
  • New comparison options
  • Comparison and synchronization of memory-optimized tables
  • Command-line interface for the scripts folder comparison
  • Database creation right in the Schema Comparison Wizard
  • 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 visulaize 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
  • Other Improvements:
  • Support for Power Shell
  • Trial product activation
  • Greatly improved visual style of the application with high DPI support (T167078, T167030)
  • Specific exit codes are added (T168536, 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 ExportImport 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, 181511, T188577)
  • Source Control issues are fixed (T181941, T172102, T199235, T196991, T188479, T177400)
  • SQL Document and Code Completion issues are fixed (T153278, T198273, T199012, T199912, T191374, T184058, T200841)
  • Documenter issues are fixed (T201750, T197454, 189300, T202830, T193233, T197745)
  • Installation issues are fixed (T195027, T196014)
  • Object Editors issues are fixed (T199529, 188135, T182349)
  • Query Builder issue with case sensitive collation is fixed (T190330)
  • Other user reported bugs are fixed (T201585, T191375, T203304, T198944, T200583, T171987)

New in dbForge Studio for SQL Server Enterprise 5.3.56 (Sep 23, 2016)

  • 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 ExportImport issues are fixed (T178233, T178258, T178344, T182347)
  • Other user reported bugs are fixed (T181941, T182741, T174109, T178473, T178238, T177717, T165386, T148503)

New in dbForge Studio for SQL Server Enterprise 5.2.125 Beta (Jul 12, 2016)

  • 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
  • Improved and enhanced Schema Comparison Tool:
  • Many new comparision and synchronization options added
  • Enchanced 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:
  • Generate INSERT / UPDATE statements based on result grid have been added (T160960)
  • 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)

New in dbForge Studio for SQL Server Enterprise 5.1.178 (Jul 12, 2016)

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

New in dbForge Studio for SQL Server Enterprise 5.1.71 BETA (Nov 12, 2015)

  • Index Manager:
  • Multiple Databases Scan
  • Maintenance Recommendations
  • Export of Scan Results
  • Customizable Index Fragmentation Thresholds
  • Scipt Generation
  • Unit Test:
  • T-SQL for Implementing Tests
  • No Affect on Actual Database
  • In-isolation Testing
  • Run Multiple Tests in Less Time
  • Built-in unit testing examples

New in dbForge Studio for SQL Server Enterprise 5.0.337 (Nov 12, 2015)

  • Final Version Released:
  • Minor bugfixes and improvements

New in dbForge Studio for SQL Server Enterprise 5.0.286 BETA (Nov 12, 2015)

  • 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
  • SSDT projects
  • 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

New in dbForge Studio for SQL Server Enterprise 4.5.79 (Nov 12, 2015)

  • Deleting issue in paginal mode is fixed (T132764)
  • NRE during debug is fixed (T127037)
  • Query Builder issue is fixed (T132264)
  • Code Colmpletion 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)

New in dbForge Studio for SQL Server Enterprise 4.5.60 (Nov 12, 2015)

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

New in dbForge Studio for SQL Server Enterprise 4.5.40 (Nov 12, 2015)

  • 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 bugfixes and improvements (T122969, T122938, T122018, T121709, T121172, T120938, T121172)

New in dbForge Studio for SQL Server Enterprise 4.0.52 (Nov 12, 2015)

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

New in dbForge Studio for SQL Server Enterprise 4.0.35 (Nov 12, 2015)

  • 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

New in dbForge Studio for SQL Server Enterprise 4.0.24 (Nov 12, 2015)

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

New in dbForge Studio for SQL Server Enterprise 3.8.218 (Nov 12, 2015)

  • 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

New in dbForge Studio for SQL Server Enterprise 3.0.248 (Dec 14, 2013)

  • NullReferenceException on hitting the Update Database button in the Stored Procedure editor is fixed
  • NullReferenceException on editing data in the Data Editor is fixed
  • ArgumentException on loading a .dit file in the Data Import wizard is fixed
  • The problem with the New Relation command on the Database Diagram toolbar is fixed
  • An option that allows to synchronize objects with square parenthesis is added
  • OutOfMemoryException on searching data in Data Editor is fixed
  • TypeLoadException while describing database objects is fixed
  • An error on creating a stored procedure using the Object Editor is fixed
  • The syntax error in the CREATE SEQUENCE statement is fixed
  • Wrong behaviour on comparing parameters in CLR function is fixed
  • Problem with the installation of the product is fixed
  • Wrong behaviour on synchronizing data with a target database in Data Compare is fixed
  • The navigation from the Error List to the specific error in a script is fixed

New in dbForge Studio for SQL Server Enterprise 3.0.238 (Dec 14, 2013)

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

New in dbForge Studio for SQL Server Enterprise 3.0.230 (Oct 9, 2013)

  • NullReferenceException on adding rows in Data Editor is fixed
  • NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed
  • NullReferenceException on editing a table is fixed
  • Error on applying table structure changes in Data Editor is fixed
  • NullReferenceException on detecting a cyclic dependency is fixed
  • Problem with saving a file's encoding is fixed
  • NullReferenceException on attempting to perform synchronization into a snapshot via the command line interface is fixed
  • NullReferenceException on executing a query is fixed
  • Problem with removing a record in Data Editor is fixed
  • Computed columns are now excluded from synchronization by default
  • Error report when Estimated Rows exceeds the limits of integer in the Profiler document view is fixed
  • Problem with generating a schema name when exporting data using the MERGE mode is fixed
  • NullReferenceException on invoking Snippets Manager from the Code Snippets tool window is fixed

New in dbForge Studio for SQL Server Enterprise 3.0.217 (Oct 9, 2013)

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

New in dbForge Studio for SQL Server Enterprise 3.0.205 (Aug 15, 2013)

  • Problem with connecting to TFS on visualstudio.com is fixed
  • The information is added to the report, while detecting the circular reference
  • Syntax check failure for RAISERROR is fixed
  • The 'select db..' satement failure is fixed in SQL Complete
  • NullReferenceException on editing a table in the editor is fixed
  • NullReferenceException on invoking Help in the Command Line is fixed
  • Failure on editing a column in the Database Diagram modal editor is fixed
  • "Statistics norecompute" options translation is fixed in Russian Edition
  • TFS 2010 connection failure is fixed
  • Error on changing connection in SQL document is fixed
  • NullReferenceException on executing a function from Find Object Results Window is fixed
  • Work with memory is improved while redirecting data to the Output window
  • The problem with inaccurate title of filter in schema comparison document is fixed
  • InvalidCastException on editing a subquery in Query Builder is fixed
  • InvalidCastException on refreshing procedure node in Database Explorer is fixed
  • The problem with applying a filter in Data Editor is fixed
  • The 'Round float types up to 3 digits' option is added in data comparison wizard
  • Ability to create snapshots is added to the Standard edition
  • NullReferenceException on drag-n-dropping a table to Database Designer is fixed (
  • Incorrect behaviour with identity columns on adding data in Data Editor is fixed

New in dbForge Studio for SQL Server Enterprise 3.0.185 (Apr 15, 2013)

  • The problem with the temporary table on schema synchronizing is fixed
  • The problem with procedure's dependencies determination on schema comparison is fixed
  • InvalidOperationException on executing a script is fixed
  • ArgumentException on saving command line arguments in the Data Comparison wizard is fixed

New in dbForge Studio for SQL Server Enterprise 3.0.180 (Apr 15, 2013)

  • Database Diagram is included in the Standard edition without any limitations now
  • The problem with saving the Splitting options is fixed
  • InvalidOperationException on executing a script is fixed
  • NullReferenceException on debugging a procedure is fixed
  • NullReferenceException on closing the procedure editor after debugging is fixed
  • The problem with changing options for code editor is fixed
  • Incorrect behaviour on synchronizing a function in Schema Comparer is fixed
  • NullReferenceException on trying to find a search pattern in a document is fixed
  • InvalidOperationException on editing data in Data Editor is fixed
  • The problem with connection to TFS 11 is fixed
  • ArgumentOutOfRangeException on saving changes in the procedure editor is fixed
  • The problem with the name of a temporary table is fixed
  • The problem with punctuation's visibility in code editor with black background being set is fixed
  • NullReferenceException on executing a script is fixed
  • Syntax error on executing the current statement using the Execute Current Statement command is fixed
  • Problems with mixed case named indexes are fixed
  • Wrong displaying of NULL values in comparison reports is fixed
  • NullReferenceException on choosing invalid file as a snapshot file is fixed
  • Syntax error on executing a script with @@ variables is fixed
  • The problem with using store procedures as Custom Query in data comparison is fixed
  • NullReferenceException on switching to the Mapping page in the Data Comparison wizard is fixed
  • The problem with saving a comment in the table editor is fixed
  • OverflowException on scrolling a database diagram is fixed
  • The error on choosing a snapshot in the Schema Comparison wizard is fixed

New in dbForge Studio for SQL Server Enterprise 3.0.161 (Apr 10, 2013)

  • NullReferenceException on comparing schemas of SQL Azure is fixed
  • Error on default schema mapping is fixed

New in dbForge Studio for SQL Server Enterprise 3.0.160 (Apr 10, 2013)

  • 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
  • Problem with displaying options in the Data Import wizard is fixed
  • Saving of changes in object mapping to *.dcomp files is fixed ArgumentException on describing view columns is fixed
  • Error on searching stored routines names of which contain the '_' symbol is fixed
  • NullReferenceException on pressing Ctrl+Shift+Z on a diagram is fixed
  • NullReferenceException on calling 'Edit source object' on the schema comparison page is fixed
  • The SqlTypeException on executing stored procedure with data entered out of the permissible range is fixed
  • The error on working with Team Foundation Server is fixed
  • NullReferenceException on setting 'Computed' for columns on diagram is fixed
  • InvalidCastException on double-clicking a table in Database Explorer is fixed
  • NullReferenceException on double-clicking an element in Suggestions List is fixed
  • Error on generating script for indexes is fixed
  • Error on setting alias name in upper case is fixed
  • NullReferenceException in Query Builder is fixed
  • Incorrect tables comparison when the 'Ignore Unique Key' option is on is fixed
  • NullReferenceException error on comparing schemas of backup copies is fixed
  • NullReferenceException on editing roles is fixed
  • InvalidCastException on editing views is fixed
  • Error connected with absence of a table on a diagram if this table is available in the database is fixed
  • Error on generation of incorrect schema synchronization script when an account with restricted rights is used is fixed
  • NullReferenceException on opening a *.dcomp file is fixed
  • NullReferenceException error on creating a SELECT query in Query Builder is fixed
  • Error 8623 on schema comparison is fixed
  • The 'Cannot browse data in Master-Detail' error is fixed

New in dbForge Studio for SQL Server Enterprise 3.0.136 (Nov 10, 2012)

  • SQL Server 2012 LocalDB is now supported
  • Schema comparison performance is improved
  • Synchronization of procedure with dependencies is fixed
  • ArgumentException on opening a file through the command line is fixed
  • ArgumentException on synchronizing databases in Schema Compare is fixed
  • Application's hanging when comparing snapshots is fixed
  • TargetInvocationException in the Schema Comparison wizard is fixed
  • Incorrect creating of foreign keys is fixed
  • Incorrect trial on Windows 8 is fixed
  • ArgumentNullException on finding the next occurence in text is fixed
  • NullReferenceException on profiling a query is fixed
  • Old warnings that occured during comparison are removed now
  • Incorrect values on generating DELETE statements in Data Compare are fixed
  • NullReferenceException on searching a text in SQL document is fixed
  • Option "Disable Check Constraints" is saved in the Data Comparison document now
  • NullReferenceException on applying the filter and removing it after refresh in the Schema Comparison document are fixed
  • NullReferenceException on opening recent Schema Comparison document is fixed
  • TargetInvocationException on getting schemas with insufficient privileges in the Schema Comparison wizard is fixed
  • Incorrect behaviour on saving a procedure with errors in its text is fixed
  • Error on saving a valid procedure with table variable in its text is fixed
  • Incorrect error positions in object editors are fixed
  • NullReferenceException on saving Data Comparison document is fixed
  • Incorrect behaviour on saving stored procedure is fixed
  • Non-working command line on operating systems with only .NET Framework 4 installed is fixed
  • ComponentNotRegisteredException on comparing data with a backup as a source or target is fixed
  • Incorrect behaviour with specifying file groups in synchronization scripts is fixed
  • Use ALTER will be used instead of DROP/CREATE for stored procedure in all editing features
  • Incorrect saving of the length of a column in Column Editor is fixed
  • InvalidOperationException on refreshing nodes in Database Explorer with opened Database Diagram document is fixed
  • Losing privileges on source objects after editing or synchronizing databases in Schema Compare is fixed
  • InvalidOperationException on closing a connection with invalid transaction is fixed

New in dbForge Studio for SQL Server Enterprise 3.0.117 (Nov 10, 2012)

  • ArgumentException in Pivot Table with spatial data types is fixed
  • Incorrect feedback URL in main menu is fixed
  • NullReferenceException on creating DDL trigger in the object editor is fixed
  • Incorrect behaviour with table functions in Query Builder is fixed
  • InvalidOperationException on opening the mapping page in Data Export wizard is fixed
  • NullReferenceException on opening Data Viewer window in Data Editor is fixed