Question
Wells Fargo
Wells Fargo
IN
Wells Fargo
Posted: Jun 25, 2024
Last activity: Jul 12, 2024
Last activity: 12 Jul 2024 10:53 EDT
Closed
Solved
Migrating from Oracle to SQL
Our application is migrating from Oracle to SQL DB.
Are there any migration tools available or any specific approach that you would suggest for a hasle free migration.
***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Accepted Solution
Posted: 1 year ago
Updated: 1 year ago
Updated: 12 Jul 2024 10:53 EDT
MOD
Pegasystems Inc.
GB
@ansumanm9631 please can you check the 'Related Content' side bar? This question has been asked on the forum several times before.
For migrating from Oracle to SQL DB, you can consider using data migration tools that are compatible with both databases. However, the specific approach would depend on your application design and the complexity of your database schema. If your application design follows a layered cake structure, you could export the custom rulesets as a RAP (Rule-Admin-Product) and import them into the new system. Please note that any Oracle-specific functions used in the SQLs have to be converted to SQL Server compatible functions. It's also important to thoroughly test the application after the migration to ensure all functionalities are working as expected.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
We are planning to Migrate our DB from Oracle 12c to PostgreSQL on Pega 7.4
Requesting List of steps or guide for DB Migration from Oracle 11G R2 to ORACLE 12c
Migrating from Oracle to PostGreSQL
@ansumanm9631 please can you check the 'Related Content' side bar? This question has been asked on the forum several times before.
For migrating from Oracle to SQL DB, you can consider using data migration tools that are compatible with both databases. However, the specific approach would depend on your application design and the complexity of your database schema. If your application design follows a layered cake structure, you could export the custom rulesets as a RAP (Rule-Admin-Product) and import them into the new system. Please note that any Oracle-specific functions used in the SQLs have to be converted to SQL Server compatible functions. It's also important to thoroughly test the application after the migration to ensure all functionalities are working as expected.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
We are planning to Migrate our DB from Oracle 12c to PostgreSQL on Pega 7.4
Requesting List of steps or guide for DB Migration from Oracle 11G R2 to ORACLE 12c
Migrating from Oracle to PostGreSQL
Moving from one Database Server to Another
Out of Place Upgrade from 7.3.1 to 8.6.2 Data Migration