Sep 17

Written by: Paul Rony
9/17/2009 10:06 AM 

On the one hand, this should not be big news as it is very easy to create an Amazon EC2 Windows-based server and install SplendidCRM.  The news is big because we are running fully on Microsoft's new Azure cloud service.  The database is being run off of Azure SQL and the web application has been deployed to Azure Windows.
The effort was reasonable and would have been negligible had we not used SQL Server techniques that have been deprecated for years.  This is important because Azure SQL does not support any of the SQL Server deprecated features.  Still, the process was not that difficult, we simply replaced code that used dbo.sysobject to determine if an object already exists with code that uses the cross-platform view INFORMATION_SCHEMA.
If you would like to experiment for yourself, please visit:
Login: will
Password: will