We are upgrading from EV 9.0.4 on server 2003 32-bit to EV 10.0.4 on server 2012 R2 64-bit. We will be using the same SQL server 2008 R2. In running the deployment scanner it came up with a mixed collation on the EVDashboard Database. I have come across a number of documents each with a different method. Tech doc from Symantec TECH55063 I was given as a fix but it is only used to identify mixed collations. Does anyone have some helpful information as to a method that will go through the database and change the collation on all the existing information to match the default collation of SQL_Latin1_General_CP1_CI_AS.
Solved! Go to Solution.
Thanks for that input, a great weight has just been lifted from me. The procedure for change a DB collation has a lot of steps. The DB has been there ever since I can remember. Do not know who installed it. Once again many thanks to all.