dbForge Data Compare for SQL Server History

7.0.249 14-Nov-24

User-reported bug fixes

Several minor bugs are fixed

7.0.210 18-Oct-24

User-reported bug fixes

Several minor bugs are fixed

7.0.158 05-Sep-24

Connectivity

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

DevOps & CLI Automation

Added generation of comparison reports from the command line

SQL Query History

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

Documents

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

Data Editor

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

User-reported bug fixes

Improved the behavior of comparison options for floating-point numbers and strings (D113398)

5.5.3 12-Apr-24

Improvement

Integration support for SSMS 20.x

User-reported bug fixes

Several user reported minor bugs are fixed

5.4.9 28-Dec-23

User-reported and internal bug fixes

Fixed an issue of truncating the number of records in the Data Compare window when using a high-DPI monitor (D125920)
Fixed an error that occurred when comparing databases with full-text indexes

5.4.4 12-Jul-23

Performance improvements

Optimized the process of describing scripts folders

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

User-reported bug fixes

Resolved an issue with displaying incorrect row counts for tables (D104947)

5.3.25 12-May-23

User-reported bug fixes

Fixed the display of the datetime data type in the data comparison grid

5.3.20 30-Dec-22

New features and improvements

Support for macOS & Linux via CrossOver
SSMS v19 Preview 4 integration is added

User-reported bug fixes

Fixed a bug that occurred when creating a comparison report (D104050)
Improved the metadata reading behavior - the VIEW DATABASE STATE privilege is no longer required (p135909, T308355, D71423, D98539, D103313)

5.3.15 12-Sep-22

New features and improvements

Connectivity support for SQL Server 2022 CTP 2.1

5.3.9 20-Jul-22

New features and improvements

SSMS v19 Preview 2 integration is added

5.3.4 17-Jun-22

New features and improvements

Added support for new functions in the Completion List, Quick Info, and Parameter Information: GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID
Added support for the FORMATFILE_DATA_SOURCE parameter for bulk_options in the OPENROWSET function

User-reported bug fixes

Fixed the behavior of the Reseed Identity Columns option for Azure connections in Data Compare (D78869)
Fixed an issue with the display of differences in the XLS comparison reports in Data Compare (D79090)
Fixed an issue that occurred when opening Data Compare (D73600)

5.2.4 21-Dec-21

New features and improvements

Improved the behavior of data sorting in Data Editor
Added the ability to resize the search text field
Added a warning when trying to save read-only files with the applied changes

User-reported bug fixes

Fixed an issue with generating a data comparison report in the XLS format (D65573)
Fixed an issue with reading comparison parameters in console mode in Data Compare (D66202)
Fixed a query execution error in the SQL Document (D64174)
Fixed an issue with using the object names mapping options
Fixed an error that occurred with comparing data
Fixed the interception of third-party exceptions in dbForge add-ins (D61747)
Fixed an issue with generating Excel and HTML reports when the 'Hide unmodified columns' option is enabled in Data Compare

5.1.72 10-Sep-21

New features and improvements

Ability to simultaneously connect with different ApplicationIDs to Azure SQL Server

User-reported bug fixes

Bug when launching Data Compare from the command line (D60973)
Error with canceling the operation in Data Editor
Improved behavior with the active Paste As New Records command in Data Editor
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
Error when completing the procedure with parameters in Data Editor
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
Processing of the Ctrl+A, Ctrl+C shortcuts in Data Viewer

5.1.61 16-Jun-21

New features and improvements

Redesigned Progress window for data comparison and synchronization
Exclude newly added objects option in Data Compare Wizard
Tolerance Interval option in Data Compare Wizard
Pre/Post-scripts execution tab in Data Synchronization Wizard
New formatting profiles
Options Search
Integration into MS SSMS v18.9

User-reported and internal bug fixes

Error with loading the application assemblies (T298119, T286039, T288576)
Quotation marks were added to string type when generating report in HTML file format (T302672)
Error with skipping Data Generator schema in data synchronization script (T292907)
Error with generating data for the tables with circular dependencies (T306370)

5.0.52 08-Oct-19

User-reported bug fixes

Problem with assembly loading is fixed (T291513)

5.0.33 02-Sep-19

New features and improvements

Redesigned data compare control
Redesigned data comparison report window
Redesigned data comparison report in CSV
Redesigned data comparison ssms add-in window

User reported bug fixes

Several user reported bugs are fixed

4.5.58 27-Jun-19

User reported bug fixes

Problem with assembly loading is fixed (T279738)

4.5.43 10-May-19

User reported bug fixes

Errors when SSMS starting are fixed (T274282, T279738)
Minor user reported bugs are fixed

4.5.26 20-Feb-19

New features and improvements

Support for the Active Directory - Universal with MFA authentication
Comparison performance improved dramatically

User reported bug fixes

Several user reported bugs are fixed

4.4.44 21-Dec-18

New features and improvements

Connectivity support for SQL Server 2019
Product now integrates into SSMS v18
Lots of Azure improvements implemented

User reported bug fixes

Synchronization issue with using command line is fixed
Problem with assembly loading is fixed (T270855)
Problem with false 'Different Records' is fixed (T266252)
Problem with opened connections is fixed (T72044)
Other user reported bugs are fixed

4.3.106 19-Jul-18

User reported bug fixes

Constraint synchronization issue is fixed (T257966)
Foreign keys synchronization issue is fixed (T256473)

4.2.38 18-Apr-17

New features and improvements

Comparision and synchronization of system-visioned tables
New comparision and synchronization options
PowerShell supported
Trial product activation implemented
Extended comparison reports functionality
Comparison and synchronization of memory-optimized tables
Compliance with the Federal Information Processing Standard (FIPS)
Connection to Microsoft Azure SQL Database by using identities in Azure Active Directory
Specific exit codes added
Greatly improved visual style of the application with high DPI support

4.1.38 28-Sep-16

Issue with export of comparision report to XLS is fixed (T186361)

4.1.35 16-Sep-16

SQL Server 2016 support
Product now integrates into SSMS 2016

4.0.32 22-Jan-16

SET LANGUAGE statement fixed (T156828, T157882)
Command line error fixed (T139324)
Some problem related to synchronization solved (T152622)
Executing in batch mode fixed (T156691)

4.0.26 30-Nov-15

Redesigned Comparison Document UI

SSMS Integration Support

SQL Server Management Studio integration enables starting the data comparison directly from SSMS

3.9.286 16-Dec-14

Minor improvements
User reported bug fixes

3.9.283 13-Nov-14

Data Comparison

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

SQL Editing and Execution

Query execution pane
Easy way to hide results
Command-line interface for SQL formatting
Encoding switch in the /execute command-line operation

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

Other Features and Improvements

Create Schema Snapshot and Data Report wizard windows now work in the modeless mode.
Windows 10 support
Updated Start Page
New skins
User reported bug fixes (T109747)

3.8.265 25-Jun-14

SQL Server 2014 is supported

Code Completion

Data Compare and Synchronization

Columnstore index is supported
Ignore column order in indexes option is added
Include print comments option is added
Exclude comments option is added

User Interface

SET connection options in query execution are added
Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
SSMS shortcut schema availability
Possibility to switch from the wizard page to the main application window is added
Coloring a database connection according to the document category is possible now
SQL document zooming by holding the CTRL key and rotating the mouse wheel is added
Restoring the documents opened in the last session is possible now
User reported bug fixes (T96626 , T36448)

3.0.209 21-Nov-13

NullReferenceException on editing data in the Data Editor is fixed (T89961)
OutOfMemoryException on searching data in Data Editor is fixed (T88817)
Problem with the installation of the product is fixed (R28557)
Wrong behaviour on synchronizing data with a target database in Data Compare is fixed (T90112)
The navigation from the Error List to the specific error in a script is fixed (T88471)

3.0.205 15-Oct-13

InvalidOperationException while executing queries on SQL Azure is fixed (T84559)
A problem related to the focus, while executing several statements is fixed (T84632)
A problem with highlighting of the IIF function is fixed (T84653)
A problem related to the searching and replacing tabs and whitespaces is fixed (R28253)

3.0.199 19-Sep-13

NullReferenceException on adding rows in Data Editor is fixed (T84511)
NullReferenceException on retrieving data from the tables containing a BIGINT field is fixed (T74907, T75124, T75355, T75356, T75357, T75440, T83022)
Problem with saving a file's encoding is fixed (T83954)
NullReferenceException on executing a query is fixed (T83825, T84358, T84425, T84827)
Problem with removing a record in Data Editor is fixed (R26432)
Computed columns are now excluded from synchronization by default (T83409)

3.0.194 23-Aug-13

Problem in data editor with not assigning default values is fixed (T70859, R10060)
Problem with clearing memory on selecting data from table is fixed (T71228)
Problem with application freezing on switching between tabs after data synchronization script generation is fixed (T75272)
Problem with running the application on .NET Framework 4.5 is fixed (T75603)

3.0.183 12-Jul-13

NullReferenceException on invoking Help in the Command Line is fixed (R23315)
Error on changing connection in SQL document is fixed (R23354)
Work with memory is improved while redirecting data to the Output window (R22051)
InvalidCastException on editing a subquery in Query Builder is fixed (R20279)
The 'Round float types up to 3 digits' option is added in data comparison wizard (R21962)
The problem with applying a filter in Data Editor is fixed (T70060)
Incorrect behaviour with identity columns on adding data in Data Editor is fixed (T69095)

