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
Working on the Source SQL Server DB Server
1.
Connecting to the Source SQL Server via RDP
2.
Connecting to SQL 2017 via SSMS
3.
Backup a Database via SSMS
4.
Transferring the backup to S3
Working on the Target RDS
1.
Prerequisites
2.
Creating an Option Group for SQL Server on RDS
3.
Configuring the Option Group for SQL Native Backup/Restore
4.
Adding the Option Group to the RDS SQL Instance
5.
Using an EC2 Jump Server to Access RDS
6.
Working with SQL Server on RDS via SSMS
7.
Restoring a Database on RDS via SSMS
Home
Author
Clear History
Links
Privacy |
Site terms
© 2020 Amazon Web Services, Inc. or its Affiliates. All rights reserved.
Edit this page
MSSQL to SQL Server on Amazon RDS Workshop
>
Working on the Source SQL Server DB Server
> Transferring the backup to S3
Transferring the backup to S3
While logged in the Source EC2 Server, open
Microsoft Edge
:
Then sign in to the AWS Management Console and open the Amazon S3 console at
https://console.aws.amazon.com/s3/
.
Once Logged in, go to
Services
, just click on
S3
under the
Storage
category:
In the
Bucket Name
list, choose the name of the bucket that you want to upload your object to:
Choose
Upload
In the
Upload
dialog box, choose
Add files
to choose the file to upload.
Choose a file to upload
(in this case, our backup file .bak)
, and then choose
Open
Choose
Upload