Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I have a ODBC data source. Can I migrate from it to MySQL?

April 26, 2017Data migrate MySQL ODBC source

0

10 Posted

I have a ODBC data source. Can I migrate from it to MySQL?

1 Answer

0

10 Posted

ODBC (Open DataBase Connectivity) is an open standard interface to access databases developed by Microsoft. The most database management systems have their own ODBC driver or the one developed by other software producers. To migrate from ODBC data source you need to use Data Pump for MySQL tool. You can start Data Pump from STUDIO by choosing Data Manipulation tab and then clicking on Data Pump for MySQL. Or go to Start->Programs->EMS->SQL Studio for MySQL->Data Pump for MySQL->Data Pump for MySQL. When working with the utility you should use OLE DB Provider for ODBC Drivers to connect to your ODBC data source.