December 19, 2016 at 2:43 am
I'm trying to upgrade from SQL 2005 to SQL 2014. I wanted to know is it a 2 step process or not.
If it is a 2 step process what are the steps..
Please help on this
December 19, 2016 at 2:45 am
In-place upgrade (not recommended) or side-by-side/new server?
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
December 19, 2016 at 2:47 am
You'll probably want an OS upgrade too- I'd avoid doing an in-place upgrade, as already mentioned.
December 19, 2016 at 2:52 am
Hi,
Check the Upgrade-List table in this link https://msdn.microsoft.com/en-us/library/ms143393(v=sql.120).aspx
I'd also skip in-place upgrade and do it with a new installation of SQL Server 2104.
Do you still need the same instance name?
Igor Micev,
My blog: www.igormicev.com
December 19, 2016 at 2:52 am
Hi GilaMonster/Beatrix Kiddo
Thanks for your response. can this be upgraded directly to SQL 2014?
December 19, 2016 at 2:53 am
Hi Igor,
Same name needed
December 19, 2016 at 2:56 am
atulyan.aries (12/19/2016)
Hi GilaMonster/Beatrix KiddoThanks for your response. can this be upgraded directly to SQL 2014?
We've both just advised you not to. Have you got a test environment?
December 19, 2016 at 3:02 am
atulyan.aries (12/19/2016)
Hi Igor,Same name needed
Ok, I also wanted to appoint considering the renaming. You can find many posts about it.
Igor Micev,
My blog: www.igormicev.com
December 19, 2016 at 3:07 am
atulyan.aries (12/19/2016)
Thanks for your response. can this be upgraded directly to SQL 2014?
No, and in-place upgrades are not a good idea for production systems (plus there's the small matter of the OS probably being too old for SQL 2014)
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
December 19, 2016 at 7:35 am
I agree with what everyone else is recommending.
I would like to note that if you're asking if you have to restore to 2008 or 2012 or something, the answer is no. You can restore/attach a 2005 database to a 2014 instance. The database will be upgraded by that process. You can then, as appropriate, adjust the compatibility level.
None of this changes the rest of the recommendations.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply