Thursday, October 8, 2015

AWS Rocks with Database Migration Tools

Traditional, enterprise vendors discount AWS as providing IaaS and PaaS with lots of integration and monitoring magic. Sort of like positioning the move to the cloud as out-sourcing the local datacenter hardware. But, adopting AWS is doing more than a forklift move, it's also an opportunity to convert older systems from proprietary to open-source. Quentin Hardy of the NYTimes notes some of these announcements at Amazon's latest conference: 
Among the most notable, there was a 47-pound data storage device that A.W.S. would ship to a customer [aka Snowball], and for $200 would suck down 50 terabytes of data, incidentally converting it from an older system to a more modern one. There was a service called Database Migration, which takes data in proprietary systems and converts their schema to open-source products.
This is quite a phenomenal service -- AWS can ship a Snowball appliance to a datacenter, where it can consume terabytes, ready to be shipped back and transfer the data much, much faster than doing it over-the-wire. Actually, AWS boasts that by serializing multiple Snowball appliances, the throughput can be measured as up to a petabyte/week.
Combine the Snowball technology, with the AWS database migration tools, and it's possible to move "database schemas and stored procedures from one database platform to another, so customers can move their applications from Oracle and SQL Server to Amazon Aurora, MySQL, MariaDB, and soon PostgreSQL."