Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

DCW Features and Migration Paths

By Jordan Hodges posted Wed January 15, 2020 04:56 PM

  

The Database Conversion Workbench 4.0 allows you to convert Oracle and PureData System for Analytics (Netezza) to IBM Db2 Warehouse and Db2 databases.
The following table lists all the features provided by DCW for all the migration paths:

FEATURES

PureData System for Analytics

to

IBM Db2 Warehouse

Oracle

to

IBM Db2 Warehouse, Db2 on Cloud

Oracle

to

Db2 (11.1, 10.5, 10.1, 11.1 with BLU,  10.5 with BLU)

Starter Guide (Cheat Sheets) X X X

DDL Extraction

X X X

Compatibility Evaluation Report

X X X
Code Conversion X X X
Split DDL   X X
Data Extraction (flat files)   X X
Data Load (flat files)     X
Data Transfer (pipes)     X
Data Transfer (federation)     X*
Object Dependencies Visualizer   X X

* Leverages Db2 federation capabilities. The target Db2 database must support federation to the source database

 

DCW offers a variety of tools that can be used together through all the steps of a database conversion, separately based on user preference and need.

  1. Starter Guide - A help which provides step by step instructions through the conversion process.
  2. DDL Extraction - Extracts objects from the source database. The DDL (Data Definition Language) extracted is used by DCW to analyze the source database and provide an estimate on compatibility and work effort.
  3. Compatibility Evaluation - Analyzes the source database SQL to create a report with the compatibility ratio with the target database. The report outlines the major issues, code that can be auto-converted, as well as code that must be fixed manually.
  4. Code Conversion - Automatically converts the source database SQL to the target database's compatible syntax. 
  5. Split DDL - DCW can convert a single DDL file into multiple files, organized by object types. This helps streamline the creation of objects on the target database by providing more intuitive code organization.
  6. Data Extraction (flat files) - Extracts data from the source database into CSV files.
  7. Data Load (flat files) - Loads data from CSV files into the target database.
  8. Data Transfer (pipes) - Transfer data directly from the source to the target database using pipes.
  9. Data Transfer (federation) - Transfer data directly from the source to the target database by leveraging Db2's federation capabilities.
  10. Object Dependencies Visualizer - Generates a dependency graph of objects in the source database.

#Db2
0 comments
32 views

Permalink