Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need to upgrade SQL Server 2012 Standard edition to Enterprise edition. Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2014 11:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:20 AM
Points: 273, Visits: 991
Hi,

we need to upgrade from a SQL Server 2012 Standard installation to SQL Server 2012 Enterprise installation.


Is it Possibility to upgrade our current version(SE) to the enterprise edition?

Many Thanks,
Your help is Much appreciated.










Post #1568630
Posted Wednesday, May 7, 2014 12:40 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:38 AM
Points: 13,755, Visits: 28,147
Yes, you can upgrade from Standard to Enterprise. You just have to purchase an Enterprise license and then install the correct software.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1568653
Posted Wednesday, May 7, 2014 1:04 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 21, 2014 5:20 AM
Points: 273, Visits: 991
Thanks for reply,

How much time will it take to complete the upgrade..?
What are the precautions need to take before upgrade.?

Post #1568662
Posted Wednesday, May 7, 2014 2:36 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:38 AM
Points: 13,755, Visits: 28,147
The time it takes really depends on the system you're installing it to, the stuff you choose to install, the size of your databases, a ton of stuff that I couldn't possibly quantify for you. Best thing to do is test it out. As for precautions, make darned sure you have backups in place and that you know how to run a restore. Also make sure you have the original media so you can reinstall if needed. But that's the same thing you should have before you do patching or anything else like that.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1568692
Posted Wednesday, May 7, 2014 2:51 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 9:58 AM
Points: 1,901, Visits: 5,228
If I remember correctly, you'll have an upgrade grace period, you could install a new instance on the/a box, run the two in parallel for that period while migrating the data from the old to the new. Better check with Microsoft first though.
Post #1568697
Posted Thursday, May 8, 2014 3:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 18, 2014 4:14 AM
Points: 277, Visits: 841
Eirikur Eiriksson (5/7/2014)
If I remember correctly, you'll have an upgrade grace period, you could install a new instance on the/a box, run the two in parallel for that period while migrating the data from the old to the new. Better check with Microsoft first though.


In place upgrades from standard to enterprise work just fine, no need for the two side by side. But that obviously depends on the confidence in your self of being able to rectify it if the upgrade goes tits up.

Personally.. I would back up all of the databases, export all SSIS packages if there are any saved, script out all of the users etc. You could run a server backup just incase for added security, run the in place upgrade and test.
Post #1568809
Posted Thursday, May 8, 2014 4:14 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:20 AM
Points: 64, Visits: 480
If you are not going to restore system database make sure you record the sql server logins (windows and sql authentication) and their permissions, as these will need to be reinstated. Make sure you know the passwords for the sql authentication logins. SQL jobs will need to be recreated, so script them out and save the script. record the server properties that are currently set so you know what the memory configurations etc are.

Snapshot the machine if it is virtual before you do anything.
Post #1568813
Posted Thursday, May 8, 2014 6:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:38 AM
Points: 13,755, Visits: 28,147
And all this advice just points out how difficult it is to provide a good answer to such vague & general questions.

I hope all this helps. You've received great pointers.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1568844
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse