Page 1 of 1

Migrate a schema from oracle to postgres

Posted: Fri 12 Aug 2016 12:52
by albourgz
Hi,

I would like to migrate a whole schema from oracle to postgres.
I tried TUniDump .Backup(), I can see insert statements, but I didn't find any way to see:
* create table statements,
* create sequences with exported values,
* create views,
* foreign keys.
TUniMetaData can show some objects (e.g. sequences but no values) and doesn't generate create table statement AFAIK.

Any hint?

Kind regards.

Re: Migrate a schema from oracle to postgres

Posted: Mon 15 Aug 2016 09:50
by MaximG
TUniDump is designed mainly for saving table data as a script. Executing such script allows to restore this data. TUniDump is not a tool for migration from one database to another, therefore it misses the capability to use various Oracle DB objects.

Re: Migrate a schema from oracle to postgres

Posted: Mon 15 Aug 2016 15:13
by albourgz
I know. That's why I ask if another component might help.... perhaps in a future release.