Is SQL Azure Ready for Production?
Today another reader, Luis, writes in with his experience with SQL Azure. It would seem that the SQL Azure platform suffers when development relies heavily on the Data Sync process. Here’s what Luis says.
My experience with SQL Azure Data Sync has been… interesting. The fact that it’s still in development means that we have to keep checking constantly to see what they have added (or removed) to their service every other week. It really feels like it’s not ready for full-time production service yet.
When you do the initial synchronization, the process can take literally days (I’m serious) to upload all of your data into SQL Azure from your on-premise DBs (when your DBs are in the double-digits GB range). And when you need to do (what should be) relatively simple changes to your DB schema, the recommended process is to delete your synchronization groups and data and start all over again. It actually takes longer for the process if you leave the data that you already have, than if you delete it and upload everything from zero.
I think that Data Sync will be a great tool for updating the information you need to have in the Cloud… as soon as they finish developing it.
Perhaps your experience has been different. Or perhaps your databases are smaller allowing the platform to work nicely. Srop us a note with your experience, or leave a comment below. Send emails to btaylor@sswug.org if you prefer.
Cheers,
Ben
$$SWYNK$$
Featured Article(s)
Troubleshooting problems with SQL Server 2012 cluster
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2012 cluster.