About applying database definition language (DDL) statements after a Windows installation

When you install the Sterling Order Management System Software software, you can manually apply database definition language (DDL) statements to your database tables instead of requiring the installation process to do it directly. This enables you to apply DDL statements for database creation separately from the installation.

This feature increases database security by reducing the database permissions of the Foundation database user. The rights to create tables, indexes, etc. can be reserved for a secure user like a database administrator (DBA). A business can require that only a DBA with the proper permissions can make database changes.

If you choose to manually apply the DDL, the installation process will provide the location of the DDL scripts. The installation process will then continue the rest of the installation. The installation process may validate the database with the dbverify script and warn you if there are differences, but it will not exit. It will allow the processing of the packages to continue normally.

If you do not choose to manually apply the DDL, the installation will apply both the DDL and the resources.

During an interactive installation, you indicate whether or not you want to set up DDLs and run factory setup when selecting features. Select Enable Upgrade if you are upgrading from a previous release or if you are doing a new installation, but want to apply DDL manually after installation. Do not select this option if you are doing a new sharded database installation. If you are not upgrading and you select this option, you must manually create your database tables and load factory setup after the installation process. However, if you are upgrading, the DDLs are applied as part of the upgrade process.