Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-04 : 11:34:34
|
| Bob writes "We have a set of large 6.5 databases that need to be upgraded to 2000. The upgrade process includes this step:"Copy production data from the old server by running the SQL Server Upgrade Wizard on the new (MSSQL 2000) server. Select the old (MSSQL 6.5) server as the ‘Export Server’, exclude all databases other than the ICMS v2 database, and deselect all options under ‘System objects to transfer’."SQL scripts are then run on the 2000 server to restructure the old data, using temporary tables, which are then copied into the new tables.When running the final upgrade script, we get problems like this on several of the operations:Server: Msg 446, Level 16, State 9, Line 3Cannot resolve collation conflict for equal to operation.Server: Msg 457, Level 16, State 1, Line 1Implicit conversion of varchar value to varchar cannot be performed because the collation of the value is unresolved due to a collation conflict.Any ideas on how best to avoid or workaround this sort of problem?Best regards,Bob Clarki2N, Colchester, UK" |
|
|
|
|
|
|
|
SQL Server 6.5 to 2000 Upgrade - Collation problems