AWS Database Blog

Tag: AWS Database Migration Service

Achieving minimum downtime for major version upgrades in Amazon Aurora for PostgreSQL using AWS DMS

AWS provides two managed PostgreSQL options: Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL. When Amazon RDS or Aurora support a new major version of a database engine, for example, PostgreSQL 10 to 11, you can upgrade your DB instances to the new version. Major version upgrades can contain database changes that may not be […]

Read More

Configuring SSL encryption on Oracle and PostgreSQL endpoints in AWS DMS

AWS Database Migration Service (DMS) helps you migrate databases to AWS securely. It supports homogeneous and heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora. AWS DMS supports continuous data replication while maintaining high availability and has been widely adopted for database migrations because it is easy to configure. For more information, […]

Read More

Continuous database replication using AWS DMS to migrate from Oracle to Amazon Aurora

This is a guest post from IPG. In their own words, “IPG, based in Japan, specializes in TV-related data. We use data from broadcasters across Japan, format it for easy use and understanding, structure it with metatags, and make it simple to use on any platform, like smartphones.” This post discusses the different optimizations we […]

Read More

Migration tips for developers converting Oracle and SQL Server code to PostgreSQL

PostgreSQL is one of the most popular open-source relational database systems. It is considered to be one of the top database choices when customers migrate from commercial databases such as Oracle and Microsoft SQL Server. AWS provides two managed PostgreSQL options: Amazon RDS and Amazon Aurora. In addition to providing managed PostgreSQL services, AWS also […]

Read More

Automating table mappings creation in AWS DMS

AWS Database Migration Service (AWS DMS) helps you migrate on-premises databases to AWS quickly and securely. It supports homogeneous migrations as well as heterogeneous migrations. The source database remains operational while the migration is running or being tested. Migration takes place using a DMS replication server, source, target endpoints, and migration tasks. If you are […]

Read More

Validating database objects after migration using AWS SCT and AWS DMS

Database migration can be a complicated task. It presents all the challenges of changing your software platform, understanding source data complexity, data loss checks, thoroughly testing existing functionality, comparing application performance, and validating your data. AWS provides several tools and services that provide a pre-migration checklist and migration assessments. You can use the AWS Schema […]

Read More

Automating database migration and refreshing activities with AWS DMS

Application developers and system administrators replicate data across datastores to migrate, refresh, and mask data. For most organizations, data replication is a complex, multiphase process, including assessment, schema conversion, script conversion, data migration, functional testing, performance tuning, and other tasks. Multiple tools are available to support data replication. AWS Database Migration Service (DMS) helps you quickly […]

Read More

Automate AWS CloudFormation template creation for AWS DMS tasks

Expanding on the earlier post, Create AWS CloudFormation templates for AWS DMS tasks using Microsoft Excel, this post highlights an enhanced feature of the same tool that can speed database migration. To demonstrate this feature, we present a small command line tool written in Python. The tool takes a CSV file containing the names of […]

Read More