export mysql Database(remote VM) to local SQL Server 2008


  •  the first problem i met is using data connection in visual studio 2010 to get a database located in remote machine. So i add connection and choose data source .NET Framework Data Provider for ODBC, and get the connection string, which i had add before in my ODBC Manager(with name and passwort of course), and then i click test connection, it is successful, problem is i can not open tables, i can not see the rows and columns. i tested a connection with northwind.sdf, there was no problem.

    so i tried to export the same database(mysql data in remote VM) to my local SQL Server 2008

     i use MS Sql server 2008 import and Export Data(32-bit) Wizard, choose a data Source: Net Framework Data Provider for ODBC, destination: SQL Server Native Client 10.0 Local Server , it has error: Can not locate Mapping files.


    Thursday, April 08, 2010 2:27 PM


All replies