Step 8: Cut Over to Aurora MySQL - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Step 8: Cut Over to Aurora MySQL

To move connections from your Microsoft SQL Server database to your Amazon Aurora MySQL database, do the following:

  1. End all SQL Server database dependencies and activities, such as running scripts and client connections. Ensure that the SQL Server Agent service is stopped.

    The following query should return no results other than your connection:

    SELECT session_id, login_name from sys.dm_exec_sessions where session_id > 50;

  2. Kill any remaining sessions (other than your own).

    KILL session_id;

  3. Shut down the SQL Server service.

  4. Let the Amazon DMS task apply the final changes from the SQL Server database on the Amazon Aurora MySQL database.

  5. In the Amazon DMS console, stop the Amazon DMS task by choosing Stop for the task, and then confirming that you want to stop the task.