June 16, 2014 at 3:09 pm
I've been asked to create reports and queries that validates data in two separate databases, SQL Server and MySQL. I'm not a big MySQL guy and I don't have the options to purchase 3rd party tools, so, my best bet (I think) is to import the MySQL data into tables in SQL Server and then run comparisons against the two. Is this my best bet?
Also, I've tried running some tests and imports by setting up an ODBC connection to MySQL. I can test the connection and it works in the ODBC screen, however, when I attempt to import data into SQL Server I consistently get an error that the Data source name wasn't found. I double checked ODBC and it looks fine to me. I'm also running 64-bit everywhere.
Thanks for the help
June 17, 2014 at 12:17 am
JoshDBGuy (6/16/2014)
I've been asked to create reports and queries that validates data in two separate databases, SQL Server and MySQL. I'm not a big MySQL guy and I don't have the options to purchase 3rd party tools, so, my best bet (I think) is to import the MySQL data into tables in SQL Server and then run comparisons against the two. Is this my best bet?Also, I've tried running some tests and imports by setting up an ODBC connection to MySQL. I can test the connection and it works in the ODBC screen, however, when I attempt to import data into SQL Server I consistently get an error that the Data source name wasn't found. I double checked ODBC and it looks fine to me. I'm also running 64-bit everywhere.
Thanks for the help
Have you tried openrowset?
😎
June 17, 2014 at 5:18 am
Hi Josh, are you using a file, system, or user DSN? And how are you attempting to connect to MySQL from SQL Server?
Thanks
Gaz
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply