EXRP如何将数据库迁移到MS SQL?有哪些需要注意的?
EXRP如何将数据库迁移到MS SQL?有哪些需要注意的?
可以参考此链接:
https://download.manageengine.com/products/exchange-reports/postgresql-to-mssql-server-migration.pdf
注意事项:
1.Native client和command line放在EXRP服务器上
2.Bcp那两个文件拷贝到EXRP安装目录
3.2016的组件一般用2012的,2012的不好用可以2008的+odbc,odbc网址:
https://www.microsoft.com/en-us/download/confirmation.aspx?id=57606
https://download.microsoft.com/download/6/4/5/645B2661-ABE3-41A4-BC2D-34D9A10DD303/ENU/x64/MsSqlCmdLnUtils.msi
/x86/msodbcsql.msi