Prerequisties for migrating SQL Server AlwaysOn databases on primary replica to Amazon Aurora PostgreSQL
The following prerequisites are required to complete this migration:
-
An Amazon account with Amazon Identity and Access Management (IAM) credentials that allow you to launch Amazon RDS and Amazon Database Migration Service (Amazon DMS) instances in your Amazon 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 Amazon DMS replication instances, see Setting up network for replication instance . For information about Amazon DMS using Route53 for endpoint name resolution, see Using Amazon Route 53 Resolver with Amazon DMS . -
A general understanding of using Microsoft SQL Server as a source and Amazon Aurora PostgreSQL as a target endpoint in an Amazon 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 (Amazon SCT)