Importing data into SQL server 2008 R2 from MYSQL 5.5
Posted on 2014-03-18
I'm new to MYSQL and need to export data from MYSQL into SQL Server. I have tried downloading a ODBC driver onto the machine however I get an architecture mis match message when trying to use SSIS to create the connection or using import/export method from SQL Server.
I have also tried using a linked server however get this message:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "CODA_IMPACT".
OLE DB provider "MSDASQL" for linked server "CODA_IMPACT" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". (Microsoft SQL Server, Error: 7303)
Can you please advise what the best method is for this. I am a SQL server DBA and have very little experience of MYSQL!
Many Thanks in advance