Bring Your Oracle and Netezza Apps to dashDB with Database Conversion Workbench (DCW)
Whether you’re just starting your journey to the cloud or already heavily invested in a cloud strategy, chances are you’re facing a lot of questions around compatibility. For example, “will my new cloud services allow me to continue leveraging my legacy applications and databases?”
To help overcome the compatibility hurdle when migrating relational databases to the cloud, IBM offers a free tool – Database Conversion Workbench (DCW) . DCW is a no-charge plug-in for IBM Data Studio, which makes it easier to migrate your database from an on-premises relational database management system (RDBMS) to the IBM dashDB cloud data warehouse as well as to DB2 on Cloud.
The two primary ground-to-cloud migration paths supported by DCW are:
- Moving Oracle databases to IBM dashDB and DB2 on Cloud.
- IBM PureData for Analytics (formerly Netezza)
Regardless of the migration path you’re taking, DCW will support you in the three main phases of database conversion: 1) DDL Extraction; 2) Assessment and conversion; and 3) Data movement. DCW’s series of wizards and interactive help topics will guide you through each phase, with all necessary functions accessible through the graphical user interface.
Since converting databases from one vendor to another can be both difficult and time consuming, DCW makes it easier by providing an integrated help guide with step-by-step instructions for each stage of the migration. DCW features include:
- 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.
- 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.
- Code Conversion. Automatically converts the source database SQL to the target database’s compatible syntax.
The following table lists all features provided by DCW for the different migration paths:
|FEATURES||PUREDATA FOR ANALYTICS (NETEZZA)
DB2 on Cloud
|Compatibility Evaluation Report||X||X||X|
|Data Extraction (flat files)||X||X|
|Object Dependencies Visualizer||X||X|
To start using DCW to smooth your transition to the cloud, you’ll first need to have IBM Data Studio installed on the system you’ll be using to manage your database migration. Data Studio is available for Windows, Linux and UNIX operating systems, and can be downloaded at no cost here.
Below is a list of resources that can help as you make your journey from ground to cloud.
- Download Data Studio: http://www.ibm.com/developerworks/downloads/im/data/
- DCW plugin: http://www.ibm.com/services/forms/preLogin.do?source=swg-idcw
- Convert IBM Pure data for Analytics to dashDB (Video and PDF)
- Convert data from Oracle to dashDB (video and PDF)
- Visit the DCW developerWorks Community for help topics, documentation, and more.
- See how Aginity Workbench for IBM dashDB works.
Need further assistance? Contact us at AskDCW@ca.ibm.com