Preparing to update sample data
If you are updating to Pega Foundation for Financial Services 8.7 from release 7.21.1, 7.22, 7.31, 7.32, 7.4, 8.1, 8.2, 8.3, 8.4, 8.5 and plan to update the sample data after updating the application, drop the sample and snapshot tables before importing the application.
Pega Foundation for Financial Services
Update Guide
- With
Pega Foundation for Financial Services running on your application server, use the appropriate database
tool to connect to the database, and then run the SQL script files that are appropriate for your
database platform and schema.The
\ResourceKit\UpgradeScripts\PFFS\directory on the distribution image contains several subdirectories that are specific to each supported database platform. The drop sample and snapshot table scripts are organized in the following structure:\DB2LUW\…Drop_FSIF_Sample_Tables_DB2LUW_SingleSchema.sqlDrop_FSIF_Sample_Tables_DB2LUW_SplitSchema.sqlDrop_FSIF_Snap_Tables_DB2LUW_SingleSchema.sqlDrop_FSIF_Snap_Tables_DB2LUW_SplitSchema.sql
\DB2zOS\…Drop_FSIF_Sample_Tables_DB2_zOS_SingleSchema.sqlDrop_FSIF_Sample_Tables_DB2_zOS_SplitSchema.sqlDrop_FSIF_Snap_Tables_DB2_zOS_SingleSchema.sqlDrop_FSIF_Snap_Tables_DB2_zOS_SplitSchema.sql
\MS-SQL\…Drop_FSIF_Sample_Tables_MS-SQL_SingleSchema.sqlDrop_FSIF_Sample_Tables_MS-SQL_SplitSchema.sqlDrop_FSIF_Snap_Tables_MS-SQL_SingleSchema.sqlDrop_FSIF_Snap_Tables_MS-SQL_SplitSchema.sql
\Oracle\…Drop_FSIF_Sample_Tables_Oracle_SingleSchema.sqlDrop_FSIF_Sample_Tables_Oracle_SplitSchema.sqlDrop_FSIF_Snap_Tables_Oracle_SingleSchema.sqlDrop_FSIF_Snap_Tables_Oracle_SplitSchema.sql
\PostgreSQL\…Drop_FSIF_Sample_Tables_PostgreSQL_SingleSchema.sqlDrop_FSIF_Sample_Tables_PostgreSQL_SplitSchema.sqlDrop_FSIF_Snap_Tables_PostGreSql_SingleSchema.sqlDrop_FSIF_Snap_Tables_PostGreSql_SplitSchema.sql
Previous topic Updating the application Next topic Importing the application