Welcome to the CASTDB2ManifesttoDDL wiki!

Introduction

Use this extension to convert DB2 Manifest files to single DDL file.

Content

Installation instructions Install like any other extension.

Usage:

1. Create a new folder in you local and Copy all the files of CASTDB2ManifesttoDDL folder from the extension folder.
2. Copy the DB2 Manifest folder to the new folder.
3. Create a new OUT folder.
4. Open Windows PowerShell Command Prompt
5. CD new folder.
6. Run the conversion tool with the following commands.

.\Create_DDL_from_Manifest.ps1 folder OUT

What results can you expect?

In the OUT folder, a new Processed.sql will be created.

Note: This tool is NOT alternative for DDL to be requested from customer for actual application analysis. Use this only in case when Database DDL compatible with SQL Analyzer is not available. May be for POC, AIP Migration Testing etc.