August 3, 2016 at 4:25 pm
Hi All - As the title suggests. We're currently running 2008 Enterprise and need to upgrade to 2012 Standard (which we've already obtained a license for).
Since the upgrade path is unsupported, what is the cleanest and most efficient way to do the upgrade?
Just install an new instance of 2012 and use the Import/Export wizard to move the databases/tables from the 2008 instance to the new 2012 instance?
Are there any risks with this?
ANY help is appreciated!
August 4, 2016 at 12:17 am
Depending on your maintenance window, best option may be a fresh install of the new server, script transferrable logins, detach and copy the databases, attach on the new instance and change connections' configurations. This way you'll have a fallback to the previous instance if anything goes wrong.
😎
August 4, 2016 at 2:51 am
You might have problems restoring / migrating to Standard edition if you're using Enterprise Edition features in your databases.
Check sys.dm_db_persisted_sku_features DMV to see if you are.
Thomas Rushton
blog: https://thelonedba.wordpress.com
August 4, 2016 at 3:02 am
ThomasRushton (8/4/2016)
You might have problems restoring / migrating to Standard edition if you're using Enterprise Edition features in your databases.Check sys.dm_db_persisted_sku_features DMV to see if you are.
Good point Thomas;-)
😎
August 12, 2016 at 4:59 pm
Thanks for all your feedback.
So If I install a new instance of 2012 Standard on the same machine, it's NOT going to affect ANY aspect of existing 2008 Enterprise instance, correct?
August 13, 2016 at 1:35 am
DAP 93723 (8/12/2016)
Thanks for all your feedback.So If I install a new instance of 2012 Standard on the same machine, it's NOT going to affect ANY aspect of existing 2008 Enterprise instance, correct?
That is correct but mind you that this has to be a named instance if the 2008 instance is the default one.
😎
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply