Transfering database-file and different sort order

• Bengt

  Mr or Mrs. 500

  Points: 569

  More actions

  January 30, 2002 at 11:33 am

  #157547

  I want to transfer a database (*.mdf and *.ldf) from one server to another. When I detached the original files and the tried to attach the new ones I got the error message:

  "Could not attach the database because the character set, sort order, or Unicode collation for the database differs from this server."

  So how can I transfer a database form one server to another it the two servers use differnet sort orders etc?

  Bengt

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  January 30, 2002 at 12:29 pm

  #422885

  In SQL 2000, create the db first with the correct collation. Then detach, copy over and attach.

  Steve Jones

  steve@dkranch.net