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 PostgreSQL?

April 26, 2017Data migrate ODBC PostgreSQL source

0

10 Posted

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

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 PostgreSQL tool. You can start Data Pump from STUDIO by choosing Data Manipulation tab and then clicking on Data Pump for PostgreSQL. Or go to Start->Programs->EMS->SQL Studio for PostgreSQL->Data Pump for PostgreSQL->Data Pump for PostgreSQL. When working with the utility you should use OLE DB Provider for ODBC Drivers to connect to your ODBC data source.