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
991 stars 342 forks source link

Is the DELETE option available from the command line? #1625

Closed ryanewtaylor closed 1 year ago

ryanewtaylor commented 1 year ago

I have a use case where we're automating monthly migrations of tables and table data. The data we select to export and subsequently delete during import is dynamically driven/requires user input.

We've created a PowerShell script that applies the appropriate command line options to supplement and/or override an existing ora2pg.conf file for many options, but it doesn't appear that there is a command line for selective DELETE.

Is select DELETE only available within the config file or is there a command line option for it?

darold commented 1 year ago

Commit f1e7e3b adds the --delete command line option to be able to dynamically set the DELETE clause. It works just like the --where clause.