Postgresql到ms SQL server 2017迁移错误 [英] Postgresql to ms SQL server 2017 migration error
问题描述
我正在尝试将postgre sql数据库迁移到MS sql数据库。 MS sql server是一个
的远程服务器。我正在尝试使用链接服务器,但我得到(错误7303
未找到数据源且未指定默认驱动程序。)
我尝试过:
我已经为PostgreSQL下载了ODBC驱动程序(64位)并进行了设置一个数据源和
MS sql server尝试使用Windows身份验证添加链接服务器但是我收到错误7303
(我是否必须在MS sql server中设置任何驱动程序或数据源?ms sql server创建链接服务器的要求是什么?)
Hi,
I am trying to migrate postgre sql database to MS sql database. MS sql server is a
remote server. I am trying to do it with linked server but I am getting (error 7303
Data source not found and no default driver specified.)
What I have tried:
I have downloaded ODBC driver(64 bit) for PostgreSQL and setup a data source and on
MS sql server tried to add linked server with windows authentication but I am getting error 7303
(do I have to setup any driver or data source in MS sql server? what are the requirement of ms sql server to create linked server ? )
推荐答案
我怀疑链接服务器是否可以与PostgreSQL一起工作。
我曾经编写过一个可以将SQL Server转换为PostgreSQL的控制台应用程序,也许你会发现它很有用,你只需将其重写为做相反的事情:)
转换SQL Server数据库ase to PostgreSQL [ ^ ]
另一种选择可能是这种转换工具: PostgreSQL到MS SQL迁移和同步 [ ^ ]
I doubt that a linked server is going to work with PostgreSQL.
I once wrote a console application that can convert SQL Server to PostgreSQL, maybe you will find it useful, you just have to rewrite it to do the reverse thing :)
Convert SQL Server Database to PostgreSQL[^]
Another option might be this conversion tool: PostgreSQL to MS SQL Migration and Sync[^]
这篇关于Postgresql到ms SQL server 2017迁移错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!