AWS Database Blog

Category: Migration

AWS Schema Conversion Tool introduces new features in build 616

We are excited to introduce a new version of AWS Schema Conversion Tool (AWS SCT) that includes support for PostgreSQL 10 partitioning, a new server-level Assessment Report, support for table-valued functions, and more. For those of you who are new to AWS SCT, this tool helps convert your existing database schema from one database engine […]

Read More

How to work with native CDC support in AWS DMS

AWS Database Migration Service (AWS DWS) today launches native CDC support and the ability to start and stop the AWS DMS replication from a specific checkpoint. When you work with this feature, you can use checkpoints such as a log sequence number (LSN) in Microsoft SQL Server, a system change number (SCN) in Oracle, and […]

Read More

How to archive data from relational databases to Amazon Glacier using AWS DMS

You can use AWS Database Migration Service (AWS DMS) to migrate data from various sources to most widely used commercial and open-source databases. AWS DMS also supports Amazon S3 as a source and as a target for migrations. When you use Amazon S3 as a target, you can use AWS DMS to extract information from any database […]

Read More
Database Migration

How to migrate BLOB and CLOB tables from Oracle to PostgreSQL using Ora2pg and AWS DMS

Many enterprises are considering migrating their Oracle databases to PostgreSQL because of the close compatibility between the platforms and the enterprises’ desire to reduce licensing costs. Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility make it easy to set up, operate, and scale PostgreSQL deployments in the cloud in a cost-efficient manner. AWS […]

Read More

How to encrypt database columns with no impact on your application using AWS DMS and Baffle

AWS offers a wealth of security features to protect its infrastructure and services, such as AWS Identity and Access Management (IAM) and AWS Key Management Service (AWS KMS). AWS Data Migration Service (AWS DMS) provides users a simple automated way of migrating data from their existing databases to Amazon RDS. As part of this, AWS […]

Read More

How to migrate to Amazon RDS for SQL Server using transactional replication

You can migrate your databases into Amazon RDS for Microsoft SQL Server in multiple ways. Typically, you perform a simple backup and restore of the databases (along with scripting system objects such as logins). If you want a higher availability or lower downtime option, you might use the AWS Database Migration Service (AWS DMS). In […]

Read More

AWS DMS now supports R4 Type Instances and learn to choose the right instance AWS DMS migrations

We are happy to announce support for R4 memory-optimized instances of Amazon EC2 in AWS Database Migration Service (AWS DMS). These instances come with more memory and higher network bandwidth to help support migrations requiring higher throughput and memory-intensive operations. Here you can see the lineup of instances that is supported in DMS. Now that […]

Read More

AWS DMS now supports Binary Reader for Amazon RDS for Oracle and Oracle Standby as a source

We are excited to announce support for Binary Reader for Amazon RDS for Oracle and Oracle Active Data Guard Standby as sources for migration in AWS Database Migration Service (AWS DMS). AWS DMS helps you migrate databases to AWS quickly and relatively securely. It also helps you migrate data within AWS. You can migrate your […]

Read More

AWS Database Migration Service and AWS Schema Conversion Tool now support IBM Db2 LUW as a source

Managing and operating relational databases is a basic piece of maintaining an effective business. Relational databases come in many flavors—commercial (Oracle, Microsoft SQL Server, IBM Db2, and so on) and open source (MySQL, PostgreSQL, and so on). With innovation and improvements in the open-source database world and cloud computing platforms like AWS, many enterprises are […]

Read More

Learn to master MySQL database migrations with Aurora

By Nathaniel Kangpan, SVP Technology & Data Services, Kepler Group I have yet to meet a client in the past 12 months that doesn’t already (a) have a team or two dipping their toes into cloud-based infrastructure, or (b) have the cloud on their roadmap for 2018. Total cost of ownership (TCO) savings for migrating […]

Read More