Migrating your schema

When you migrate to IAS, you may need to use a Data Definition Language (DDL) file to help convert your schema to be compatible with the IAS warehouse. Depending on your source, there are a number of tools and methods available to help you convert your schema.

What is a schema?

Integrated Analytics System uses a single database named BLUDB. Other systems might use more than one database, or have different rules for how data integrity is preserved. These rules and configurations can be collectively called the schema, and this database schema can be defined in a Data Definition Language file, or DDL.

IBM Database Harmony Profiler (Oracle or IBM PureData® System for Analytics databases)

The Database Harmony Profiler provides functions to help you evaluate and convert your schema for use in IAS. Depending on the source database, the system can suggest the appropriate migration path. The Database Harmony Profiler is a lite version of the Database Conversion Workbench (DCW), and can be downloaded from the same site.

A typical conversion of your schema consists of:
  1. extracting the DDL from your source database and generating a compatibility evaluation report.
  2. automatically converting the extracted DDL to compatible syntax for IAS.
  3. allowing you to manually fix any additional incompatible syntax based on the evaluation report.
  4. executing the converted DDL to recreate the database schema.

db_migrate command (for IBM PureData System for Analytics databases)

The db_migrate command is a tool provided with the Db2 Support Tools package. db_migrate can be used specifically for migrating PureData® System for Analytics (Netezza) systems to IAS.