Question
Pegasystems Inc.
US
Last activity: 25 Oct 2018 17:00 EDT
Need best practices on the use of DDL Generation on SQL DB objects for Pega 7.4 DB update
I have a customer who is seeking best practices information and feedback from the technical community regarding the use of DDL Generation to create, modify, and remove SQL database objects such as tables, indexes and users on migrateSystem and setupDatbase properties scripts provided by Pega for a 7.4 database update.
The customer's DB2 team and DBA's also highly recommended generating DDL scripts to keep a snapshot of the database structure in their production environment.