Uprading from Entiprize 2005 to Developer 2008/R2

Question

Post reply

Uprading from Entiprize 2005 to Developer 2008/R2

OomBoom

Hall of Fame

Points: 3481
More actions
January 25, 2011 at 5:47 am

#232632

Hi
I need a way to upgrade a SQL 2005 entiprize server to a SQL 2008 R2 developer edition. According to MS upgrade paths this is not possible in the conventional way.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Viewing 15 posts - 1 through 14 (of 14 total)

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

steveb. SSC-Forever Points: 46733 More actions · Answer 1

you could create a new database on the 2008 DE and then use SSIS to transfer all the objects across.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

steveb. (1/25/2011)
you could create a new database on the 2008 DE and then use SSIS to transfer all the objects across.

No need. Backup/restore works from 2005-> 2008 R2. It's the other way around that it doesn't work.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

OomBoom Hall of Fame Points: 3481 More actions · Answer 3

Hi

The problem is not the databases it is the actual users, operators ......

Is it possible to restore the system databases in 2008 r2?

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

I would strongly recommend not trying to move system databases up-version.

Script out logins (with SIDs), linked servers, operators, alerts, etc

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

steveb. SSC-Forever Points: 46733 More actions · Answer 5

steveb. (1/25/2011)
you could create a new database on the 2008 DE and then use SSIS to transfer all the objects across.

I thought that going from Enterprise to Dev would causes problems, but i guess they are essentially the same versions..

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

The only real difference between enterprise and developer is in the licensing. Restoring down the editions (Enterprise-standard for eg) is possible as long as enterprise-specific features haven't been used.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

OomBoom (1/25/2011)
The problem is not the databases it is the actual users, operators .....

p.s.Significant logins and operators on a development server?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

OomBoom Hall of Fame Points: 3481 More actions · Answer 8

Thanks for the replies. I will do it the MS way then. I just hoped there was an easier way as there is alot of server I need to upgrade.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

Significant numbers of development servers?

Remember you cannot use Developer edition on a production server. It's licensed for development usage.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

OomBoom Hall of Fame Points: 3481 More actions · Answer 10

I have 13 dev server that needs to be loaded with dev version as the previous installs was done with full versions.

Users on the boxes have old undocumented processes that they do not have passwords for anymore. Alot of hard coding in this enviroment so one incorrect password can spell disaster.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 11

You can script out logins with their passwords, you don't need to know what they are. I've seen a fair few login migration scrips, or you can use SSIS's transfer login task.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

OomBoom Hall of Fame Points: 3481 More actions · Answer 12

Thanks. I will try some of the scripts. Any suggestions?

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 13

Google?

I don't have any handy.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

OomBoom Hall of Fame Points: 3481 More actions · Answer 14

Thanks for the help.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Do not reinvent the wheel.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>