Transfering database-file and different sort order

  • 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

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

    Steve Jones

    steve@dkranch.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply