Conversion tool

The Conversion tool enables you to automatically convert your original DB2 SQL statements to Microsoft Transact-SQL (T-SQL) statements before migrating the code to SQL Server. Use the Conversion tool when the information reported by the Assess Application Migration tool shows the Convert code migration scenario to be the most favorable for your application.

The Conversion tool offers the following options with regard to generating and saving converted source files. You can choose one of the following:

Generate the converted code without saving converted source files.
Generate the converted code and save the converted source files in the same directory as the original source files. In this case, the Conversion tool renames the original source files by appending a specified file extension to the filename of each original source file. The converted source files use the filenames of the original source files.
Generate the converted code and save the converted source files in a directory other than the directory that contains the original source files. In this case, you specify the directory for storing converted source files.

You also have two options as to how you want the Conversion tool to alter the original source code. You can choose either of the following:

Keep the original DB2 SQL statements intact as comments in the code, with the converted T-SQL statement replacing the DB2 SQL statements.
Keep the original DB2 SQL statements intact in the source code, and add the converted T-SQL statements as well. In this case, you can compile the code conditionally. To compile with DB2 SQL statements, specify the CONSTANT compiler directive as follows:
```
CONSTANT"UseDB2"
```
To compile with converted T-SQL, do not specify the CONSTANT compiler directive (default).

Finally, you have two options with regard to the generation of comments in the converted code. You can choose either of the following:

Embed a comment for each DB2 SQL statement that you must fix or that are in doubt.
Embed a comment for each DB2 SQL statement encountered, regardless of its status. This option could be useful both for diagnostic purposes and to assist you in becoming familiar with the decision-making logic inherent in the Conversion tool.

After converting your code, you can view the individual converted statements from the SQL Conversion tab by double-clicking a file name listed on the Results tab.

Once you have a set of converted source files, add the converted source files to your Visual Studio project before building your application.