Does ora2pg support direct migration of data from Oracle, MySQL, and SqlServer to postgreSQL databases?

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

http://www.ora2pg.com/

GNU General Public License v3.0

978 stars 341 forks source link

Does ora2pg support direct migration of data from Oracle, MySQL, and SqlServer to postgreSQL databases? #1763

Closed ruralqiu closed 3 months ago

ruralqiu commented 3 months ago

Does ora2pg support direct migration of data from Oracle, MySQL, and SqlServer to postgreSQL databases? How should the ora2pg. conf file be configured so that database objects and data from the source library are not saved in the file?

darold commented 3 months ago

Yes it is supported and recommended to migrate data. See PG_DSN directive in ora2pg.conf, once it is set, Ora2Pg will send the data to the PostgreSQL database you have specified in the connection string and no more to files.