Skip to main content


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

Generating a DDL file for command-line database schema extractions

Updated on April 6, 2022

For Database Schema extractions, generate a DDL file to share with your database administrator (DBA) so that they can format the external database table for extractions.

This content only applies to on-premises systems and is not supported in Pega Cloud environments.
  1. From the command line, begin the Java method with an initial Java call of com.pega.pegarules.data.internal.access.ExtractImp.
  2. Append the file path in which to create the DDL file and the DDL file name with the parameter and argument -x <filepath><DDL filename>.
    For example:
    com.pega.pegarules.pub.PegaRULES com.pega.pegarules.data.internal.access.ExtractImpl -I ./XMLpath External_XML
  3. Provide your DBA with the DDL file and ensure that your DBA formats the target database by using the DDL file.
  4. Return to Running a BIX command-line extraction in on-premises systems to perform a BIX extraction process from the command for Database Schema extract file formats.
  • Previous topic Running a BIX command-line extraction in on-premises systems
  • Next topic Running a BIX command-line extraction using ANT build files in on-premises systems

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.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us