3.0.168 12-Apr-13

InvalidOperationException on executing a script is fixed (T69522)
ArgumentException on saving command line arguments in the Data Comparison wizard is fixed (R20898)

3.0.165 09-Apr-13

The problem with saving the Splitting options is fixed (T60064)
InvalidOperationException on executing a script is fixed (R17828)
The problem with changing options for code editor is fixed (T65707)
NullReferenceException on trying to find a search pattern in a document is fixed (R19287)
InvalidOperationException on editing data in Data Editor is fixed (T67547)
The problem with connection to TFS 11 is fixed (T61250)
The problem with punctuation's visibility in code editor with black background being set is fixed (T65696)
NullReferenceException on executing a script is fixed (T65230)
Syntax error on executing the current statement using the Execute Current Statement command is fixed (T68993)
Wrong displaying of NULL values in comparison reports is fixed (T68678)
Syntax error on executing a script with @@ variables is fixed (T62139)
The problem with using store procedures as Custom Query in data comparison is fixed (T66152)
NullReferenceException on switching to the Mapping page in the Data Comparison wizard is fixed (T66404)

3.0.145 15-Jan-13

ArgumentException on clicking Save As My Defaults in the synchronization wizard is fixed (T64077)
Saving of changes in object mapping to *.dcomp files is fixed (T63179, T63753)
ArgumentException on describing view columns is fixed (T38076)
SqlTypeException error on executing stored procedure with data entered out of the permissible range (T64333)
Error on setting alias name in upper case is fixed (T15105)
NullReferenceException error on opening a *.dcomp file is fixed (T65066)

3.0.123 08-Nov-12

SQL Server 2012 LocalDB is now supported (R14621)
ArgumentException on opening a file through the command line is fixed (T45824)
Incorrect trial on Windows 8 is fixed (T59119, T59496, T59563, T59698, T59827, T59847)
Old warnings that occurred during comparison are removed now (T59484)
Incorrect values on generating DELETE statements in Data Compare are fixed (T59583)
NullReferenceException on searching a text in SQL document is fixed (T59700)
Option "Disable Check Constraints" is saved in the Data Comparison document now (R14047)
NullReferenceException on saving Data Comparison document is fixed (T60313)
Non-working command line on operating systems with only .NET Framework 4 installed is fixed (T61027)
ComponentNotRegisteredException on comparing data with a backup as a source or target is fixed (T61163)
"Error Number: 80121040" on opening MS Management Studio was fixed (T60636)
InvalidOperationException on closing a connection with invalid transaction is fixed (R14818)

3.0.106 18-Sep-12

InvalidOperationException on executing a query is fixed (T42960, T41492)
Incorrect width for column is fixed (R10525)
Incorrect sequence of columns in the grid is fixed (R12569)
Problem with NCHAR and NVARCHAR is fixed (R12511)
Performance in comparison result document was increased (R12508)

3.0.88 18-Jul-12

Error while running Microsoft SQL Server Management Studio is fixed (T39149)

3.0.79 19-Apr-12

Execute the script directly against the target database error is fixed (R8985)

3.0.74 09-Apr-12

Error with Next and Synchronize buttons in Synchronization Wizard is fixed (T38208)
Error on Update Form is fixed (R8088)
Error on Action Plan and Warnings tabs of Synchronization Wizard is fixed (R8087)
Error with synchronization into database from command line is fixed (R8084)
Error during installation is fixed (T38036)
Integration problem with Microsoft Management Studio is fixed (T38166)

3.0.54 06-Mar-12

SQL Server 2012 Support

Databases on SQL Server 2012 can be compared and synchronized as easily as the ones on previous server versions. dbForge Data Compare for SQL Server fully supports SQL Server 2012 database connection and processing.

User reported bug fixes

Dialogue windows always pop up on the primary monitor (T36411)
Reporting via command line options problem is fixed (T35913)
Error while reading columns is fixed (T34936)

3.0.52 31-Oct-11

User reported bug fixes

Integration problems with Microsoft Management Studio are fixed (T32152, T32397, T32555)
Module loading error is fixed (T31423)
Error while comparing Datetimeoffset type is fixed (T31423)
Error while comparing using command line with user id unspecified is fixed
Null reference exception on Visible columns button pressing is fixed (T32786)
Input string is not in a correct format error is fixed (T32922, T33087)
Comparison key too long error is fixed (T33078)
SQL Filter saving error is fixed (T33731)

3.0.38 19-Aug-11

User reported bug fixes

T31486 Problem with DATETIME values on Arabic culture
T31471 Problems with trial checking on Microsoft Management Studio are fixed

