Specify details of the Agile Business Suite database you are migrating to.

Target DB Type

This field displays the tab that is selected.

Data Source

Enter the data source for an Agile Business Suite MS SQL database. If you are using the default instance, then (local) 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 internal network support, rather than the EAE Data Migration Wizard.

Database

Enter the database (catalog) for an MS SQL database; this is the deployed but empty Agile Business Suite application.

Schema

The Schema here also refers to the owner. Once again, if you look in Enterprise Manager, you see the owner of the SAMPLE tables in Agile Business Suite is actually SAMPLE, not dbo. This is because the table names are no longer prefixed by the schema name. So you would enter SAMPLE in this field.

Schema is derived from a table's name in the source database. For example, if the table name is LINC.DD_CUSTOMER, then Schema is LINC.