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.
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.