Prerequisties for migrating SQL Server AlwaysOn databases on primary replica to Amazon Aurora PostgreSQL
The following prerequisites are required to complete this migration:
-
An AWS account with AWS Identity and Access Management (IAM) credentials that allow you to launch Amazon RDS and AWS Database Migration Service (AWS DMS) instances in your AWS Region. For information about IAM credentials, see Create an IAM User.
-
A general understanding of Amazon Virtual Private Cloud (Amazon VPC), DNS, and security groups concepts. For information about using Amazon VPC with Amazon RDS, see Amazon Virtual Private Cloud (VPCs) and Amazon RDS. For information about Amazon RDS security groups, see Amazon RDS Security Groups. For information about network setup to support AWS DMS replication instances, see Setting up network for replication instance. For information about AWS DMS using Route53 for endpoint name resolution, see Using Amazon Route 53 Resolver with AWS DMS.
-
A general understanding of using Microsoft SQL Server as a source and Amazon Aurora PostgreSQL as a target endpoint in an AWS DMS] based migration. For information about working with SQL Server as a source, see Using a SQL Server Database as a Source. Aurora PostgreSQL is a PostgreSQL compatible database. For information about working with Aurora PostgreSQL as a target, see Using a PostgreSQL database as a Target.
-
An understanding of your source table structure, backup policy, and resource constraints.
-
Convert your SQL Server database schema to PostgreSQL using a optional tool such as Schema Conversion Tool (AWS SCT)
