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
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1539 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 Guru
SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)

Group: General Forum Members
Points: 117534 Visits: 33074
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
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1539 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 Guru
SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)

Group: General Forum Members
Points: 117534 Visits: 33074
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
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: General Forum Members
Points: 49780 Visits: 19612
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
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2160 Visits: 1297
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
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1307 Visits: 856
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 Guru
SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)SSC Guru (117K reputation)

Group: General Forum Members
Points: 117534 Visits: 33074
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