Question
Wells Fargo
IN
Last activity: 12 Jul 2024 10:53 EDT
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.
Accepted Solution
Updated: 12 Jul 2024 10:53 EDT
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