Index Creation In SQL Azure

Doing some testing in SQL Azure, I found that table creation is a slightly different beast.  Simply using a SQL table creation script generated by the SQL Server Management Studio does not translate into the Azure environment.  I needed to make some modifications first to get the code working correctly, specifically how Indexes are created.

Continue reading

Migrating from MySQL to Microsoft SQL Server?

I ran across an interesting tool from Microsoft today that would migrate your contents from MySQL to MS SQL Server 2008 and SQL Azure, the cloud version.

http://www.microsoft.com/downloads/details.aspx?FamilyID=0e6168b0-2d0c-4076-96c2-60bd25294a8e&displaylang=en

I wonder when Oracle would release their migration tool.

There is one clear winner from this database war…the consumer and to that, I’d say let’s bring it on.