3.0.33 15-Aug-11

User reported bug fixes

Problems with trial checking are fixed

3.0.23 11-Aug-11

SQL Azure Support

Comparing data and synchronizing SQL Azure databases has just become as easy as processing common ones. dbForge Data Compare for SQL Server fully supports SQL Azure database connection and processing.

SQL Server Management Studio Integration

From now on you can quickly launch your comparison right from the Object Explorer context menu as well as from the SSMS main menu.

New extended data comparison reports

Possibility to analyze comparison results in the offline-mode due to export of real data into the report
New Comparison Report wizard is added
Possibility to include only columns containing differences for the rows that contain differences into comparison report
Possibility to include the number of changes for each column into the comparison report

Custom query result comparison

If you don't need to compare all data in your database, but need some customized comparison (for example, you need to see what has changed in your database over some period of time), you can compare the results of specific queries. For this, use the custom query result comparison feature available in the new version of the product.

More flexible comparison settings

"One-to-many" objects mapping can be used when some columns in the target database were separated as a table
Possibility to include objects into comparison by mask. It is useful when you need to compare groups of tables

Improved analysis of comparison results

Full-text data search
Possibility to hide unchanged columns in the result data grid
The number of differences per column is now displayed on the status bar

Improved data synchronization

Ability to omit schema name in the generated script file is added. It is required for better script portability

Other improvements

Extended command line examples are added
User interface skins support is added
Start page is redesigned

2.0.159 21-Oct-10

User reported bugs fixes

'Attempted to divide by zero' when updating values in identity columns (command-line mode only)

2.0.158 24-Sep-10

User reported bugs fixes

T22951 Problem on comparing long values in varchar(max) collate Japanese_90_BIN2 with a backup

2.0.157 21-Jun-10

User reported bugs fixes

T16930 NullReferenceException if delete a connection used by an opened document
T16875 Invalid symbol case of the name of a language in 'SET LANGUAGE' statement
T16858 The 'Connection' toolbar must be visible when open an SQL document
T16817 Incorrect message when 'Ignore IDENTITY columns' option is turned on
T16816 Schema mapping resets after changing comparison options
CR53187 InvalidCastException when comparing 'sql_variant' values contain 'real' data type

2.0.155 03-Jun-10

Warning during mapping of blob columns was removed (T14969)
Incorrect display of composite index in the Column Mapping window and the SQL Filter window was fixed
Generating CONVERT in synchronization script for sql_variant was fixed (T14969)

2.0.153 17-May-10

Invalid cast exception in particular cases was fixed (T14017)
Now option 'Ignore spaces in object names' is turned on by default

2.0.150 26-Apr-10

Completely redesigned comparison and synchronization engine, which significantly improved the performance
Supported all SQL Server's data types
Possibility to use a database backup like a data source for comparison implemented (only in Professional edition)
Command line support implemented (only in Professional edition)
Quick change of synchronization direction added
Difference viewer for unequal data added
Area for quick description of comparison options added
Detailed progress information for operations added
Improved flexibility to include records into synchronization or exclude
'Ignore columns by mask' option for column mapping added
'Ignore timestamp columns' option for column mapping added
'Ignore ROWGUID columns' option for column mapping added
'Ignore identity columns' option for column mapping added
'Round float types' option for data comparison added
'Ignore trailing spaces' option for data comparison added
'Compare CLR types as binary' option for data comparison added
'Synchronize large data via files' option for synchronization added
'Reseed identity columns' option for synchronization added
'Restore foreign key constraints with CHECK' option for synchronization added
'Exclude comments' option for synchronization added
Action plan for synchronization was extended with additional information
Application's events logging added

1.10.271 28-Jul-09

InvalidOperationException when showing data comparison results was fixed (41181)
Bug with table columns describe was fixed (41024)
Bug with foreign key describing was fixed (41025)
New data synchronization options were added that allow disabling triggers, dropping or recreating keys and indexes during data synchronization (41769)
New data comparison option was added that allows ignoring TIMESTAMP columns during comparison (41773)
The ability to copy action plan and list of warnings in synchronization wizard was added (35027)
Faster comparison of tables

1.0.233 05-May-09

Default Mapping was changed. Tables with identical structures and without any comparison key are mapped by default now
Bug related to the Error List display in case of any errors during comparison has been fixed. (36890)
Accurate display of comparison progress (40776)

1.0.129 04-Feb-09

Error List is cleaned up when synchronization is repeated (37323)
Accurate display of synchronization progress in Execute Script Wizard (37186, 37189)
NullReferenceException while working with filters on the Mapping page in Data Compare Wizard (37277)
Some other interface improvements were made

1.0.123 02-Feb-09

First release of dbForge Data Compare for SQL Server