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 8 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.

USE [SalesDB];

SELECT 'dbo.Customers' As Table_Name, count(*) AS rows_count FROM
dbo.Customers

UNION

SELECT 'dbo.Employees' As Table_Name, count(*) AS rows_count FROM
dbo.Employees

UNION

SELECT 'dbo.Products' As Table_Name, count(*) AS rows_count FROM
dbo.Products

UNION

SELECT 'dbo.Sales' As Table_Name, count(*) AS rows_count FROM dbo.Sales;

Output:

Table_Name rows_count
dbo.Customers 19759
dbo.Employees 23
dbo.Products 504
dbo.Sales 6715221

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.

USE [master] 

GO 

CREATE LOGIN
[awssct] WITH PASSWORD=N'Password1', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF 

GO 

USE [SalesDB] 

GO 

CREATE USER [awssct] FOR LOGIN [awssct] 

GO 

EXEC master..sp_addsrvrolemember
@loginame=N'awssct', @rolename=N'sysadmin' 

GO  

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.