Solved

how to copy a database from one computer to another?

Posted on 1998-09-17
5
170 Views
Last Modified: 2010-08-05
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
Comment
Question by:adamy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 2

Expert Comment

by:odessa
ID: 1090135
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
 
LVL 2

Expert Comment

by:odessa
ID: 1090136
Sorry I've wanted it like comment
0
 
LVL 1

Author Comment

by:adamy
ID: 1090137
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
 
LVL 3

Expert Comment

by:a111a111a111
ID: 1090138
Did you close the database before trying to backup?
What Database is it?
0
 
LVL 7

Accepted Solution

by:
spiridonov earned 50 total points
ID: 1090139
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
[Unsupported] SQL Update in CRM 2011 Database 19 59
SQL Server how to create a DYNAMIC TABLE? 11 46
Select Sum query with group by 8 42
SQL Job Failed 6 26
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question