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.

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.