I was wondering if anybody had any advice or references that explain how to pull data from MySQL and drop it into SQLSever! Any input would be greatly appreciated!! Thanks!
-
mysqldump, please take a lok to this link: dev.mysql.com/doc/refman/5.1/en/…jcho360– jcho3602012-06-08 20:27:44 +00:00Commented Jun 8, 2012 at 20:27
-
There are many tools to do this kind of thing. If you already have SQL Server, you can use SSIS.Lamak– Lamak2012-06-08 20:55:14 +00:00Commented Jun 8, 2012 at 20:55
-
It would be helpful to know if you are migrating to MS SQL Server or want to access data in MySQL.octopusgrabbus– octopusgrabbus2012-06-08 23:12:44 +00:00Commented Jun 8, 2012 at 23:12
Add a comment
|
2 Answers
You can add MySQL as a "linked server"
http://forums.mysql.com/read.php?60,123221,123221
Once you did that you can reference the MySQL tables, views, etc with their fully qualified name in regular SQL Server queries
Comments
I could not tell if you wanted to access a MySQL database because you were migrating to SQL server, or if you wanted to access a MySQL database on an ongoing basis. I am answering as if you want to migrate, because you already have an excellent answer on accessing MySQL from SQL Server.
If you want to migrate, mysqldump is one way to go. Its format is easily parsed.
You can also write the results of any MySQL table -- and SQL Server for that matter -- to .csv format. .csv format is nearly a universal transfer format for data.
5 Comments
octopusgrabbus
This sounds like the linked server approach is best, because you're doing that on a regular basis.
octopusgrabbus
I would add this to my answer, but I have not done this work. My original answer uses a method I employ in production. Set up a bot to extract .csv into a location. Either the sending side ftp's data to the recieving side, or the receiving side ftp's from the sender. Then the receiving side inputs that data.