SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Need to upgrade SQL Server 2012 Standard edition to Enterprise edition.


Need to upgrade SQL Server 2012 Standard edition to Enterprise edition.

Author
Message
bala2
bala2
Mr or Mrs. 500
Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)

Group: General Forum Members
Points: 529 Visits: 1046
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.
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41161 Visits: 32666
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
bala2
bala2
Mr or Mrs. 500
Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)

Group: General Forum Members
Points: 529 Visits: 1046
Thanks for reply,

How much time will it take to complete the upgrade..?
What are the precautions need to take before upgrade.?
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41161 Visits: 32666
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Eirikur Eiriksson
Eirikur Eiriksson
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15438 Visits: 18622
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.
Cool
SQLAssAS
SQLAssAS
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 1222
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.
Cool


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.
cunningham
cunningham
SSC-Addicted
SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)SSC-Addicted (405 reputation)

Group: General Forum Members
Points: 405 Visits: 854
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.
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41161 Visits: 32666
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search