Solved

restore and upgrade SQL server from 6.5 to 7.0

Posted on 2004-08-04
7
578 Views
Last Modified: 2011-10-03
I am wanting to restore a DB from a dump from a SQL 6.5 server to a test SQL 6.5 server  then I will upgrade the SQL 6.5 server to a SQL 7. so that we can more easily migrate our data without potentially harming our data in our 6.5 db.  when trying to restore the DB I run into the following error.

The database you are attempting to load was dumped under a different sort order ID (42) than the one currently running on this server(52) and at least one of them is a non-binary sort order.

Yeah that pretty much does it. If there is a smarter way to do this I am totally up for it.
0
Comment
Question by:mannyinsj
  • 2
  • 2
7 Comments
 
LVL 4

Expert Comment

by:SurferJoe
ID: 11721600
The way I have done this before is to;
1)      Create a full backup of the source database.
2)      Create a database by the same name on the target server and perform a full backup.
3)      Overwrite the target backup with the source backup.
4)      Restore the source backup to the target machine.

It’s sort of tacky but it typically works. I have even done this with different versions of SQL Server.
0
 
LVL 1

Author Comment

by:mannyinsj
ID: 11721681
yeah I think the problem was that that the sort order was different. we just tried reinstalling the the SQL 6.5 software and found that we could change the sort order and the code pages chosen. Waiting for master to regenerate.  So now if anyone has a good idea how to upgrade a 6.5 db to a 7.0 other than the process I am already undergoing I would appreciate hearing it.
0
 
LVL 4

Accepted Solution

by:
SurferJoe earned 250 total points
ID: 11721867
0
 
LVL 34

Expert Comment

by:arbert
ID: 11722096
In 6.5 You CAN'T restore the database unless the sortorder is the same.  You'll have to change the sort order and then restore...
0
 
LVL 34

Assisted Solution

by:arbert
arbert earned 250 total points
ID: 11722106
Sorry, see you figured that out.  The upgrade from 6.5 to 7.0 totally changes your database server (no way around it).  So, make sure you have a backup to fall back to if needed.  This is about the only option you have.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now