May 7, 2014 at 11:55 am
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.
May 7, 2014 at 12:40 pm
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 7, 2014 at 1:04 pm
Thanks for reply,
How much time will it take to complete the upgrade..?
What are the precautions need to take before upgrade.?
May 7, 2014 at 2:36 pm
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 7, 2014 at 2:51 pm
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.
😎
May 8, 2014 at 3:59 am
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.
May 8, 2014 at 4:14 am
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.
May 8, 2014 at 6:03 am
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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply