Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

Preparing to update sample data

Updated on January 18, 2022

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.

Note: If you do not plan to update the sample data and database schema, you can skip this task.
Pega Foundation for Financial Services Update Guide
  1. 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.
    Note: If you have a split-schema installation of Pega Platform, but use non-default schema names, update all references to PEGADATA in the applicable script before you run it.
    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.sql
      • Drop_FSIF_Sample_Tables_DB2LUW_SplitSchema.sql
      • Drop_FSIF_Snap_Tables_DB2LUW_SingleSchema.sql
      • Drop_FSIF_Snap_Tables_DB2LUW_SplitSchema.sql
    • \DB2zOS\…
      • Drop_FSIF_Sample_Tables_DB2_zOS_SingleSchema.sql
      • Drop_FSIF_Sample_Tables_DB2_zOS_SplitSchema.sql
      • Drop_FSIF_Snap_Tables_DB2_zOS_SingleSchema.sql
      • Drop_FSIF_Snap_Tables_DB2_zOS_SplitSchema.sql
    • \MS-SQL\…
      • Drop_FSIF_Sample_Tables_MS-SQL_SingleSchema.sql
      • Drop_FSIF_Sample_Tables_MS-SQL_SplitSchema.sql
      • Drop_FSIF_Snap_Tables_MS-SQL_SingleSchema.sql
      • Drop_FSIF_Snap_Tables_MS-SQL_SplitSchema.sql
    • \Oracle\…
      • Drop_FSIF_Sample_Tables_Oracle_SingleSchema.sql
      • Drop_FSIF_Sample_Tables_Oracle_SplitSchema.sql
      • Drop_FSIF_Snap_Tables_Oracle_SingleSchema.sql
      • Drop_FSIF_Snap_Tables_Oracle_SplitSchema.sql
    • \PostgreSQL\…
      • Drop_FSIF_Sample_Tables_PostgreSQL_SingleSchema.sql
      • Drop_FSIF_Sample_Tables_PostgreSQL_SplitSchema.sql
      • Drop_FSIF_Snap_Tables_PostGreSql_SingleSchema.sql
      • Drop_FSIF_Snap_Tables_PostGreSql_SplitSchema.sql

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us