Microsoft SQL Server to Amazon S3

Now that you have completed setting up the workshop enviornment, you are ready to migrate a sample data base.

This step-by-step guide demonstrates how you can use AWS Database Migration Service (DMS) to migrate data from a Microsoft SQL Server database to Amazon Simple Storage Service (Amazon S3) bucket. Additionally, you will use AWS DMS to continually replicate database changes from the source database to the target S3 bucket.

The environment for this lab consists of:

  • A Microsoft SQL Server running on an EC2 instance as the source database. This server is also used run Microsoft SQL Server Management Studio.
  • An Amazon S3 Bucket as the target destination for the data.


Before proceeding further, make sure you have completed the instructions in the Getting Started section that preceeded this chapter.