AWS re:Invent 2016: Practices for Migrating from Commercial Engines to Aurora or PostgreSQL (DAT302)

Published on Dec 03, 2016

You can significantly reduce database licensing and operational costs by migrating from commercial database engines to Amazon Aurora or Amazon RDS for PostgreSQL. In addition to cost reduction you also gain flexibility and operational efficiency by avoiding the frustrating usage constraints that the commercial databases licenses come with. Amazon Aurora and Amazon RDS for PostgreSQL are fully managed database services so you no longer need to worry about complex database management tasks. You can launch a single database instance or thousands of them in just a few minutes, and pay only for what you use. In this session we will dive deep into how AWS Database Migration Service and AWS Schema Conversion Tool help you migrate your commercial databases like Oracle and Microsoft SQL Server to Amazon Aurora or Amazon RDS for PostgreSQL easily and securely with minimal downtime. In this session you will also learn from Aaron Carerras, Senior Data Architect at FINRA, the approach FINRA has used to migrate their databases to Amazon RDS for PostgreSQL. As a financial regulator, FINRA has strict uptime SLAs and data security requirements and will be using RDS to meet them. The Financial Industry Regulatory Authority (FINRA) is one of the largest independent securities regulators in the United States, tracking up to 75 billion stock market events per day.