AWS Database Blog

Tag: migration

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

Migrating databases using RDS PostgreSQL Transportable Databases

Amazon RDS for PostgreSQL now supports the feature Transportable Databases, a high-speed data import and export method supported on versions 11.5 and later and 10.10 and later. If you need to import a PostgreSQL database from one RDS PostgreSQL instance into another, you can use native tools such as pg_dump and pg_restore or load data […]

Read More

Migrating your on-premises SQL Server Windows workloads to Amazon EC2 Linux

For decades, IT administrators could only run their SQL Server workloads on Windows. However, as of SQL Server 2017, SQL Server is now available to run in the Linux operating system. For IT administrators, this represents an opportunity to run SQL Server workloads on their preferred operating system, save on Windows Server licensing costs, and […]

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

Building a cross-account continuous delivery pipeline for database migrations

To increase the speed and quality of development, you may use continuous delivery strategies to manage and deploy your application code changes. However, continuous delivery for database migrations is often a manual process. Adopting continuous integration and continuous delivery (CI/CD) for database migrations has the following benefits: An automated multi-account setup simplifies database migrations. The […]

Read More

Reduce database cost and improve availability when you migrate to the AWS Cloud

Let’s say you have an application that uses database tables to store log and clickstream data. You might store your data in a relational database to ease development and management tasks. When you launch your application, the database is manageable at first, but it grows to hundreds of gigabytes per week. Data storage and retrieval […]

Read More

AWS Database Migration Service improves migration speeds by adding support for parallel full load and new LOB migration mechanisms

We’re happy to introduce AWS DMS replication engine version 3.1.2. The new version includes a better UX and performance improvements that were requested by many customers. We listened and delivered on our promise to make DMS better. In this blog post, I’ll cover few key new features. For the entire list, see the AWS DMS […]

Read More

How to solve some common challenges faced while migrating from Oracle to PostgreSQL

Companies are experiencing exponential data growth year-over-year. Scaling the databases and the hardware infrastructure to keep up is becoming more and more challenging. If your workloads just are not suitable for non-relational data stores, how do you overcome the scaling challenges without spending tons of money in managing the underlying infrastructure? Amazon RDS for PostgreSQL and Amazon […]

Read More

Oracle Database zero downtime migration with AWS Database Migration Service and Accelario

Accelario is database migration software that provides a fast and easy way to load an Oracle database to Amazon Web Services (AWS). At the end of the initial load, database synchronization starts immediately using AWS Database Migration Service (AWS DMS), and the result is a zero downtime migration of your database.

Businesses that require 24/7 operation face a significant issue when moving databases into the cloud: Up until now, few if any cost-effective options existed to minimize the resulting downtime. With its recent integration with AWS DMS, Accelario provides a ready-to-use, zero downtime, full database migration solution—meaning that the whole database is migrated, including users, procedures, views, etc. When the process is done, you can access your database and start using it with your application immediately.

Read More

Best practices for migrating an Oracle database to Amazon RDS PostgreSQL or Amazon Aurora PostgreSQL: Target database considerations for the PostgreSQL environment

An Oracle to PostgreSQL migration in the AWS Cloud can be a complex multistage process with different technologies and skills involved, starting from the assessment stage to the cutover stage. This blog post is the third in a series that discusses high-level aspects about the components to consider for a database migration. The series doesn’t […]

Read More