The target database utilities are:
  • Target Schema: The Target Schema menu item generates the necessary database script to build a copy of the Progress schema within the target database server. You are prompted for an output file name and then asked for the source database from which you wish to prepare a database Schema. The resulting DB file can then be executed within an empty database container to build a target database with the same schema as the source OpenEdge database.
  • Target Differential: The Target Differential menu item generates the necessary queries to upgrade the current target schema to match to current source schema. Typically, this utility is used after a schema change to the source database. The resulting database file can then be used to upgrade the target schema to match the source schema.
    Note: When any change is made to the schema of the target database you must rebuild the schema holder database before Pro2 will see the changes to the target schema.
    Oracle specialization: Use the following properties to generate Oracle specific output:
    • ORACLE_USE_LOGICAL: To convert logical field to number (1)
    • ORACLE_USE_SCALE: To add precision and scale for decimal fields.
    By default, the value of these properties is set to NO. To use these properties, set the value to YES. For Oracle specific targets, use the following properties. These properties are responsible for Add support for precision and scale.
  • Linked Server SQL: Use this menu item to generate SQL scripts containing INSERT INTO statements to be able to execute on a Microsoft SQL Server database. This is a faster alternative to running bulk loads. If you choose this method, you must provide the name of a Linked Server in Microsoft SQL Server and also the name of an OpenEdge ODBC data source.