Using data extraction filters for smart database migration with AWS Schema Conversion Tool
29 Jun 2017

Amazon introduced the data extraction agents in the previous release of AWS Schema Conversion Tool (SCT). They allowed for migrating all the data from your on-premises data warehouse platforms to Amazon Redshift. Wait, what if you don’t need to move all those terabytes of data, and just want to settle for the data generated in the past couple of years? Starting from the version 1.0.603, SCT allows filtering the data before uploading it to Redshift. In addition, the latest SCT version brings support to rather outdated Teradata 13 and Oracle Data Warehouse 10 schemas. In the following video, we will demonstrate how you can use the data extrac...

Using data extraction agents to fulfill the database migration projects in AWS Schema Conversion Tool
07 Jun 2017

The Amazon Database Migration Service (DMS) does a great job in helping to copy data from your on-premises databases to AWS RDS for OLTP workloads. When you start talking about terabytes of data, the prior version of DMS was not up for the job. Amazon realized the shortcoming and developed an extension to the Schema Conversion Tool to create a performant way to migrate Terabytes of data from your on-premises Data Warehouse platforms to Amazon Redshift. On May 11, 2017, Amazon released version 1.0.602 of AWS Schema Conversion Tool (SCT). With the help of data extraction agents that were introduced in this update, AWS Schema Conversion Tool now...

Extracting Data from Warehouses with Data Migration Agents in AWS Schema Conversion Tool
15 Mar 2017

Migrating data warehouses to Amazon Redshift represents a serious challenges when you consider what it takes to transfer huge amounts of data in parallel. On February 16, 2017, Amazon released version 1.0.600 of AWS Schema Conversion Tool (SCT). This release brings the support of Data Migration Agents. Now you can effectively extract data from Oracle and Teradata data warehouses and prepare it for use with Amazon Redshift. In the following video, we will demonstrate the typical workflow of using the Data Migration Agents to extract data and upload it to Amazon Redshift using the S3 Bucket as a data loading zone. Make sure to check out our new...