SQL Server 2005 - 2008 upgrade question

Question

SQL Server 2005 - 2008 upgrade question

DaveDB

SSCrazy

Points: 2173
More actions
October 4, 2013 at 7:00 am

#278697

Hello,
This is kind of a basic question, but I'll ask anyway lest I look bad in front of my boss....
I have to upgrade a 2005 SQL box to 2008. I have the SQL CD, but I have to install it from my local PC. Is there a way to run the install process from a local PC but actually install SQL on a remote box using the CD?
Thanks in advance,
Dave

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

jasona.work SSC Guru Points: 50117 More actions · Answer 1

If you can, and if there's room on the remote box, just copy the entire CD to a folder on the SQL box, and run setup from there.

That's essentially what I have to do here, except they've already copied the install media for SQL to a network share.

If you can't even copy the SQL media to the remote server, you'll need to get creative. Ship the media to the remote site and have someone put it in the drive / copy it to the server, zip and upload to an FTP site or such then download it to the server, etc.

SQLAssAS SSCertifiable Points: 7246 More actions · Answer 2

DaveDB (10/4/2013)
Hello,
This is kind of a basic question, but I'll ask anyway lest I look bad in front of my boss....
I have to upgrade a 2005 SQL box to 2008. I have the SQL CD, but I have to install it from my local PC. Is there a way to run the install process from a local PC but actually install SQL on a remote box using the CD?
Thanks in advance,
Dave

Create a folder on your local PC, copy the software into the folder

When you remote desktop onto the server, click on Local Resources, under Local devices\resouces click more, and click the drive your folder is on with your software. This will take the drive with you onto the box and you should be able to run it from there.

If you dont have the capacity on the box just for the software though thats a worry lol

WilburBud SSCrazy Points: 2914 More actions · Answer 3

You can share the CD from your PC and attach it as a network drive on the server. It does run a bit slow over a network but I have done it a few times. When we need to install/upgrade multiple times in the same remote data center we get an ISO in the datacenter and mount it to servers as we need it.

jasona.work SSC Guru Points: 50117 More actions · Answer 4

SQLSteve (10/4/2013)
DaveDB (10/4/2013)
Hello,
This is kind of a basic question, but I'll ask anyway lest I look bad in front of my boss....
I have to upgrade a 2005 SQL box to 2008. I have the SQL CD, but I have to install it from my local PC. Is there a way to run the install process from a local PC but actually install SQL on a remote box using the CD?
Thanks in advance,
Dave
Create a folder on your local PC, copy the software into the folder
When you remote desktop onto the server, click on Local Resources, under Local devices\resouces click more, and click the drive your folder is on with your software. This will take the drive with you onto the box and you should be able to run it from there.
If you dont have the capacity on the box just for the software though thats a worry lol

The biggest issue with doing something like that, though, is it's going to be slow or worse, depending on the connection. If the two boxes (his desktop and the server) are on the same network, with a 1GBps connection? Just slow. If the server is really remote, such that he's going over an internet connection? I wouldn't even try.

Plus, it's possible that there may be policies in place that prevent the drive mapping (such as where I work, can't even transfer the clipboard...)