Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

mysql connector ODBC 5.2 Expand / Collapse
Author
Message
Posted Sunday, June 02, 2013 4:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 03, 2013 10:21 AM
Points: 7, Visits: 23
I tried to transfer data from ms sql server 2012 to mysql using sql server export, but could not find mysql connector ODBC 5.2 on the distination dropdown. I already have mysql connector ODBC 5.2. Any ideas on how to make it work?

Thanks.
Post #1458992
Posted Sunday, June 02, 2013 9:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:21 AM
Points: 11,935, Visits: 10,971
I am by no means a MySql expert. Can you import it from the MySql side? You may have to do a two step process. First export from sql to csv and then import that to MySql.

A quick google search revealed there is not a direct way to do this with the native tools. It seems there are quite a few free tools out there that can import/export from sql server to MySql.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1459004
Posted Sunday, June 02, 2013 10:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 03, 2013 10:21 AM
Points: 7, Visits: 23
Thanks for the idea. I might have to export to a CSV file before importing into mysql. However, from my research, it seems it has to do with 32bit ODBC not surfacing in the odbc administrative tool of a 64bit operating system. It is a general problem, and not by any means new. Thanks once more for responding.
Post #1459017
Posted Monday, June 03, 2013 4:53 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, January 31, 2014 2:56 AM
Points: 483, Visits: 256
You don't specify how you transfer data, but if you're using SQL Server Import and Export Wizard you need a 32 bit ODBC-driver.

There's two ODBC Administrators:

32 bit %windir%\syswow64\odbcad32.exe
64 bit %windir%\system32\odbcad32.exe

General rule:
32 bit software uses 32 bit (ODBC-)drivers
64 bit software uses 64 bit (ODBC-)drivers
Post #1459180
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse