Prerequisites
Connecting to the AWS Console
Get Connection Information
1.
Source EC2 Database Server info
2.
Target EC2 Jump Server
3.
Target SQL Server on RDS
Creating an S3 Bucket
Migration
1.
Validate Source Table Row Count
2.
Create database user for SCT and DMS
3.
Setting Up Schema Conversion Tool
4.
Using Schema Conversion Tool
5.
Migrate stored procedures using SCT
6.
Database Migration Service Prerequisites
7.
DMS - Replication Instance
8.
DMS - Endpoints
9.
DMS - Migration Task & Migration
10.
Validation and Conclusion
Working on Source SQL Server DB Server
1.
Connecting to the Source SQL Server via RDP
2.
Connecting to SQL 2017 via SSMS
3.
Connecting to Amazon Aurora (MySQL) via MySQL workbench
Home
Author
Clear History
© 2019 Amazon Web Services, Inc. or its Affiliates. All rights reserved.
Edit this page
MSSQL to SQL Server on Amazon RDS Workshop
>
Working on Source SQL Server DB Server
> Connecting to Amazon Aurora (MySQL) via MySQL workbench
Connecting to Amazon Aurora (MySQL) via MySQL workbench
Go and click on the
MySQL Workbench
icon on the Desktop, or go to Start, start typing
mysql
and click on the
MySQL Workbench
.
If you get the warning below, just ignore:
Inside MySQL Workbench, on the top menu, click on
Database
then click on
Connect to Database
In the
Connect to Database
window, do the following:
For Hostname, enter the
Aurora MySQL Endpoint
(make sure to remove spaces/special characters).
It’s always a good idea to clear the password vault, so click on the
Clear
button, then click ok.
The next screen will ask for the password (
specified by the facilitator
)
Example of successful connection