Generating a DDL file for command-line Database Schema extractions

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.

  1. Fro 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 to perform a BIX extraction process from the command for Database Schema extract file formats.