mssql2pg

command module

v0.0.0-...-c660c62 Latest Latest Go to latest Published: Jul 11, 2023 License: MIT Imports: 24 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

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:

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

There is no documentation for this package.