• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

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?

1 Solution
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
Sorry I've wanted it like comment
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?
Did you close the database before trying to backup?
What Database is it?
Victor SpiridonovCommented:
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.
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.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now