Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • 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.

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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