Hi all

I have been using DNN since the iBuySpy portal and it has served me well over the years.

I currently have 4 instances, all with multiple portals.

In December, I migrated them from a datacentre hosting them on a local SQL server to Windows Azure. and until now I have had only minor issues.

The migration was performed by using the SQL database migration wizard from codeplex to move the databases up. copying up my source directories, changing the web.config connection strings and it all worked great.

at the time of migration, I had 1 instance on 7.1.something and 3 instances on 6.2.2. All of these instances were created in somewhere around DNN v3 and upgraded all the way till now.

Last week, I upgraded the 7.1.x instance and the first of the 6.2.2 instances with no issues. This weekend, I started an upgrade of the other 2 instances and have hit problems which are beyond my TSQL skills.

the error I am getting is:

Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.

This error occurs while running the 6.2.3 upgrade script (at least).

if I run the upgrade script manually, it completes with no errors.

I would appreciate any assistance anyone can provide

thanks

as Sebastian suggests the problem is the database has different collations for certain objects/columns and that sql server does not like queries which contain data from different collations. At a guess your migration wizard set some column with a different collation (AFAIR azure does not allow database or table collations to be set), so you will have to ensure that the column has it's collation cleared/changes to the database default.

---

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US