Sync operational data between embedded and server databases
Four-in-one utility for migrating, synchronizing, and scripting database contents across H2, SQL Server, and other platforms.
What it is
H2DB to SQL Server Data Sync is a Java utility that moves data between embedded H2 databases and SQL Server instances. It includes four independent tools: process monitoring (continuous sync of operational metrics—meter settings, device mappings, communication status, scheduler records), H2DBCreator (full schema and data replication from SQL Server to H2), MSSQLToH2DBDataScriptGenerator (export SQL Server data as insert scripts for import into H2), and H2DbToH2DbSync (synchronization between two H2 databases). Intended for system integrators managing test environments, staging databases, and operational data workflows.
Key benefits
Four independent data workflows in one tool
Choose the right job: replicate an entire schema and dataset (H2DBCreator), export SQL Server as scripts for offline import (MSSQLToH2DBDataScriptGenerator), sync live operational data bidirectionally (process monitoring), or mirror between two H2 instances (H2DbToH2DbSync). No need for multiple tools or manual scripting.
Schema-aware table ordering prevents FK constraint failures
The tool enforces dependency order (location types → locations → device types → devices → controllers → etc.) defined in the platform's table registry. Eliminates manual ordering and constraint violation errors during bulk loads.
Idempotent re-runs and operational-data focus
Primary key violations are tracked silently, allowing safe re-execution for incremental syncs. Syncs only operational tables (meter config, GPRS status, scheduler records), not the full schema, so deployments stay lightweight.
Supports multiple database platforms
Works with SQL Server, H2 (embedded and server mode), MySQL, PostgreSQL, and SQLite. Switch databases without code changes—configure via a single XML connection file.
Capabilities
- Replicate full platform database schema and 100+ tables from SQL Server to H2
- Export SQL Server data as SQL insert scripts for offline H2 import
- Sync operational metrics (meter config, device mappings, communication status, scheduler records) from H2 to SQL Server
- Synchronize data between two H2 databases with duplicate detection
- Validate and apply database schema creation and alteration scripts
- Multi-platform JDBC connectivity (SQL Server, H2, MySQL, PostgreSQL, SQLite)
- License validation at startup via native certificate check
- Configurable log output with rolling file management