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

Option for ALTER TABLE ADD CONSTRAINT being in a separate file #1727

Closed mgerhardy closed 5 months ago

mgerhardy commented 5 months ago

We are having constraints that go over different schemas, and it's not possible to execute the resulting statements without taking the order into account, and even worse - we have a cycle here. So for us it would be great to get such an option to activate the constraints after all schemas and tables were imported without them before.

darold commented 5 months ago

Normally if the configuration directive FILE_PER_CONSTRAINT is set to 1 all constraints will be saved into a dedicated file.

mgerhardy commented 5 months ago

thanks - and sorry for the noise