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:

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.

Name		Name	Last commit message	Last commit date
Latest commit History 32 Commits
.gitignore		.gitignore
LICENSE		LICENSE
Makefile		Makefile
README.md		README.md
cmd_fullcopy.go		cmd_fullcopy.go
cmd_fullcopy_test.go		cmd_fullcopy_test.go
cmd_init_config.go		cmd_init_config.go
cmd_replicate.go		cmd_replicate.go
cmd_replicate_test.go		cmd_replicate_test.go
cmd_restore_fks.go		cmd_restore_fks.go
compose.yaml		compose.yaml
config.go		config.go
go.mod		go.mod
go.sum		go.sum
main.go		main.go
metrics.go		metrics.go
mssql.go		mssql.go
mssql_test.go		mssql_test.go
postgres.go		postgres.go
postgres_test.go		postgres_test.go
sqlite.go		sqlite.go
sqlite_test.go		sqlite_test.go

Provide feedback