AWS Eases Data Warehouse Imports

Amazon Web Services Inc. (AWS) unveiled a new way to ease the export of data stored in Teradata and Oracle data warehouses into its own offering, Amazon Redshift.

The updated AWS Schema Conversion Tool (SCT) automatically converts most custom code -- such as views, stored procedures and functions -- along with the data warehouse schemas into a Redshift-compatible format. If such custom code can't be readily converted by the tool, it's marked for manual conversion.

Along with the new ability to migrate Oracle and Teradata data warehouses into Amazon Redshift, the tool can also do the same thing with Netezza and Greenplum data warehouses.

The SCT primarily has been used to migrate other databases -- especially commercial relational databases -- into AWS-based, open source databases. It typically moves data from systems such as Oracle, Microsoft SQL Server and others to AWS offerings such as Amazon Aurora and third-party databases such as MySQL, MariaDB and more.

"SCT can also scan your application source code for embedded SQL statements and convert them as part of a database schema conversion project," the tool's Web site states. "During this process, SCT performs cloud native code optimization by converting legacy Oracle and SQL Server functions to their equivalent AWS service thus helping you modernize the applications at the same time of database migration."

The SCT works with data stored on-premises or in Amazon RDS or EC2, which can also be the targets to receive migrations.

The SCT can be downloaded in versions for Microsoft Windows, Apple Mac, Fedora Linux (rpm) and Ubuntu Linux (deb).

"AWS SCT will run an analysis of your data warehouse, automate the schema conversion, apply the schema to the Amazon Redshift target and extract your warehouse data, regardless of volume," the company said in a blog post. "You can use Amazon S3 or Amazon Snowball to move your exports to the cloud, where Amazon Redshift can natively import the data for use."

About the Author

David Ramel is the editor of Visual Studio Magazine.