Before any tables can be mapped from source to target, the source and target database must be specified along with the DataServer schema holder database and the ODBC Data Source.
Note: Auto mapping requires selection of one or more source tables and manual mapping requires a 1:1 linking (single source table or field to a single target table or field).


The Source Table box is used to designate what data is to be mapped to the target database. It also populates the Source Tables and Target Tables boxes with the appropriate unmapped tables.

The Source Table/Target Table Viewers selection boxes contain the table names of those tables in the selected databases (determined by the previous control) that are not already included in the mapping table.

The Map Tables button takes the selected table from the Source Tables box and the selected table from the Target Tables box and creates a Table mapping record for them. Additionally, you are not required to map the entire table, only the fields that you want to replicate.

The Unmap Tables button takes the selected table from the Source Tables box and the selected table from the Target Tables box and creates a Table Cross-Reference record for them.

Use the Automap feature to auto-map source database tables to target database tables. You can select multiple tables within the Source Tables box and the application automatically maps those tables with matching target tables. Pro2 continues to create Field Cross-Reference records for any matching fields of those tables. This is possible for only tables and fields that have a direct matching table name or field name in the corresponding target.

Once you have mapped the required tables, click Next to access the Advanced Configuration window.