4 Migrating the Product Catalog

This chapter describes how to migrate information with Oracle Communications MetaSolv Solution Data Selection Tool (DST) Product Catalog module.

About the Product Catalog Migration

The DST Product Catalog module migrates the following information related to selected products:

  • Product specification items

  • Product specification hierarchy

  • Product catalog items

  • Product hierarchy

  • Product specification value labels and valid values

  • Extended items

  • Default items and values

The DST Product Catalog module does not migrate any of the following information:

  • Find and relate service types to products

  • Find and relate service categories to products

  • Find and relate auth code to product specifications

  • Migrate pricing

  • Migrate product availability (by switch and NPA/NXX)

  • Migrate pricing availability

  • Relate prod groups (CPNI)

  • Migrate/relate item equipment specs

Migrating the Product Catalog

To migrate the product catalog:

  1. Open the Data Selection Tool.

  2. Click the Prod Cat button.

    If the Source list is empty, your source database does not contain any products.

  3. Click the Targ Logon button to select the target database. The target database is the one you want to copy products to.

    The Environment Login window is displayed.

  4. In the Userid field, enter your user name.

  5. In the Password field, enter your password.

  6. In the Database field, enter the database server name.

  7. Click OK.

    Note:

    Your database access is limited to accessible databases in your .TNS names files and your .INI files.

    After you connect to your target database, the Target list is populated with the product specs in the target database.

    Note:

    If you click the Pick Prod(s) button before you choose a target database, an error message is displayed. Click OK and then click the Targ Logon button.
  8. Click the Pick Prod(s) button.

    The Migrate Products window is displayed.

    The Remaining Products list displays available products that you can migrate from the source database to the target database.

    The Established Products list displays the selected products that are migrated to the target database.

  9. Select the product(s) you want to migrate by moving them from the Remaining Products list to the Established Products list. Use the directional single arrow buttons or double arrow buttons to move products between the Remaining Products list and the Established Products list.

  10. For each product in the Established Products list, select a service category from the list.

  11. Click OK to migrate the products listed in the Established Products list to the target database.

    The Migrating Products meter is displayed that shows the progress of migrating the selected products.

    If one of the selected products already exists in the target database, a message is displayed that allows you to choose whether to continue migrating that product. The progress meter shows which product is duplicate. Click OK to expire the current product and insert the new product. Click Cancel to skip the migration of this product.

  12. Review the Product Migration Log to ensure that selected products migrated successfully.

    Note:

    If you do not select a service category, a warning message is displayed in the Product Migration Log. The warning message does not stop the migration of the product, but the product in the target database will not have a service category.

Post-Migration Tasks

After the migration process is completed, you must do the following post-migration tasks:

  • If the migrated product uses a product specification with an authorization code, log in to MetaSolv Solution (Product Specification window) and select an authorization code for the product.

  • If the migrated product has product groupings (CPNI), log in to MetaSolv Solution (Product Catalog window) and select a product grouping for the product.

  • If the migrated product specification is associated with a product catalog equipment specification, log in to MetaSolv Solution and create this association for the product.