search

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

Mysql migration #1775

Open mgole001 opened 2 months ago

mgole001 commented 2 months ago

Hi,

I have been trying to use ora2pg for mysql migration

Created initial configuration and template Updated ora2pg conf file with Mysql and PG DSN Export_schema.sh runs ok When I try to export data using ora2pg - t COPY -o data.sql -b ./data - c

I get below error FATAL: LDAP authentication failed for user "test_user" Aborting export

Test_user is a valid db user in Postgresql and I can connect to Postgresql database using it

Secondly I get the below error when I run ./import_all.sh -U test_user -d testdb -p 5446 -n testschema -o test_user

When I try to import TABLE by selection Y

Error : no schema has been selected to create in LINE 1 : CREATE TABLE account (

Error : an error occurs when importing file ./schema/tables/table.sql

How do I resolve these 2 errors? Thanks

darold commented 2 months ago

You have LDAP authentication enabled in your pg_hba.conf so the user must be also declared in LDAP.

For the schema you probably have to enable EXPORT_SCHEMA.