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

x
  • 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?

0
adamy
Asked:
adamy
1 Solution
 
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
 
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.
0

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