Skip to content
This repository was archived by the owner on Sep 2, 2024. It is now read-only.

Latest commit

 

History

History
13 lines (8 loc) · 666 Bytes

README.md

File metadata and controls

13 lines (8 loc) · 666 Bytes

mssql2pg

Continuously replicates data from SQL Server to PostgreSQL with minimal table locking.

Limitations:

  • Can only replicate tables with primary keys.
  • Does not copy schema. This also means that schema updates on source after the data replication is started must be manually applied on destination too.

What this program does in general:

  1. Existing data is copied using SELECT ... WITH (NOLOCK) on SQL Server's side, and COPY ... on Postgres' side.
  2. Table updates are continuously replicated using Change Tracking feature in SQL Server.