Need to move DB to new SQL which has different collation - Collation issue
Article ID: 100026941
Updated On:
Description
Error Message
Cannot resolve collation conflict for equal to operation
Cause
If you move SQL servers, the collation of the new SQL servers Instance must be confirmed and the EV Database collation should be changed. Run the Deployment scanner, it will check the Collation of all DB's when it runs and if there is a discrepency it will cause the previously mentioned error.
Resolution
Change Collation after moving Databases to Destination Server independant of the Collation.
This will be done on All EV databases in accordance to the Related Documentation.
Applies To
SQL 2005
SQL 2008 R2
EV 10
Issue/Introduction
How to move EV Databases to a new SQL server which has different collations.
Was this article helpful?
Yes
No
Powered by
