- Omega Sync, SQL database comparison and synchronization

Documentation

Back to Omega Sync

 

Options - Comparison settings

Data Sync automatically handles all the data type differences. Accuracy is always preferred to the comparison speed. By default we compare XML data by creating XML documents in memory and comparing each node, attribute and value (order of attributes should not matter when comparing XML, for example). However, this takes time and cosumes memory. You can choose to compare XML data as if they were ordinary text. If you are saving your XML data from the same application, in your specific scenario it might be a proper way, and it will take much less time and RAM.

The other option is to ignore Unix/Windows line ending differences. This means that \r\n will be the same as \n to our compare engine.

Data is always read in chunks instead of fetching whole table into memory. Our advanced algorithms allows us to do so with negligible speed impact. This feature enables Omega Sync to support comparison and synchronization of huge tables and databases, virtually of unlimited size.

options-datacompare