DNN 6.0 upgrade package fix available for Azure

When trying to upgrade a DotNetNuke instance from 05.06.03 to 06.00.00 on Windows Azure using the official distribution upgrade package, you will encounter the following error:

A detailed view of these erros can be found at http://dnnazureaccelerator.codeplex.com/releases/view/71164#DownloadId=266857

The summary of SQL Azure incompatible issues are:

Stored Procedure “GetFile”	Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
Stored Procedure “GetFileById”	Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
Stored Procedure “GetAllFiles”	Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
Stored Procedure “GetFiles”	Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
Creating PK on “PortalLocalization”	Table 'PortalLocalization' already has a primary key defined on it.
Stored Procedure “GetVendorsByEmail”	Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.
Stored Procedure “GetBanner”	Deprecated feature 'String literals as column aliases' is not supported in this version of SQL Server.

You can follow one of these solutions:

• Use the fixed upgrade package instead the official package, that is available for download at http://dnnazureaccelerator.codeplex.com/releases/view/71164#DownloadId=266856
• Apply the following T-SQL script fix after the official upgrade package has been applied

Hope this helps,
David Rodriguez