Creating and Configuring the Migration Database
Use the instructions in the CloudSuite Industrial product installation guide to create an initialized CloudSuite Industrial database. This database will be used to import the external application data into the source tables and to transform and store the data in the target tables.
The Migration Utility is installed like any industry pack. For more information about installation, use the instructions in the Installation Guide to install the Migration Utility industry pack on that database. This pack includes the forms and stored procedures that you need for the migration.
Use the Import Parameters form to specify connection information between the external application database and the migration database.
See Specifying Import Parameters.
If the migration database is created in a separate SQL server from the external application database, the migration database must be able to connect to the external application database server. Connectivity between the servers is tested in the Import Parameters form when you save the connection information. You can click the button to test this. If different servers are involved, the migration utility creates a linked server when you save the parameter settings.
The CloudSuite Industrial migration database and the final target database both support copying the data from multiple sites into a single database. This is not required; if multiple sites exist in separate databases in the external application, they can remain as separate CloudSuite Industrial databases.
You can set up a migration database server on which you create one or more migration databases, and then create an associated migration configuration for each site that you will migrate from an external application to CloudSuite Industrial.
If the table mappings are the same for all sites, you could use one migration database for all migrating sites. This eliminates the need to copy table mappings from one migration database to another migration database for each migrating site. You would just copy the site with the transferred data in the migration database into the target CloudSuite Industrial databases.