Question

4
Replies
1484
Views
KunalK72 Member since 2014 1 post
Tech Mahindra
Posted: 4 years ago
Last activity: 3 years 3 months ago
Closed

Migrate Code from Oracle to PostGre database

Consider a scenario such that Dev environment is on oracle database and UAT/Prod is on PostGre SQL database. What could be the possible problems faced?  Following questions came to my mind,

1.        Is RAP(Product) compatible while migrating code from dev to UAT/Prod environment? Considering, there are some SQL scripts that are created by PRPC itself for alter table which are run on DB during migration.

2.       Can there be any runtime rule execution errors when Dev and UAT environments are on different database?

3.       Columns datatype created in Oracle are compatible with PostgreSQL?

4.       During migration schema.xml contains some queries which are vendor specific. Can that cause a problem?

5.       What about the complex SQL queries built for Reports? Becuase those may contain database specific syntax.


In addition to these, please ask any other questions come to your mind.


And mainly, using two different databases for two different environment is feasible or not? What are pros and cons? What could be the problems faced in future for application maintenance.

Low-Code App Development Installation and Deployment Low-Code App Development Upgrades Data Integration
Moderation Team has archived post
Share this page LinkedIn