After you convert your source SQL Server database objects, you can review the conversion statistics. DMS Schema Conversion converts most of the database objects, but some of the objects require manual conversion.
DMS Schema Conversion displays the objects that require manual conversion in the Action items tab. To convert these objects, you can save the converted code as a SQL script. Then you can edit it using your code editor and apply these scripts to your target database. Alternatively, you can apply the converted code as is to your target database and make the edits later.
To save the converted code as a SQL script
-
In the target database pane, choose the converted database schema.
-
Select the check box for the name of this schema. DMS Schema Conversion highlights the schema name in blue and activates the Actions menu.
-
For Actions, choose Save as SQL. The Save dialog box appears.
-
Choose Save as SQL to confirm your choice.
-
Choose S3 bucket. The Amazon S3 console opens.
-
Choose Download to save your SQL scripts.
To apply the converted code to your target database
-
In the target database pane, choose the converted database schema.
-
Select the check box for the name of this schema. DMS Schema Conversion highlights the schema name in blue and activates the Actions menu.
-
For Actions, choose Apply changes. The Apply changes dialog box appears.
-
Choose Apply to confirm your choice.
Now you have successfully converted your source SQL Server database schemas to PostgreSQL. To complete the database migration, move your data and connect your applications to the new database.
