Prerequisites
Connecting to the AWS Console
Get Connection Information
1.
Source EC2 Database Server info
2.
Get SQL Server Information
3.
Get Amazon Aurora Information
Connecting and Validating the Resources
1.
Connecting to the Jumpserver via RDP
2.
Connecting to SQL Server via Sql Server Management Studio (SSMS)
3.
Connecting to Amazon Aurora (MySQL) via MySQL workbench
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
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
>
Get Connection Information
> Source EC2 Database Server info
Source EC2 Database Server info
Sign In
to the AWS Management Console and open the
Amazon EC2
console at
https://console.aws.amazon.com/ec2/
Choose the
Region
on the upper-right hand side, where the
Source
EC2 DB Server resides.
On the left navigation pane, go to
Instances
and select the EC2 Instance (for this demo, Name Tag should have
EC2DB
suffix)
Grab both the
Public IP
, as we’ll be using this to connect.
Password
will be given by
Facilitator