Convert your source code in DMS Schema Conversion - AWS Database Migration Service

Convert your source code in DMS Schema Conversion

You can convert your source database schema using the following procedure. Then you can save the converted code as SQL scripts in a text file.

To convert your database schema

  1. In the source database pane, choose the database schema to convert. Also, select the check box for the name of this schema.

  2. In the source database pane, choose Convert in the Actions menu. The Convert dialog box appears.

  3. Choose Convert in the dialog box to confirm your choice.

  4. Choose a database object in the source database pane. DMS Schema Conversion displays the source code and the converted code for this object. You can edit the converted SQL code for a database object using the Edit SQL feature. For more information, see Editing and saving your converted SQL code .

  5. In the target database pane, choose the converted database schema. Also, select the check box for the name of this schema.

  6. For Actions, choose Save as SQL. The Save dialog box appears.

  7. Choose Save as SQL to confirm your choice.

  8. Choose S3 bucket. The Amazon S3 console opens.

  9. Choose Download to save your SQL scripts.