Question

Using Postgres Metadata to migrate data from oracle to postgres

  • 14 March 2023
  • 4 replies
  • 47 views

I have a JDBC Multi-table consumer as a source where it is connected to oracle database.

Now I want to migrate the data along with the tables and its constraints, triggers, procedure, sequences etc. to Postgres DB.

Currently I was exploring the Postgres Metadata Processor, but it is only reflecting the tables and columns with its respective data type.

Can anyone please help me out in configuring the Postgres Metadata processor to migrate the constraints, triggers etc.


4 replies

Userlevel 5
Badge +1

@shobhit_pathak

can you please try with below origin and destination.

You can connect to postgre sql by using jdbc connection string and process data to postgre DB.

If you want to do lookup in between data processing then you can use jdbc lookup procesor.

 

This will help you to handle the use cases.

In this case you can write your own query and also can call the procedure etc.

Please let me know if it helps.

 

 

Thank you @Bikram , but this is not exactly what I was looking for.

I want to capture the data along with the tables DDL in Oracle and reproduce the same data and tables DDL in Postgres.

Basically, it is all about migrating all Oracle meta-data to Postgres.

Userlevel 4
Badge

@shobhit_pathak the main use of Postgres Metadata processor is for data drift synchrinisation.

You should look at some database migration tools and choose one that suits your requirement,

@saleempothiwala Thanks for your response, I will look into it.

Reply