Inspect the Content of Target Database


If you disconnected from the Source EC2 instance, follow the instruction in Connect to the EC2 Instance section from the previous part to RDP to the instance.

  1. Open MySQL Workbench 8.0 CE from within the EC2 server, and click on Target Aurora RDS (MySQL) database connection that you created earlier.

  2. Inspect the migrated data, by querying one of the tables in the target database. For example, the following query should return a table with two rows:

SELECT *
FROM dms_sample_dbo.sport_type;

\[SqlDms16\]

Baseball, and football are the only two sports that are currently listed in this table. In the next section you will insert several new records to the source database with information about other sport types. DMS will automatically replicate these new records from the source database to the target database.

  1. Now, use the following script to enable the foreign key constraints that we dropped earlier:
    1. Within MySQL Workbench, click on the File menu, and choose New Query Tab.
    2. Open AddConstraintsSQLServer.sql with a text editor on your computer.
    3. Copy the content to MySQL Workbench query editor.
    4. Execute the script.