SyncDB

Python ETL helper for moving tabular data between MSSQL, PostgreSQL, MySQL, and local files (CSV, Parquet, Excel, Pickle), with automatic schema creation, schema evolution, and batch progress reporting.

from syncdb import DatabaseConfig, SyncDB

src = DatabaseConfig(engine="mssql", connection_string="...")
dst = DatabaseConfig(engine="postgresql", connection_string="...")

sync = SyncDB(source=src, target=dst)
sync.sync_tables({
    "orders": {
        "source": "dbo.orders",
        "destination": "public.orders",
        "mode": "append",
        "primary_key": ["order_id"],
    }
})

Getting Started

• Installation
• Quick Start

User Guide

• Configuration
• Transfer Modes
• Syncing Tables
• Schema Evolution
• File Operations
• Incremental Sync
• Data Quality Checks
• Progress Reporting

API Reference

• API Reference
• SyncDB
• DatabaseConfig
• Models
• File Transfer
• Schema Mapping

Development

• Contributing
• Changelog