With Babelfish for Aurora PostgreSQL, you can migrate and modernize your Microsoft SQL Server databases while maintaining compatibility with existing SQL Server applications.
In this course, you will learn about Aurora PostgreSQL architecture and the complete migration process for SQL Server databases using Babelfish. You will explore how to assess database compatibility, configure Aurora PostgreSQL, and perform migrations using AWS database modernization tools. Through a real-world Orchard Core application scenario, you will gain hands-on experience with migration assessment, implementation, and validation techniques.
This course builds on intermediate AWS and SQL Server knowledge by demonstrating advanced migration techniques and configurations. It incorporates AWS database modernization tools and best practices for a successful migration pathway from SQL Server to Aurora PostgreSQL.
Activities
- Knowledge Checks
- Demonstrations
Course objectives
- Identify SQL Server deployment and migration options on AWS, from lift-and-shift to serverless solutions.
- Recognize AWS database modernization tools, including AWS Database Migration Service (AWS DMS), AWS Schema Conversion Tool (AWS SCT), and replatforming assistant.
- Identify Babelfish for Aurora PostgreSQL architecture components and compatibility features.
- Recognize database assessment requirements and schema compatibility considerations for successful migration.
- Recognize migration implementation steps through an Orchard Core application demonstration.
Intended audience
- Architects
- Data Engineers
- Data Scientists
- Developers
- DevOps Engineers
- Infrastructure Engineers
Recommended Skills
- This requires previous experience with SQL Server and understanding of AWS basic services.
Course outline
- Module 1: Introduction to Deploying and Migrating SQL Servers to AWS
- Overview of SQL Server Modernization
- Options to Deploy and Migrate SQL Server to AWS
- Module 2: Using Amazon Aurora and Database Modernization Tools
- Amazon Aurora Functionality, Architecture and Use Cases
- Database Modernization Tools
- Module 3: Using Amazon Babelfish
- SQL Server to Aurora PostgreSQL Migration Using Babelfish
- Module 3: Resources
- Learn More
- Contact Us
