RDBMerge

RDBMerge is a specialized tool designed to merge relational database dumps (SQL) from multiple sources into a single, coherent script that can be executed in a target environment. It targets database administrators, data engineers, migration teams, and analytics projects that consolidate data from disparate deployments. The tool focuses on preserving data integrity, preserving provenance, and reducing manual re-creation of merged datasets. It operates without requiring live connections to source databases, working directly from export files to minimize risk during consolidation.
Conceptually, RDBMerge parses each input dump, normalizes encoding, and builds a unified schema map. It compares table and column definitions, aligns data types, and detects conflicts in rows or keys. Conflict resolution is rule-based: last-write-wins, version-priority, or per-table custom rules. It then deduplicates rows by primary keys, reconciles constraints, and emits a merged SQL script that preserves referential integrity. Optional CSV exports provide data views for validation and audit trails.
Core value lies in its determinism and reproducibility: given the same inputs, the merged output remains consistent across runs. It supports arbitrary numbers of dumps, is dialect-aware to generate portable SQL, and produces a clear report of differences and conflicts. Use cases include data warehouse migrations, multi-source integrations, disaster recovery preparations, and pre-production environment seeding. Unique differentiators are comprehensive conflict policies, provenance preservation, and the ability to produce both a complete merged dump and selective data extracts.