MySQL至SQL Server传输数据 [英] MySQL to SQL Server transferring data

问题描述

我需要将MySQL数据库中已经存在的数据转换为SQL Server数据库.

I need to convert data that already exists in a MySQL database, to a SQL Server database.

这里的警告是，旧数据库的设计不佳，但是新数据库采用的是正确的3N格式.有人对如何执行此操作有任何提示吗?我有SSMS2005.

The caveat here is that the old database was poorly designed, but the new one is in a proper 3N form. Does any one have any tips on how to go about doing this? I have SSMS 2005.

1. 我可以使用它连接到MySQL数据库并创建DTS吗?还是我需要使用SSIS?
2. 我是否需要编写MySQL数据库脚本并更改每个语句以插入"到SQL Server数据库中?

有人以前经历过这个吗?请帮助！！！

Has anyone gone through this before? Please HELP!!!

推荐答案

请参见

See this link. The idea is to add your MySQL database as a linked server in SQL Server via the MySQL ODBC driver. Then you can perform any operations you like on the MySQL database via SSMS, including copying data into SQL Server.

恭喜您在RDBMS世界中崭露头角！

Congrats on moving up in the RDBMS world!

这篇关于MySQL至SQL Server传输数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！