Question
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.
Hi Kunal, here are few comments
1. yes. review the SQL that is being applied in UAT & make necessary changes.
2. this should not be a problem.
3. do you have any specific problem with column types?
4. vendor specific queries needs to reviewed and updated.
5. yes, this would require update as well. you could use circumstancing based on db vendor.
just curious - why do you have different databases for dev & UAT? that is not common.