Part 2 - Connecting to your environment
1. RDP into the EC2 instance (endpoint is the CF output value for SourceEC2EndpointDns) using the Administrator password you defined in lab setup step 1.1.2.
Note: If you’re using MAC and you haven’t already; you might want to install
Microsoft Remote Desktop
from App Store.
2. Launch SQL Server Management Studio on EC2 instance and connect to the local source database instance on the EC2 by typing ‘localhost’ for Server name and using Windows Authentication as below.
3. Copy the T-sql script in New Query window and execute. Validate the 4 tables with following row count in the SalesDB database.
SELECT 'dbo.Customers' As Table_Name, count(*) AS rows_count FROM
SELECT 'dbo.Employees' As Table_Name, count(*) AS rows_count FROM
SELECT 'dbo.Products' As Table_Name, count(*) AS rows_count FROM
SELECT 'dbo.Sales' As Table_Name, count(*) AS rows_count FROM dbo.Sales;
4. Copy the following T-sql script in another New Query window and execute. This will create a SQL Login with the user name ‘awssct’ and password as ‘Password1’ for our use later in SCT and DMS. It should show “Command(s) completed successfully.” after you run it.
[awssct] WITH PASSWORD=N'Password1', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
CREATE USER [awssct] FOR LOGIN [awssct]
5. Launch MySQL workbench (client) on the EC2 instance and create a new connection to your Aurora Instance endpoint (Database menu, Connect To Database). Username: admin Password: the password you gave in step 1.1.2 (endpoint is the CF output value for TargetAuroraEndpointDns)
6. Validate that there are no tables in the Target Aurora instance.