AWS updates its schema conversion tool
Amazon Web Services (AWS) just made it easier to export data into Amazon Redshift from Teradata and Oracle data warehouses.
The company recently announced an update to its AWS Schema Conversion Tool (SCT), giving it the ability to automatically convert most custom code -- such as functions, views and stored procedures -- 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."
David Ramel is an editor and writer for 1105 Media.