DNN 6.0 upgrade package fix available for Azure

SQLAzure_200When 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:

Upgrading from 05.06.03 to 06.00.00 on Azure

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:

Hope this helps,

David Rodriguez

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *