Data migration from postgresql to mssql
We requirement to migrate the database base postgresql to mssql and need to move data as well.plesse provide the steps for this.
***Edited by Moderator Marissa to update categories***
Pegasystems Inc.
IN
Hi,
Since this is just DB migration, Pega won't be maintaining any dedicated document for it.
Please refer the below discussion on the same
Thank You
Pegasystems Inc.
IN
Hi Mahipal,
If you are moving from Pega v7.2.1 to v7.3, then it should be an update and not an upgrade, please refer the below link for the same:
https://collaborate.pega.com/question/pega-715-731-upgrade-or-update
Below is the update guide for an update to 7.3:
https://collaborate.pega.com/question/unclear-description-point-pega-73-platform-update-guide
Regards,
Vikash
Toyota Financial Services
AU
We have two approaches in achieving database migration.
Approach #1: Install and run the new instance on the new database and then migrate the Application Data using RAPS. After the imports, migrate the case data using DB scripts.
Preferred approach, as we have complete understanding on what are the rules that are being migrated and being failed, and any database compatibility issues can be easily identified.
For example, Postgresql doesn't support stored procedures. Need to convert those into functions to make it work.
Approach #2: Migrate the entire database using db scripts to the new database. Not recommended, as this very difficult to trace the errors or exceptions after the migration.
FYI... Prerequisites for the both approaches is to have new database JDBC Jar in the class path of the application server, and to update the pr Config XML with the respective DB database class name.
Please let me know, if anything need to be considered.
Thanks
Sandeep P V