Converting SQL code in C++ applications with AWS Schema Conversion Tool

Create a database conversion project, and add a source Oracle database. For more information, see Starting and managing Projects in AWS SCT and Adding servers to project in AWS SCT.

Add a mapping rule that includes your source Oracle database and a target PostgreSQL database. You can add a target PostgreSQL database or use a virtual PostgreSQL target database platform in a mapping rule. For more information, see Mapping data types in the AWS Schema Conversion Tool and Mapping to virtual targets in the AWS Schema Conversion Tool.

On the View menu, choose Main view.

On the Applications menu, choose New C++ application.

The Creating a C++ application conversion project dialog box appears.

For Name, enter a name for your C++ application conversion project. Because each database schema conversion project can have one or more child application conversion projects, choose a name that makes sense if you add multiple projects.

For Location, enter the location of the source code for your application.

In the source tree, choose the schema that your application uses. Make sure that this schema is part of a mapping rule. AWS SCT highlights the schemas that are part of a mapping rule in bold.

Choose OK to create your C++ application conversion project.

Find your C++ application conversion project in the Applications node in the left panel.

Expand the C++ node under Applications in the left panel, and choose the application to convert.

In the Source Oracle application project, choose Settings. Review and edit the conversion settings for the selected C++ application. You can also specify the conversion settings for all C++ applications that you added to your AWS SCT project. For more information, see Managing C++ application conversion projects.

For Compiler type, choose the compiler that you use for the source code of your C++ application. AWS SCT supports the following C++ compilers: Microsoft Visual C++, GCC, the GNU Compiler Collection, and Clang. The default option is Microsoft Visual C++.

For User-defined macros, enter the path to the file that includes user-defined macros from your C++ project. Make sure that this file has the following structure: #define name value. In the preceding example, value is an optional parameter. The default value for this optional parameter is 1.

To create this file, open your project in Microsoft Visual Studio, and then choose Project, Properties, C/C++, and Preprocessor. For Preprocessor definitions, choose Edit and copy names and values to a new text file. Then, for each string in the file, add the following prefix: #define .

For External include directories, enter the paths to the folders that include external libraries that you use in your C++ project.

In the left pane, choose the application to convert, and open the context (right-click) menu.

Choose Convert. AWS SCT analyzes your source code files, determines the application logic, and loads code metadata into the project. This code metadata includes C++ classes, objects, methods, global variables, interfaces, and so on.

In the target database panel, AWS SCT creates the similar folders structure to your source application project. Here you can review the converted application code, as shown following.

Save your converted application code. For more information, see Saving your converted application code.

Expand the C++ node under Applications in the target database panel.

Choose your converted application, and choose Save.

Enter the path to the folder to save the converted application code, and choose Select folder.

Expand the Applications node in the left panel.

Choose the C++ node, and open the context (right-click) menu.

Choose New application.

Enter the information that is required to create a new C++ application conversion project. For more information, see Creating C++ application conversion projects.

On the Settings menu, choose Project settings, and then choose Application conversion.

For Compiler type, choose the compiler that you use for the source code of your C++ application. AWS SCT supports the following C++ compilers: Microsoft Visual C++, GCC, the GNU Compiler Collection, and Clang . The default option is Microsoft Visual C++.

For User-defined macros, enter the path to the file that includes user-defined macros from your C++ project. Make sure that this file has the following structure: #define name value. In the preceding example, value is an optional parameter. The default value for this optional parameter is 1.

To create this file, open your project in Microsoft Visual Studio, and then choose Project, Properties, C/C++, and Preprocessor. For Preprocessor definitions, choose Edit and copy names and values to a new text file. Then, for each string in the file, add the following prefix: #define .

For External include directories, enter the paths to the folders that include external libraries that you use in your C++ project.

Choose OK to save the project settings and close the window.

Expand the C++ node under Applications in the left panel.

Choose the application to update, and open the context (right-click) menu.

Choose Refresh and then choose Yes.

AWS SCT uploads your application code from the source files and removes conversion results. To keep code changes that you made in AWS SCT and the conversion results, create a new C++ conversion project.

Also, AWS SCT removes the application conversion settings that you specified for the selected application. After you upload the updated application code, AWS SCT applies the default values from the project settings.

Expand the C++ node under Applications in the left panel.

Choose the application to remove, and open the context (right-click) menu.

Choose Delete and then choose OK.

Expand the C++ node under Applications in the left panel.

Choose the application to convert, and open the context (right-click) menu.

Choose Convert.

On the View menu, choose Assessment report view.

View the Summary tab.

The Summary tab displays the executive summary information from the C++ application assessment report. It shows conversion results for all SQL execution points and all source code files.

Choose Save statements to JSON to save the extracted SQL code from your Java application as a JSON file.

(Optional) Save a local copy of the report as either a PDF file or a comma-separated values (CSV) file: