how to copy a database from one computer to another?

I want to copy a database from one computer to another computer,I use Database Backup/Restore tool to backup it  to a diskette, in another computer I use Database Backup/Restore tool to restore it,but it displays the following error:
"The database you are attempting to load was dumped under a different sort order ID(199) than the one currently running on this server and at least one of them is a non-binary sort order."
How can I do that?

LVL 1
adamyAsked:
Who is Participating?
 
Victor SpiridonovConnect With a Mentor Commented:
You do not need to close the database to do a backup. If your computers are on the same network you can use Database/Object Transfer utility in SQL Enterprise Manager.
Or you can generate a script of the database schema, use the script to create a new database on another computer and then bcp data out and in.

Odessa:> with backuping you can't doit unless you use different sort orders
The other way around you MUST have the same sort order to be able to load the database.
0
 
odessaCommented:
Sorry with backuping you can't doit unless you use different sort orders, if your computers are connected via Network you can use, DataBase Transfer
0
 
odessaCommented:
Sorry I've wanted it like comment
0
 
adamyAuthor Commented:
If I transfer it via network,How can I do?
If I use a diskette to copy it,How can I do?
Can you tell me detailedly?
0
 
a111a111a111Commented:
Did you close the database before trying to backup?
What Database is it?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.