Usually, the sort order and character set of two servers must match to backup
on one server and restore on the other. An exception is when both servers use
a binary sort order; then, the character sets can differ.
When the code page or sort order differs, use the bcp utility or
Data Transformation Services to move the data.