Viewing and applying schema changes

Review the list of schema changes to determine whether to proceed with the import and either automatically apply the schema changes, or download a SQL DDL script that defines the changes and manually apply the DDL to the database.

Before you begin: 
  • Before starting, you must complete this task: Setting advanced mode and reviewing the archive contents
  • To automatically upgrade the application schema, your access group must have the SchemaImport privilege and the dynamic system setting database/AutoDBSchemaChanges must be true. Otherwise, you can create a DDL file to apply manually.
Note: You see this screen only if your archive includes schema changes.
  1. Click the class name to review the schema changes.
    Note: The table names displayed here may be shortened to accommodate database vendor name-length limits.
  2. Optional: If you did not configure the system to automatically apply the DDL, or if there is an error in your DDL, you see the View/Download SQL DDL button. Create a DDL file for your database administrator to apply manually:
    1. Click View/Download SQL DDL to create a DDL file.
    2. Give the DDL file to your database administrator to apply to the database.
    3. Continue the import after the database administrator applies the DDL file.
  3. Click Next to continue the import.
What to do next: If there are errors in the schema changes, the system displays an error page. Click Total errors to display the log.