ChangeDB入门

安装ChangeDB

yscorecore/changedb (github.com)
dotnet SDK 6.0
dotnet tool restore
dotnet tool install changedb.consoleapp -g
dotnet tool list -g

运行命令

changedb migration {source-database-type} "{source-connection-string}" {target-database-type} "{target-connection-string}" 

sqlserver -> postgres

changedb migration sqlserver "Data Source=(LocalDB)/MSSQLLocalDB;Initial Catalog=<DatabaseName>;Integrated Security=SSPI;"
postgres "Server=127.0.0.1;Port=5432;Database=<PostgresDatabaseName>;User Id=<postgres>;Password=<xxxxxx>;"

sqlce -> sqlserver

ChangeDb migration --max-fetch-bytes 10000 sqlce "Data Source=C:/xxxxxx.myox;Max Database Size=2048; Persist Security Info=False;" 
sqlserver "Data Source=(LocalDB)/MSSQLLocalDB;Initial Catalog=<DatabaseName>;Integrated Security=SSPI;"

sqlce -> postgres

ChangeDb migration --max-fetch-bytes 10000 sqlce "Data Source=C:/xxxxxx.myox;Max Database Size=2048; Persist Security Info=False;" 
postgres "Server=localhost;port=5432;Database={DBName};User Id=postgres;Password={PASSWORD}"

修改Schema

复制数据库备份

CREATE DATABASE db_backup WITH TEMPLATE "db"