Validation and Conclusion
To Validate our Results, we need to compare the Tables that were copied to the Target Database from the Source
- 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
- Open MySQL Workbench, connect back to the Target Aurora database and Run the script Below:
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;
- Compare the rowcounts on both databases, and you should see that they match:
Conclusion