Migrate a schema from oracle to postgres

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
albourgz
Posts: 160
Joined: Wed 06 May 2009 12:17
Location: belgium

Migrate a schema from oracle to postgres

Post by albourgz » Fri 12 Aug 2016 12:52

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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Migrate a schema from oracle to postgres

Post by MaximG » Mon 15 Aug 2016 09:50

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.

albourgz
Posts: 160
Joined: Wed 06 May 2009 12:17
Location: belgium

Re: Migrate a schema from oracle to postgres

Post by albourgz » Mon 15 Aug 2016 15:13

I know. That's why I ask if another component might help.... perhaps in a future release.

Post Reply