An operation to generate SQL scrip to migrate a PeopleSoft project. Provides option to execute the generated SQL file. This operation can be used in Deploy workflow after copying the project definitions from file to target environment. 

In your PeopleSoft Application Designer, you create several kinds of definitions that represent database components. For instance, field definitions represent table columns, and record definitions represent tables and views. From these field and record definitions, you can create tables, views, and indexes. The important concept to remember is that the definitions are just the blueprints for the actual, physical database components with which they are associated. In the context of the entire application development cycle, use this operation (BuildProject) to build the underlying SQL tables that house the application data.   It generates the SQL file with following as needed for the project :

• Tables.

• Indexes.

• Views.

• Triggers.

You can also use the Build feature to alter existing tables if you change the record definition after the table already exists. Altering a table is useful, because it enables you to make changes without losing the application data that is already housed in the table. In general, the results of the build operation are written to a script file and can easily run with "Execute SQL" input. 

Environment/Instance Properties

...