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 Microsoft SQL Server Management Studio from within the EC2 server.

  2. Follow the instructions described earlier to connect to the Target RDS SQL Server instance.

  3. Inspect the migrated RDS SQL database (dms_recovery) content, and make sure the following tables have migrated over. You can do that by opening a New Query window to execute the following statement. You should see a total of 16 tables.

use dms_recovery
SELECT *
FROM dms_recovery.INFORMATION_SCHEMA.TABLES;
GO
  1. Next, execute the following query:
use dms_recovery
SELECT * FROM dms_recovery.sport_type;
GO

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.