Migrating data warehouse projects and OLAP metadata

Migrating data warehouse projects and OLAP metadata

You can migrate data warehouse projects and OLAP metadata from within the Design Studio by using the InfoSphere Warehouse Migration wizard.

Before you begin

Ensure that:

• You installed the Design Studio, migration tool plug-ins, and the SQL Warehousing Tool plug-ins of InfoSphere Warehouse.
• The common repository database is created on the DB2^® V9.5 database server.
• The projects to be migrated are from DB2 Data Warehouse Edition V9.1.x.

About this task

You can migrate the following components by using the InfoSphere Warehouse Migration wizard:

• Data warehouse projects (SQW and mining flows)
• OLAP metadata in databases

You can migrate one component at a time or both of the components together. In addition, you can run the wizard multiple times on different data warehouse projects. For example, if you have 100 data warehouse projects to migrate, you can choose to migrate 50 projects in the first run, and then run the migration wizard again to migrate the remaining 50 projects. You don't need to migrate all of the projects at the same time.

Remember: Do not run the Migration wizard more than once to migrate the OLAP metadata in databases, if the metadata was migrated successfully in the first run. You will receive an error when you run the Migration wizard again to migrate the metadata. However, if the first run fails, then the Migration wizard rolls back the migration process and you can run the wizard again.

Procedure
To migrate data warehouse projects and OLAP metadata:

1. Start the InfoSphere Warehouse Design Studio by using a new workspace. You will use this workspace for migration purposes only.
2. In the Database Explorer view, create a connection to:
   • The database that you will use to migrate the OLAP metadata from.
   • The databases that are used in the data warehouse projects.
3. From the main menu, click Data Warehousing > InfoSphere Warehouse Migration. The Migration wizard opens.
4. In the Component Selection page, perform these steps:
   1. Select the components to migrate.
   2. Specify the location to save the migration log. By default, a MigrationLog.txt file is created in your current workspace directory.
   3. Click Next.
5. To migrate data warehouse projects:
   1. In the Project Selection page, click Add. The Project Selection window opens.
   2. In the Source directory field, click the ellipsis (...) button and browse to the directory that contains the data warehouse projects to be migrated. This can be any directory where the projects are stored. It need not be a genuine Eclipse workspace directory. Ensure that you have read permission on this directory. The list of projects that are stored in the selected directory is displayed in the Select Projects area.
      Note: The directories must be real local file system directories. If the projects are stored in a version control system, such as CVS, ClearCase^®, and so on, you must first check out the files and copy them to the local file system. Then, after the running the Migration wizard, check in the migrated files to the version control systems, if needed.
   3. In the Select projects area, select one or more data warehouse projects to migrate. By default, the wizard selects all the projects in the workspace for migration.
   4. In the Destination directory field, click the ellipsis (...) button and browse to a location on your local computer where you want to store the migrated project. By default, the destination directory is the same as the source directory but with a _95 suffix added to it. Ensure that you have write permission on this directory. For example, if the name of the source directory is v912DWHProjects, then the default name of the destination directory is v912DWHProjects_95.
      Note: If the name of the destination directory is the same as the source directory, then the old data warehouse projects are overwritten, and you can immediately use the migrated projects without importing the migrated projects into the workspace.
   5. Click OK. The source and destination directories are displayed on the Project Selection page.
6. To migrate OLAP metadata:
   1. Select the databases that are to be used for migration.
   2. Optional: If you did not create a connection for the databases, click New Connection and enter the database details to create a connection. Click Next.
   3. Specify the connection information for the common repository database that you created during the InfoSphere Warehouse installation. Test the repository connection.
7. Click Finish. Based on your selection for migration, the data warehouse projects or OLAP metadata is migrated. The data warehouse projects are migrated to the destination directory, and the OLAP metadata is migrated to the common repository database. A Migration Log window opens and displays the migration summary.

After a successful migration, the old data warehouse projects in V9.1.x are not modified, unless you select the destination directory that is the same as the source directory. The existing OLAP metadata is dropped from the database.

• Example–Migrating OLAP metadata
  In this example, you use the Migration wizard to migrate the OLAP metadata from the CVSAMPLE database to the DWECTRL common repository database.