January 19, 2014 at 10:56 pm
Good Day SQL gurus
What would be the best way to upgrade from SQL 2012 Standard to SQL 2012 Enterprise edition.
I currently have replication running on the sever.
January 20, 2014 at 6:21 am
launch the installation media and in the installation centre there is an option to upgrade the SQL Server edition. Should be fairly painless to complete
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2014 at 6:48 am
Will any settings of mine be lost, Like replication during the version upgrade
January 20, 2014 at 11:29 am
I wouldn't have thought so if you're smart you'll take backups before you begin.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2014 at 6:01 pm
...
January 20, 2014 at 11:35 pm
Thanks for the reminder, but will definitely start with backups first...
one more thing do you think the window for downtime will be large or the version upgrade will be quick as I assume just additional updates will be installed to upgrade it to Enterprise
January 20, 2014 at 11:42 pm
Sorry I'm not sure I understand you. It will be just a version upgrade of SQL 2012 Standard to SQL 2012 Enterprise I don't think any migration is required. It's going to be on the exact same instance.
(SQL Analysis Service) BI Semantic Model (Tabular), Data Compression, DB Sync
January 20, 2014 at 11:43 pm
I believe it is a fairly quick operation based on another users experience of this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 20, 2014 at 11:46 pm
Thanks a lot mate
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply