Specify details of the Enterprise Application 3.x database you are migrating from.

Source DB Type

This field displays the tab that is selected.

Source Machine

Enter the data source for an Enterprise Application MS SQL/Oracle database. If you are using the default instance, then local/localhost can be entered. You can specify a different named instance if you have one setup. The named instance could point to another machine, but that is dependent on SQL Server/Oracle's internal network support, rather than the EAE Data Migration Wizard.

Database

Enter the database (catalog) for an MS SQL database/Oracle database.

User Name

Enter a user name that has sufficient privileges to read the source database. The user account should be one that can connect to the database server using database authentication.

Password

Enter the corresponding password for the user name entered.

Schema and Logical DB

Enter the Schema, and Logical DB. The Schema is the 'owner' of the system application tables. If you look in Enterprise Manager, you see the 'owner' of the SAMPLE tables is dbo.

The Logical DB is the table prefix used in the Enterprise Application Environment 3.3 tables. Examine the SAMPLE tables in Enterprise Manager, and you will notice the tables are prefixed with 'SAMPLE'. For example, SAMPLE_PROD and SAMPLE_PAUDT. You would enter SAMPLE for the Logical DB field in this case.

Schema and Logical DB are derived from a table's name in the source database. For example, if the table name is LINC.DD_CUSTOMER, then Schema is "LINC", and the Logical DB is "DD."