Validation and Conclusion

To Validate our Results, we need to compare the Tables that were copied to the Target Database from the Source

  1. Return to the JumpServer and back to SQL Server Management Studio, run the query below, and take note of the rowcounts.
    You can refer to the prior instructions at: Validate source table rowcount

    SELECT 'dbo.Customers' As Table_Name, count(*) AS rows_count FROM sampledb.dbo.Customers  
    UNION
    SELECT 'dbo.Employees' As Table_Name, count(*) AS rows_count FROM sampledb.dbo.Employees
    UNION
    SELECT 'dbo.Products' As Table_Name, count(*) AS rows_count FROM sampledb.dbo.Products
    UNION
    SELECT 'dbo.Sales' As Table_Name, count(*) AS rows_count FROM sampledb.dbo.Sales
    1. Open MySQL Workbench, connect back to the Target Aurora database and Run the script Below:
      sql SELECT 'Customers' As Table_Name, count(*) AS rows_count FROM sampledb.Customers UNION SELECT 'Employees' As Table_Name, count(*) AS rows_count FROM sampledb.Employees UNION SELECT 'Products' As Table_Name, count(*) AS rows_count FROM sampledb.Products UNION SELECT 'Sales' As Table_Name, count(*) AS rows_count FROM sampledb.Sales;
  2. Compare the rowcounts on both databases, and you should see that they match:

Conclusion

You have successfully completed this lab by creating a Replication Task on DMS that copies 4 tables and their data from source to target. You validated the data before and after the migration using the client tools on the EC2 instance.