Home icon

Modernize your legacy databases with AWS data lakes, Part 1: Migrate SQL Server using AWS DMS

Database Blog

The article discusses how to migrate data from a Microsoft SQL Server database to an Amazon S3 data lake using AWS Database Migration Service (DMS). It provides a step-by-step guide on setting up AWS DMS to replicate data from SQL Server to S3 in CSV format, preserving transaction order for change data capture (CDC).

Specifically, the article covers:

  • Solution overview and architecture
  • Prerequisites for the migration
  • Creating AWS DMS source and target endpoints
  • Enabling CDC on the SQL Server source database
  • Configuring AWS DMS Serverless replication task
  • Monitoring the replication process
  • Cleanup steps to delete the resources created
Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Oct 30
2024
Modernize your legacy databases with AWS data lakes, Part 2: Build a data lake using AWS DMS data on Apache Iceberg
Oct 30
2024
Modernize your legacy databases with AWS data lakes, Part 3: Build a data lake processing layer
Jan 3
2024
Migrate SQL Server databases to AWS with minimal downtime using AWS Migration Hub Orchestrator
Apr 1
2024
Accelerate your database migration journey using AWS DMS Schema Conversion

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.