Use this window to select where the source database is replicated to. Because Pro2 replicates data to a database on your behalf, you must provide the user name, password, and other types of identifying information for the target database in the following fields.

Field name Description
Target Database Name This field indicates the name of the target database.
Target Database Type Use this field to designate what type of database your target database is.
Target Schema Image

The Target Schema Image is a generated SQL or Progress text file that, depending on the target database type, creates tables on the target database which mirror the source database.
Schema Holder Database

Schema holder is a separate Progress database that does not hold any data. However a schema is created by pulling the definitions from the target database. This enables mapping between the source and target database, even if the target is a SQL server or Oracle database.
Target Open Database Connectivity

The target ODBC connection is configured through the Windows ODBC setup tool. After it is defined in windows, parameters are added to a .pf file which enables a connection to the target database with the parameters that you define.
User Name The user name for the target database.
Password The password for the target database.


Click Next to move to the Generate Target Schema window.