I spent this week at eTail Boston, and if you looked at the agenda, you’d …
![]()
Cloud-native POS platform for seamless omnichannel customer experience.
![]()
A single hub for all promotions campaigns.
A comprehensive solution designed to simplify and give you ownership of the inventory lifecycle.
A native post-transaction reconciliation module built into Jumpmind Commerce.
![]()
The most advanced synchronization solution for databases and file systems.
![]()
Data configuration and batch automation across different disparate systems and vendors.
I spent this week at eTail Boston, and if you looked at the agenda, you’d …
Consumers are expected to spend more than $146 billion on back-to-school shopping this year, and …
Shoptalk Europe wrapped up in Barcelona last week and I want to get a few …
Everyone is talking about what AI will do for their business. Very few people are …
SymmetricDS Pro 3.17.3 introduces HikariCP as an available connection pool alongside DBCP2 — and the …
If you run SymmetricDS in production, you know the drill: dozens of nodes, constant data …
Introduction In retail, POS updates have traditionally been quarterly events at best. From October through …
Jumpmind Powers Point of Sale and Promotions Execution for Landmark Retail, One of the Largest …
Retail Technology Leader Jumpmind to Enable Mobile Point of Sale and Inventory Management for DTLR/VILLA …
The offering gives security teams a practical path to risk management and accountable AI COLUMBUS …
The insights have implications for retail technology in the store: it must help mind information …
LONDON – April 21, 2026 – Jumpmind, a leading provider of innovative retail technology solutions, …
![]()
Cloud-native POS platform for seamless omnichannel customer experience.
![]()
A single hub for all promotions campaigns.
A comprehensive solution designed to simplify and give you ownership of the inventory lifecycle.
A native post-transaction reconciliation module built into Jumpmind Commerce.
![]()
The most advanced synchronization solution for databases and file systems.
![]()
Data configuration and batch automation across different disparate systems and vendors.
Compare and Repair for SymmetricDS Pro can compare two databases, report on the differences, and repair the data without interrupting uptime. It works cross-platform between any supported databases, uses parallel threads for performance, and minimizes network traffic. Let’s look at how compare and repair works and why it is required by some businesses.
Using the Manage -> Compare screen in the SymmetricDS Pro web console, the user can request a comparison between two remote databases. Requests can run immediately or be scheduled for a date and time. The user chooses which tables to compare , how to detect changes, and how to report or repair them. Differences can be detected quickly by row counts or more accurately using a checksum. The precision of comparison on decimals, floating points, and timestamps can be restricted to work across different database platforms. For a system that is undergoing changes, in-flight data can be used so it’s not miscounted as differences.
The reporting level can be selected for a quick report or more detailed report. The first level report lists each table and whether it matched or not. The second level report counts rows that are matching, different, missing, or extra. Finally, the most detailed report includes data differences as a SQL script with insert, update, and delete statements to repair the target database. Afterwards, the user can choose to have the repair script applied automatically to the target database.

Compare and repair works across the existing HTTP/S links that SymmetricDS Pro uses for data replication. Therefore, it can compare remote databases across a wide-area network. To minimize network usage, it separates data into chunks and calculates a checksum that is sent back to the source. Similarly, to minimize database overhead, it orders and processes data outside of the database. Furthermore, parallel threads are used to process tables simultaneously for improved performance.
It’s possible for differences in data to occur for the following causes:
Here are some reasons businesses require verification of their data:
Compare and repair compliments database replication by verifying that data is a reliable source of information for insights, analytics, and intelligence. Incomplete or incorrect data can have real-world implications on a business. In healthcare, it could make a mistake with patient care. In retail, it could make a mistake in expansion. In finance, it could violate a sanctions list. Error-free data that has been verified is a good step towards data that it is useful and actionable.