Close popover
Kunal Kakade (KunalK72)
Tech Mahindra

Tech Mahindra
KunalK72 Member since 2014 1 post
Tech Mahindra
Posted: February 5, 2016
Last activity: July 14, 2017

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.

System Administration Installation and Deployment Upgrades Data Integration
Moderation Team has archived post