October 6, 2017 at 4:29 am
Hi
I am involved in a project of server migration which needs moving from SQL 2005 (Enterprise Edition - 64 bit - SP2) to SQL 2012 Standard edition. However this link below suggest it may not be possible to upgrade from Enterprise to Standard. Is there any solution for this issue except buying enterprise 2012 licence?
https://technet.microsoft.com/en-us/library/ms143393(v=sql.110).aspx
Also regarding upgrade i am trying to gather as much information as i can to plan this without any issue and found this link below with various scripts.
http://www.sqlservercentral.com/scripts/Database+Migration/121942/
Is there any other resource regarding upgrade which could be useful? We also need to move SSRS Reports, SSAS cubes & SSIS packages.
Thanks
October 6, 2017 at 4:37 am
Instead of doing an in-place upgrade, why not build your SQL Server 2012 server and then restore the databases from the old server on to it? You can script out stuff like logins and jobs. You then won't have the issue of not being able to move from Enterprise to Standard, unless, that is, your databases already use any features that are not available in Standard Edition.
Can I ask why you're only upgrading to 2012, by the way? There have been three major releases since that version.
John
October 6, 2017 at 4:42 am
Hi John
Thanks for your help. We will be doing side by side migration which means parallel running for a while before we take databases offline on old server and eventually decommission. I think i misunderstood this table on Microsoft website which refers to in-place upgrade. I will be running upgrade advisor 2012 to ensure we are covered for any functionality missing from enterprise to standard.
Regarding 2012 i came into this very late and organisation made the decision to buy 2012 about a year ago and everything was set up. However migration never happened and now it is priority.
Thanks
October 6, 2017 at 4:48 am
As far as I remember, Upgrade Advisor only highlights issues that may be encountered in upgrading from one version to a higher one. It doesn't help when changing from one edition to another (Standard to Enterprise or vice versa). You may have to do this analysis manually. Determine what, if any, Enterprise-only features you are currently using in SQL Server 2005, whether they are still Enterprise-only in SQL Server 2012, and if so, whether you can do without them.
John
October 6, 2017 at 10:36 am
John Mitchell-245523 - Friday, October 6, 2017 4:48 AMAs far as I remember, Upgrade Advisor only highlights issues that may be encountered in upgrading from one version to a higher one. It doesn't help when changing from one edition to another (Standard to Enterprise or vice versa). You may have to do this analysis manually. Determine what, if any, Enterprise-only features you are currently using in SQL Server 2005, whether they are still Enterprise-only in SQL Server 2012, and if so, whether you can do without them.John
And be aware that using data driven subscriptions in SSRS is one of those Enterprise only features from SQL 2005. I don't know if that has changed.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 6, 2017 at 11:31 am
dva2007 - Friday, October 6, 2017 4:42 AMRegarding 2012 i came into this very late and organisation made the decision to buy 2012 about a year ago and everything was set up. However migration never happened and now it is priority.
Keep in mind that 2012 is out of support. That can be important to some companies, so raise it and make sure that people are aware.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2017 at 10:54 am
Please also be aware that most likely you will need to restore and backup this database in a SQL 2008 / 2008 R2 environment before migrating to SQL 2012. Thanks
October 17, 2017 at 1:19 pm
John.Garvey - Tuesday, October 17, 2017 10:54 AMPlease also be aware that most likely you will need to restore and backup this database in a SQL 2008 / 2008 R2 environment before migrating to SQL 2012. Thanks
Nope.
https://www.sqlskills.com/blogs/paul/you-can-upgrade-from-any-version-2005-to-any-other-version/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply