Step 6: Convert Database Schemas
After you create a new AWS SCT project, convert your source database schemas and apply converted code to your target database.
-
In the tree in the left panel, choose your source dataset. Open the context (right-click) menu, and choose Convert schema.
-
Choose Yes for the confirmation message. AWS SCT then converts your schema to the target database format.
-
AWS SCT also generates the assessment report. This report includes database objects that require manual conversion. To view this report, choose View, and then choose Assessment report view.
-
On the Action items tab, AWS SCT provides you with the recommended actions for each conversion issue.
-
Check the report and make changes in your source or converted code where necessary. You can optionally save the report as a .CSV or .PDF file for later analysis.
-
Choose Action Items, and review any recommendations that you see.
-
In the tree in the right panel, choose the converted schema. Open the context (right-click) menu, and choose Apply to database to apply the schema scripts to the target Amazon Redshift cluster.
