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.
Migrate a schema from oracle to postgres
Re: Migrate a schema from oracle to postgres
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
I know. That's why I ask if another component might help.... perhaps in a future release.