Bridging the Computing Clouds with SSMA2008

Microsoft went relational with its flagship SQL Server 2008 ported out to the clouds with SQL Azure

Jan. 10, 2010 01:30 PM

Well, for various reasons you may be willing (wanting) to place a part of your stuff on Microsoft Azure and part on the Amazon Cloud.

In fact it is a repetition of the same story of the bygone era, some data on Microsoft platform, some on Oracle etc.

Sooner or later you want to move data from one to the other.

Of course there are the integration tools that can handle this. But there are others who specialize in migration of data.

Microsoft went relational with its flagship SQL Server 2008 ported out to the clouds with SQL Azure. Soon Amazon followed with its relational offering based on MySQL.

Now Microsoft has released SQL Server Migration Assistant 2008 for MySQL v1.0 in CTP1. This is a toolkit that you may use to migrate your MySQL data to SQL Server 2008 and SQL Azure. This is a nice one way bridge to SQL Azure from Amazon's MySQL.

Every database vendor has his own migration tool to take away data from a rival. There is the Oracle SQL Developer, there are migration wizards in Sybase's SQL Anywhere not counting the similar tools for the Big Blue. Of course there are other third party vendors using their skills to migrate from anywhere to anywhere.

All told it has never been easier to move data along the internet highway, nor the cloud jet way.

You may download SSMA 2008

and give it a spin. Well there is another toolkit if you want to migrate to SQL Server 2005 at the same site.

Note: SSMA 2008 for MySQL v1.0 CTP1 is designed to work with MySQL 4.1, 5.0 and 5.1 and all editions of SQL Server 2008 or SQL Azure.

If you are interested in migrating data, read all of my migration related articles for free on my blog here.

All so, if you are interested in Business Intelligence, read my no brainer SQL Server Business intelligence books here and here.

Read the original blog entry...

Published Jan. 10, 2010— Reads 3,557
Copyright © 2010 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.

Related Stories

▪ The Network Beneath the Clouds

▪ C12G Introduces Free Evaluation and Low-Cost Entry Programs to Build Clouds with OpenNebula EE

About Jayaram Krishnaswamy
Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. Most recently his book, "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. He writes articles on several topics to many sites.

Enterprise Open Source Magazine Latest Stories . . .

Deltacloud Graduates to TLP

By Maureen O'Gara

Apache Deltacloud, the Red Hat-contributed ReSTful API that abstracts differences between clouds so services on any cloud can be managed – provided of course there’s a driver – has graduated from the Apache Foundation’s incubator and is now a full-fledged Top-Level Project (TLP). The...

Cloud Expo New York Speaker Profile: Mark Hinkle – Citrix Systems

By Jeremy Geelan

With Cloud Expo 2012 New York (10th Cloud Expo) just four months away, what better time to start introducing you in greater detail to the distinguished individuals in our incredible Speaker Faculty for the technical and strategy sessions at the conference... We have technical and st...

AMD Sales Chief Out

By Maureen O'Gara

AMD said late Tuesday that its chief sales officer Emilio Ghilardi had left the company and that CEO and president Rory Read is going to do his job while a replacement is sought. AMD didn’t say why Ghilardi left but it’s assumed Read wants his own people. Read is relatively new to th...

M3 Timers – Improved Server Monitoring

By Hovhannes Avoyan

During the lifespan of M3 (Monitis Monitor Manager) there has always been something lacking – timers. M3 execution procedure was outlined in this previous article. The execution mentioned in the latter was a one-time-execution, whereas server monitoring requires periodic invocati...

Red Hat Puts Gluster Appliance on Amazon

By Maureen O'Gara

Red Hat is putting its bought-in Gluster scale-out NAS storage technology, acquired in October, on the Amazon cloud. It’s styled Red Hat Virtual Storage Appliance for Amazon Web Services and other clouds are supposed to follow in short order.

The New OpenNebula Self-Service Portal in Action

By Ignacio M. Llorente

A new episode of the screencast series is now available at the OpenNebula YouTube Channel. This screencast demonstrates the new easily-customizable self-service portal for cloud consumers. Its aim is to offer a simplified access to shared infrastructure for non-IT end users. The scree...