Migrating to an InfoSphere Warehouse instance that is installed on a different computer

Migrating to an InfoSphere Warehouse instance that is installed on a different computer

You can migrate from Data Warehouse Edition V9.1.x to InfoSphere Warehouse when these products are installed on two separate computers. Assume that you want to migrate a Data Warehouse Edition V9.1.x instance that is installed on computer A to an InfoSphere Warehouse instance that is installed on computer B.

Before you begin

1. Back up the metadata and scheduler databases on computer A.
2. Copy all of the data warehouse projects that you want to migrate to computer B.
3. Copy all of the deployed data warehousing applications from computer A to the same location on computer B.
   To deploy data warehousing applications, three directories are used:
   

   • Application home directory
   • Log directory
   • Working directory

   All the three directories must be created at exactly the same location on computer B. For example, if you have an application deployed on computer A at C:\application_dir\applicaton_1, then this directory becomes the application home directory. Assume that C:\log\ is the log directory, and C:\temp\working\ is the working directory. You must create these three directories on computer B, and copy all the files in these directories from computer A to computer B. Otherwise, the migrated application will not work. Note that each data warehouse application can have their own three directories. So, if you have 100 applications, there can be 300 different directories that you must copy to computer B. If some directories are not copied, you might see an error message in the migration log that indicates that certain files are missing during migration.

ProcedureTo complete the migration from computer A to computer B:

1. Restore the metadata and scheduler databases on computer B.
2. Migrate the WebSphere^® application profile. For detailed help on migrating the WebSphere application profile that is located on a separate computer, see the WebSphere Information Center.
3. Run the InfoSphere Warehouse Configuration Tool on computer B.
4. Specify the migration settings in the migration.properties file.
5. Run the migration script on computer B.