AWS Database Blog

Category: Migration & Transfer Services

How to Migrate Your Oracle Database to PostgreSQL

Knievel Co is a database engineer at HAQM Web Services. This blog post provides an overview on how you can migrate your Oracle database to PostgreSQL. The two biggest parts of a database migration are the schema conversion and the data replication. We go over how to use the AWS Schema Conversion Tool (AWS SCT) […]

Using the AWS Database Migration Service, HAQM S3, and AWS Lambda for Database Analytics

Jeff Levine is a solutions architect for HAQM Web Services. The AWS Database Migration Service (AWS DMS) supports HAQM S3 as a migration target. The services enable you to extract information from any database supported by DMS and write it to HAQM S3 in a format that can be used by almost any application. You can extract the entire […]

Migrate Your Procedural SQL Code with the AWS Schema Conversion Tool

Database administrators and developers rely on relational databases to store data for applications. As Forbes noted in 2016, the development of open source offerings for database management systems like PostgreSQL is causing a growing number of enterprises to migrate to lower-cost solutions for their data storage. The move to the cloud often provides an excellent […]

How to Migrate Your Oracle Data Warehouse to HAQM Redshift Using AWS SCT and AWS DMS

Shree Kenghe is a solutions architect at HAQM Web Services. This blog post gives you a quick overview of how you can use the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) to help you migrate your existing Oracle data warehouse to HAQM Redshift. HAQM Redshift is a fast, fully […]

Migrating to PostgreSQL Lifecycle

This is a guest post by David Rader, the vice president of product development at OpenSCG. OpenSCG is an AWS Consulting Partner and a leading expert in PostgreSQL, helping customers migrate to, operate, and optimize PostgreSQL and other data platforms on-premises and in the cloud. There is a lot of interest these days in migrating […]

Set Up AWS DMS for Cross-Account Migration

Hemant Borole is a big data consultant at HAQM Web Services. AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS easily and securely. AWS DMS supports homogenous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to HAQM Aurora. For customers who use […]

Use SQL to map users, roles, and grants from Oracle to PostgreSQL

July 2023: This post was reviewed for accuracy. Many customers are undertaking the journey to open source relational database management system (RDBMS) databases. With the latest release of the AWS Schema Conversion Tool (AWS SCT), it’s easy to change your database engine. AWS SCT makes heterogeneous database migrations easier by automatically converting procedural code from […]

Introducing Data Extractors in AWS Schema Conversion Tool Version 1.0.602

We are pleased to announce the recent release of version 1.0.602 of the AWS Schema Conversion Tool (AWS SCT). The new version includes a new key capability—data migration agents that extract data from Oracle, MS SQL Server, Teradata, IBM Netezza, Greenplum and HPE Vertica data warehouses, prepare, optimize and upload it to HAQM Redshift. The […]

Migrating Oracle Database from On-Premises or HAQM EC2 Instances to HAQM Redshift

Ballu Singh and Pubali Sen are solutions architects at HAQM Web Services. AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS easily and securely. The AWS Database Migration Service can migrate your data to and from most widely used commercial and open-source databases. The service supports homogenous migrations such as Oracle to […]

Events and Notifications in AWS Database Migration Service

We’ve recently added a new feature in AWS Database Migration Service (AWS DMS)—the ability to receive DMS events notifications, such as email messages, text messages, or calls to HTTP endpoints, through HAQM Simple Notification Service (HAQM SNS). You now can subscribe and receive notifications for two types of events—events related to DMS instances and events […]