Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Wayne Smith (Wayne Smith)
PEGA
Senior Solutions Consultant
Pegasystems Inc.
US
Wayne Smith Member since 2017 1 post
PEGA
Posted: Oct 10, 2018
Last activity: Oct 25, 2018
Posted: 10 Oct 2018 10:18 EDT
Last activity: 25 Oct 2018 17:00 EDT
Closed

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.

To see attachments, please log in.
Data Integration

Posted: 6 years ago
Posted: 25 Oct 2018 16:44 EDT
Nick Loving (NickLoving_GCS)
PEGA
Senior Principal Engineer, Technical Support
Pegasystems Inc.
US

Is there something specific you're looking for information on? It's fairly common for the generateDDL script to be used as part of an upgrade. Database backups could also be used in case of issues during the upgrade.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice