Db2

NOTE: DCW Lite is renamed to IBM Database Harmony Profiler.

There is a new kid in the block that many will find a welcome addition to the DCW family. It is called IBM Database Harmony Profiler because that is exactly what it is supposed to be: a lightweight, standalone version of DCW.  It focuses on DCW’s two core functions: converting SQL and assessing the compatibility level of Oracle and PureData System for Analytics (Netezza) applications with dashDB or DB2 on Cloud.

More often than not, you only need a quick and easy way to evaluate the compatibility of your application. Maybe because you are not committed yet to performing the migration, or just exploring your options. Either way, you care about evaluating and/or converting your SQL files, but not the other (more advanced) functions in the full DCW environment. Database Harmony Profiler comes in to fill this gap.

Highlights of Database Harmony Profiler

• Lightweight: 15MB ZIP file download
• Easy to install: Unzip it and run on Windows, Linux or Mac (Java 7 or higher required)
• Easy to use: Select your SQL file(s) and choose to evaluate or convert the SQL
• Auto-update: Database Harmony is always in sync with the latest capabilities in dashDB and DB2 on Cloud
• Flexible: provides both graphical and command line modes

How to Install

1. Download it from the download site as the full version.
2. Extract the contents of the ZIP file into any folder.

Note: make sure to read the README_FIRST.txt file included in the ZIP if you have any problems installing or running the tool.

How It Works

1. Double-click the start-up script (Windows: db_harmony_profiler.bat, Mac: db_harmony_mac) or run it from the command line (Linux: db_harmony_profiler.sh). 

The Database Harmony window will open

2. Click the Select Input Files button and select one or more .sql files

3. Select the Source and Target database types

4. Click Check Compatibility or Convert SQL

5. The output for each SQL file is displayed at the bottom list.

6. Double-click on the list or click Double-click to open the report to see the HTML Compatibility Report or the Converted SQL Code

Database Harmony Profiler can also be used from the command line. This is useful when you don’t have access to a graphical mode, or you want to automate the use of DCW through scripts.

To do so, open a terminal window and execute the Database Harmony Profiler start-up script with the parameter "help". E.g. "db_harmony_profiler.bat help".

You should see a list of all the commands accepted by the tool.

For instance, the following command would convert an Oracle SQL file called “oradb.tsql” to dashDB.

db_harmony_profiler.bat convert 4 c:\dev\oratb.sql

What’s Next?

You can expect more news for both DCW versions in the coming months.

Feel free to send your comments, suggestions and questions to askdcw@ca.ibm.com.