Migrate/Upgrade from Standard to Enterprise

Question

Migrate/Upgrade from Standard to Enterprise

SQLisAwe5oMe

SSChampion

Points: 14052
More actions
August 7, 2012 at 8:39 pm

#265562

Hi All, Please help/share your experience.
Here are my requirements.
Current Environment
SQL Server 2008 R2
Development environment
2 node Active/Passive cluster, Currently in standard edition
Need to upgrade to SQL 2008 R2 Enterprise Edition
What are some of the requirements/precautions that I need to go through each server/instances before I upgrade.....and what's the proper way of upgrading to enterprise edition.
Thanks in advance,
SueTons
Regards,
SQLisAwe5oMe.

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

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

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 1

SQLCrazyCertified (8/7/2012)
Hi All, Please help/share your experience.
Here are my requirements.
Current Environment
SQL Server 2008 R2
Development environment
2 node Active/Passive cluster, Currently in standard edition
Need to upgrade to SQL 2008 R2 Enterprise Edition
What are some of the requirements/precautions that I need to go through each server/instances before I upgrade.....and what's the proper way of upgrading to enterprise edition.
Thanks in advance,
SueTons

If its a development environment why are you using standard edition instead of developer edition?

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 2

MysteryJimbo (8/8/2012)
SQLCrazyCertified (8/7/2012)
Hi All, Please help/share your experience.
Here are my requirements.
Current Environment
SQL Server 2008 R2
Development environment
2 node Active/Passive cluster, Currently in standard edition
Need to upgrade to SQL 2008 R2 Enterprise Edition
What are some of the requirements/precautions that I need to go through each server/instances before I upgrade.....and what's the proper way of upgrading to enterprise edition.
Thanks in advance,
SueTons
If its a development environment why are you using standard edition instead of developer edition?

Since its on cluster, I believe developer edition won't work.

Regards,

SueTons

Regards,
SQLisAwe5oMe.

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 3

Developer edition has all of the same functionality as Enterprise edition. That includes clustering.

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 4

MysteryJimbo (8/8/2012)
Developer edition has all of the same functionality as Enterprise edition. That includes clustering.

Planning to move to production, and might add more nodes in future.

Regards,

SueTons.

Regards,
SQLisAwe5oMe.

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 5

SQLCrazyCertified (8/8/2012)
MysteryJimbo (8/8/2012)
Developer edition has all of the same functionality as Enterprise edition. That includes clustering.
Planning to move to production, and might add more nodes in future.
Regards,
SueTons.

Someone please advise as to what are steps involved in the upgrade process in clusters.

Thnx,

SueTons.

Regards,
SQLisAwe5oMe.

saidapurs Hall of Fame Points: 3477 More actions · Answer 6

Hi SueTon,

Please put SQL SERVER 2008R2 Enterprise edition DVD & give install after you will get MAINTENANCE option in their you will get option like UPGRADE EDITION click, it will pass a test if any issue you will get all details...

Hope it will work for you...

Thanks

Satish

Mohammedr_mcts SSC Veteran Points: 262 More actions · Answer 7

Hi,

Could you be please more specific on the query.

Are you planning for upgrading from SQL SERVER 2008R2 DEVELOPER EDITION TO SQL SERVER 2008 R2 ENTERPRISE EDITION..?

Thanks,

Mohammed.

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 8

saidapurs (8/9/2012)
Hi SueTon,
Please put SQL SERVER 2008R2 Enterprise edition DVD & give install after you will get MAINTENANCE option in their you will get option like UPGRADE EDITION click, it will pass a test if any issue you will get all details...
Hope it will work for you...
Thanks
Satish

Do I do this in the active/passive node first?

Thanks,

SueTons.

Regards,
SQLisAwe5oMe.

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 9

Mohammedr_mcts (8/9/2012)
Hi,
Could you be please more specific on the query.
Are you planning for upgrading from SQL SERVER 2008R2 DEVELOPER EDITION TO SQL SERVER 2008 R2 ENTERPRISE EDITION..?
Thanks,
Mohammed.

Nope, I am upgrading from SQL server 2008r2 standard to SQL server 2008 r2 enterprise edition. I did mentioned that in the original post didn't I.

Thanks,

SueTons.

Regards,
SQLisAwe5oMe.

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 10

SQLCrazyCertified (8/9/2012)
saidapurs (8/9/2012)
Hi SueTon,
Please put SQL SERVER 2008R2 Enterprise edition DVD & give install after you will get MAINTENANCE option in their you will get option like UPGRADE EDITION click, it will pass a test if any issue you will get all details...
Hope it will work for you...
Thanks
Satish
Do I do this in the active/passive node first?
Thanks,
SueTons.

Edition change is very similar to a service pack, so the same procedure applies.

Patch the passive node(s) first (ensure you disable failover first).

Failover, patch the active node.

Check your patch level as you may need to reapply service packs. I haven't don't this in a while so I cant remember.

In theory there's nothing to stop you failing over between versions whilst there are no enterprise features in use. It should be possible as the databases themselves will already be at the correct versions.

saidapurs Hall of Fame Points: 3477 More actions · Answer 11

Hi Suo,

Ru upgrading the version or updating patch. When you updating patch on that time update 1st node then 2nd node but as per above discussion you are upgrading the Version..

thanks

Satish

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 12

saidapurs (8/9/2012)
Hi Suo,
Ru upgrading the version or updating patch. When you updating patch on that time update 1st node then 2nd node but as per above discussion you are upgrading the Version..
thanks
Satish

No, I am not upgrading the versions.....I am upgrading the edition from Standard to Enterprise.

Here is something that I found on MSDN

"SQL Server in a clustered environment: You just need to run edition upgrade on a single node, you can choose to run from either an active or passive node. After running, you need to cause a failover to happen. Once the failover happens, all of the nodes along with the database engine will be updated."

Regards,
SQLisAwe5oMe.

saidapurs Hall of Fame Points: 3477 More actions · Answer 13

Hi Sue,

First test it in Test environment because should be apply for Nodes only because In NODE1 & NODE2 store SQL Components & SAN store the DB.

I agree with other comments also....

Please do in test environment & update the status...

Thanks

Satish

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 14

SQLCrazyCertified (8/9/2012)
"SQL Server in a clustered environment: You just need to run edition upgrade on a single node, you can choose to run from either an active or passive node. After running, you need to cause a failover to happen. Once the failover happens, all of the nodes along with the database engine will be updated."

Basically it means the enterprise features will be enabled after a failover to an upgraded node. There will be no engine changes