Online Documentation for Data Comparer for SQL Server

Version history

 

 

 

Version 3.5.3

• Added support for new  server version.
• Minor fixes and improvements.

 

Version 3.5.2

• Added support for new server versions: SQL Server 2017, MySQL Server 8, PostgreSQL 12.
• Support for Azure SQL Database implemented.
• FB/IB. Fixed synchronization of TIME and DATETIME data types with milliseconds.
• FB/IB. Support for BOOLEAN type implemented.
• FB/IB. Triggers were not disabled correctly. Fixed now.
• MySQL. The 'MySQL has gone away' error has been fixed.
• PostgreSQL. The MATCH option is now processed correctly on creating FK.
• Other fixes and improvements.

 

Version 3.5.1

•  Comparing and synchronization of big tables has been considerably improved.
•  The speed of comparing BLOB fields has been increased.
•  Now BINARY fields can be selected as key fields for comparison.
•  Field list was not refreshed on changing the tables. Fixed now.
•  The selected charset was not applied to the SQL-script. Fixed now.
•  The errors on loading the template file have been fixed.
•  Some other improvements and bug-fixes.

 

Version 3.5.0

• Added the possibility to manually set a list of synchronized records.
• Now it is possible to check for active triggers in the synchronized tables. If there are triggers in the target table, you will be prompted to disable them.
• Added the possibility to set filters on the basis of the LIKE operator.
• Added support of SQL Server 2012.
• Now at the "Setting tables correspondence" step a filter can be viewed as the pop-up window.

 

 

Version 3.4.0.1

• Now the comparison results can be exported to MS Excel 2007.
• The progress window now displays the time remaining and the number of records per second.
• Data Filter. Added the OR and AND operations.
• When selecting text fields as key fields, the table comparison speed significantly increased.
• The table comparison on the server side is now optional.
• Added the possibility to save a template at any step of the wizard.
• Some other improvements and bugfixes.

 

Version 3.3.0.1

• Added the possibility to compare data using filters;
• Added the "Trim CHAR Fields" option, which allows to trim spaces in CHAR and NCHAR fields while comparing and synchronizing data;
• Added the Jump List with a list of templates for Windows 7;
• If while synchronizing data, the number of records returned from the server is smaller than the expected amount to be synchronized (i.e. because of triggers), now a warning is written to the log-file;
• Added the path parameter to the log file in the console version;
• Some other improvements and bugfixes.

 

Version 3.2.0.1

 

• RAM usage is optimized. Now the product consumes less memory when working with large tables.
• Added the new option - ‘Fill correspondence automatically’ for the console version. When enabled, new tables in the database (created after generating a template) are also synchronized and compared when databases are compared.
• When loading a template, the application can now ask for a password for the database if necessary.
• Added the possibility to encrypt passwords in the template.
• Sometimes table data were sorted incorrectly when displaying comparison results. Fixed now.
• When synchronizing databases located on one server, it is now possible to generate synchronization scripts containing table data.
• Added hints for options located on the application forms.
• Other minor improvements and bugfixes.

 

Version 3.1.0.1

 

• Added the ‘Disable foreign keys’ option on the Step 4 - Specifying data synchronization options which allows disabling foreign keys when inserting or modifying data.
• The ‘Before synchronization script’ and ‘After synchronization script’ on the Step 7 - Specifying additional scripts are now executed in the same connection context where the synchronization is performed.
• Script Editor. When saving and re-opening the editor, the character set chosen in the previous session is saved.
• If any database errors occur during the comparison process, the program informs about errors and offers to continue. The error texts are displayed as a hint in the Summary dialog.
• BLOB Editor. Added the possibility to view texts in Unicode.
• The process of selecting tables to compare has become more convenient.
• Added the possibility to disable the code folding in editors.
• Added the possibility to export comparison results of all tables at once.
• Added the possibility to use filters during the code completion.
• Some other small bugfixes and improvements.

 

Version 3.0.0.1

 

1. The comparison and synchronization algorithm is significantly improved and is optimized for working with large databases:

• The comparison speed is considerably increased, in some cases up to 5 times.
• The synchronization speed is increased, especially in cases when compared tables are located on one server.
• The amount of the consumed RAM is reduced, now it does not depend on the number of records in compared tables which allows avoiding the Out of Memory error.
• The speed of auto-fill in tables and fields is increased.

2. Added the possibility to synchronize BLOB fields in InterBase.
3. Added the option for viewing the Summary for the compared objects at the Step 3 - Browsing data comparison results.
4. Synchronization with deleting of records from tables containing foreign keys could result in an error. Fixed now.
5. Added the possibility to clear the template list.
6. Some other small bugfixes and improvements.

 

Version 2.3.0.1

 

• Added the Commit after synchronization option allowing to rollback all changes if an error occurs during the synchronization process.
• Added the possibility to define table synchronization order manually.
• Added the possibility to generate a summary report with table comparison results.
• It is now possible to sort and filter comparison results.
• Encrypted passwords within templates created with older versions of the utility could not be read properly. Fixed now.
• Some other small bugfixes and improvements.

 

Version 2.2.0.1

 

• Added tools for exporting comparison results to HTML and RTF
• The new enhanced Script Editor
• Added the possibility to output the detailed error description in the console application
• Optimized the script generation mechanism: now only different fields are added to the synchronization script
• Added tools for printing synchronization logs
• Other minor improvements and bug-fixes

 

Version 2.1.0.1

 

• Now you are able to set up SQL statement batches which will be executed before and/or after the synchronization process
• The possibility to select DB schemas for data comparison is added
• Tables for which the set of key fields differs from primary key fields are synchronized significantly faster now
• Table lists are sorted by table and schema name now
• The possibility to save synchronization logs to a file is implemented
• The number of DB connections coincides with the number of selected threads
• Other minor improvements and bug-fixes

 

 

Version 2.0.0.1

 

• Multi-threading for data comparison
• Support for more data types provided: nchar, nvarchar, ntext
• Boosted synchronization speed
• A more convenient way of browsing differences in compared data
• Implementation of the Find Text dialog in Script editor
• Processing of Foreign keys implemented
• An opportunity to select tables after data comparison
• Export of comparison results to MS Excel documents
• The ‘Detailed error messages’ option at the synchronization step
• Encrypted passwords storage
• Added the ‘Fast comparison’ option for data comparison and synchronization process

 

 

Version 1.2.0.1

 

• Viewing/editing synchronization script with Script editor
• The 'Drop and create indexes' synchronization option added
• For the fields which are not in comparison the default values will be applied now (in previous versions NULL values were used)
• Now it is possible to abort synchronization on error with the help of corresponding option
• The console version of Data Comparer for SQL Server now allows running the application in background mode

 

 

Version 1.1.0.1

 

• New BLOB viewer
• Higher speed of comparing process
• The ability to view the connection information is added
• The "Use only compare key for where clause" option is available at the specifying data synchronization options step now
• The "Add computed and read-only fields to the new table" option is added
• The ability to specify the appropriate client library is implemented
• Primary key auto-setting for the fields to be compared
• Color highlight for non-identical records is implemented
• The "Commit after records" option is added

 

 

 

---