AWS Database Blog
Author: Shyam Sunder Rakhecha
Shyam is a Lead Cloud Infrastructure Architect at AWS with over 18 years of experience in technology and brings extensive experience in cloud technologies, migration & modernization, and database domains. Shyam is passionate about helping customers architect and execute large-scale migration strategies and achieve their modernization objectives, as well as mentoring the next generation of cloud professionals.
Implement advanced replication features with Amazon RDS for MySQL and Amazon Aurora MySQL using intermediate replication servers
In this post, we show you how to use advanced replication features between MySQL-compatible databases such as Amazon Aurora MySQL-Compatible Edition clusters or Amazon Relational Database Service (Amazon RDS) for MySQL instances. We discuss two replication capabilities in Amazon RDS and Amazon Aurora: multi-source replication and replication filtering. Multi-source replication is supported only in Amazon […]
Best practices for migrating SQL Server MERGE statements to Babelfish for Aurora PostgreSQL
To migrate a SQL Server database to Babelfish for Aurora PostgreSQL, you usually need to perform both automated and manual tasks. The automated tasks involve automatic code conversion using the Babelfish Compass tool with the -rewrite flag and data migration using AWS Database Migration Service (AWS DMS). The manual tasks involve database compatibility check using […]
Validate database objects post-migration from Microsoft SQL Server to Amazon RDS for MySQL and Amazon Aurora MySQL
Database object validation plays a key role in the database migration process. It’s the process of determining whether all the source database objects have been successfully migrated to the target database by comparing their types and counts. If you skip the validation phase, you may encounter runtime errors due to missing database objects, which can […]