Migrating Data from Postgres SQL DB to Oracle DB using Studio Pro

0
Restored a UAT data in Pgadmin and made a connection with Oracle sql developer software by configuring the details in the application ( Settings --> Configurations )   Also we made changes in Custom tab,     Any suggestion on this connection setup ? If anything Kindly let us know....   Ran the application and able to view it in browser. We couldn't able to view the backup data ( which we restored via Pgadmin ) in Oracle sql Developer but we can able to see the tables under the OracleDB1 (Refer below)   What we need to do to migrate the old data to oracle from postgres DB by using studio pro?   We referred the Mendix documentation : https://docs.mendix.com/howto/data-models/migrating-your-mendix-database/#overview   It would be great if anyone help us on the above question.    Thanks in Advance!
asked
1 answers
0

Hi Aarthi,

 

Mendix will only restore the data in the PostgresDB if the Oracle DB is totally empty.

The SourceDatabaseHost constant is just a portnumber right now, you didn't specify the entire location. Try using "localhost:5432" 

answered