One-computer or Two-computer upgrade?? 
Author Message
 One-computer or Two-computer upgrade??
Dear all,
We are going to upgrade our SQL 6.5 servers to 7.0.  We have 4 servers and
all of them are participating in replication.  We also wish to take this
opportunity to upgrade our SQL servers to newer machines.

Should I use one-computer or two-computer upgrade?  What are the pros and
cons?

I have actually gone though the white paper from Microsoft Web site but I
didn't get much idea to make decision on the one-computer or two-computer
approach.  Can someone share me your experience?

Many Thanks!!



Mon, 03 Feb 2003 03:00:00 GMT
 One-computer or Two-computer upgrade??

Dick,

We, like you, worked with new servers for our upgrade. We designated a
server to have both 6.5 and 7.0 on it and used that to migrate databases.
This was our method:-

1 ) - Backup the database on the 6.5 server
2 ) - Copy the backup to the conversion server
3 ) - Restore the backup
4 ) - Create the 7.0 database files from a script on the conversion server
5 ) - Convert the database to the already created 7.0 database files on the
conversion server
6 ) - Backup the database (under 7.0) on the conversion server
7 ) - Copy the backup to the new 7.0 server
8 ) - Restore the backup

Pros
Always had the original database available on a server
Migration problems handled on a conversion server not the actual Production
server
Not having to worry about having two versions of SQL on the Production
server
Able to migrate applications when they were ready rather than a whole server
at a time

Cons
We did not copy the job and user info over so we had to re-create this on
the 7.0 server
Applications had to change the name of the server where there apps resided.
Had to have a spare server available that was tied up with the migrations
for some time as we did not move all applications at the same time

Hope this helps

Chris Wood
Alberta Department of Resource Development
CANADA


Quote:
> Dear all,
> We are going to upgrade our SQL 6.5 servers to 7.0.  We have 4 servers and
> all of them are participating in replication.  We also wish to take this
> opportunity to upgrade our SQL servers to newer machines.

> Should I use one-computer or two-computer upgrade?  What are the pros and
> cons?

> I have actually gone though the white paper from Microsoft Web site but I
> didn't get much idea to make decision on the one-computer or two-computer
> approach.  Can someone share me your experience?

> Many Thanks!!



Mon, 03 Feb 2003 03:00:00 GMT
 One-computer or Two-computer upgrade??
Chris,

Thanks!!
It is the first time I heard that using the 3rd server as the conversion
server.
One question:  Did you use the SQL upgrade wizard in your step 5?
I don't think we will use this approach because we want to upgrade the whole
server to run on SQL 7.  But, thanks for sharing your experience!!

Dick


Quote:
>{*filter*},

> We, like you, worked with new servers for our upgrade. We designated a
> server to have both 6.5 and 7.0 on it and used that to migrate databases.
> This was our method:-

> 1 ) - Backup the database on the 6.5 server
> 2 ) - Copy the backup to the conversion server
> 3 ) - Restore the backup
> 4 ) - Create the 7.0 database files from a script on the conversion server
> 5 ) - Convert the database to the already created 7.0 database files on
the
> conversion server
> 6 ) - Backup the database (under 7.0) on the conversion server
> 7 ) - Copy the backup to the new 7.0 server
> 8 ) - Restore the backup

> Pros
> Always had the original database available on a server
> Migration problems handled on a conversion server not the actual
Production
> server
> Not having to worry about having two versions of SQL on the Production
> server
> Able to migrate applications when they were ready rather than a whole
server
> at a time

> Cons
> We did not copy the job and user info over so we had to re-create this on
> the 7.0 server
> Applications had to change the name of the server where there apps
resided.
> Had to have a spare server available that was tied up with the migrations
> for some time as we did not move all applications at the same time

> Hope this helps

> Chris Wood
> Alberta Department of Resource Development
> CANADA



> > Dear all,
> > We are going to upgrade our SQL 6.5 servers to 7.0.  We have 4 servers
and
> > all of them are participating in replication.  We also wish to take this
> > opportunity to upgrade our SQL servers to newer machines.

> > Should I use one-computer or two-computer upgrade?  What are the pros
and
> > cons?

> > I have actually gone though the white paper from Microsoft Web site but
I
> > didn't get much idea to make decision on the one-computer or
two-computer
> > approach.  Can someone share me your experience?

> > Many Thanks!!



Wed, 05 Feb 2003 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Computer-to-Computer Upgrade problems

2. Computer-To-Computer Upgrade

3. SQL Server 6.5 to 7.0 Database Upgrade - Computer to Computer

4. two-computer upgrade 6.5 to 7.0

5. Two computer upgrade

6. two-computer upgrade 6.5 ->7.0

7. two computers running slow, one is just perfect

8. For one login,i want one computer to log

9. transfering database from one computer another one

10. How to retrieve a computer name and user name of a computer

11. http://half-price.computer-books.com - discount computer books, free shipping to NA

12. File and/or folder transer, computer to computer


 
Powered by phpBB® Forum Software