如何将两个或多个不同数据库中的数据存储到第三个数据库 [英] How to get data present in two or more different databases to third database
本文介绍了如何将两个或多个不同数据库中的数据存储到第三个数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
关于
D Ramu
解决方案
在MSSQL中,您可以创建可以传输数据的链接服务器: http://msdn.microsoft.com/en-us/library/ms188279.aspx [ ^ ]
http://www.quackit.com/sql_server/sql_server_2008/tutorial/linked_servers.cfm [ ^ ]
编辑:
确保您的MySql不是仅限本地模式: http: //julianschrader.de/20090218-mysql-how-to-allow-connections-from-outside-of-localhost/ [ ^ ]
Hii everyone, i have a question regarding databases,how should i work with different databases i.e for example i need to get data from two different databases say mysql and oracle to third database say mssql nothing but data migration from one or more databases to another database.Please can any one guide me,how to go with this....Thanx in advance
with regards
D Ramu
解决方案
In MSSQL you can created linked servers with which you can transfer data : http://msdn.microsoft.com/en-us/library/ms188279.aspx[^]
http://www.quackit.com/sql_server/sql_server_2008/tutorial/linked_servers.cfm[^]
Edit:
Make sure your MySql is not in local only mode : http://julianschrader.de/20090218-mysql-how-to-allow-connections-from-outside-of-localhost/[^]
这篇关于如何将两个或多个不同数据库中的数据存储到第三个数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文