Related TopicsThe DDL (Data Definition Language) Converter tool is one of the core functionalities of the DB2 to SQL Server Migration toolset. It is a tool used to read-in an XML representation of a DB2 database (created by the Schema Extractor tool and filtered by Transfer List Manager tool ) and translate the database structure into a SQL Server 2008 DDL script. Schemas, tables, views, indexes, constraints, and relational information are captured from the XML, and DDL is produced that takes into account dependencies for command ordering.
The log file contains notes/suggestions where potential DB2 to SQL Server database formats have differences, and possible workarounds. Each stage of operation is logged including reading the data mapping definitions, reading the database structure, and detailed processing information for every object. The log also includes a summary section that show totals of objects created. If problems are encountered during processing, those are also logged.