June 26, 2012 at 4:24 am
We are considering moving some of our core bespoke applications from SQL2005 to SQL 2012 and bypassing SQL2008 altogether.
Given that SQL2012 RTM has only been out for a few monthe and no service packs are availiable as yet I was wondering if anyone out there has had any operational experiences with SQL2012 and what problems if any they have found ?
June 26, 2012 at 4:43 am
I've been working with SQL Server 2012 for a month now. No problems so far. It looks and feels the same as previous versions.
Data has been moved from SQL Server 2000 via Linked Server. Had to use ODBC Data Source because Native Client only goes back to SQL Server 2005.
June 26, 2012 at 4:48 am
While there have been no service packs, they just released Cumulative Update #2. I strongly recommend installing it.
"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
July 3, 2012 at 3:48 am
Thanks - The business wants to know what the risks and benefits associated with going from SQL2005 to SQL2012 - A relatively new version.
would you think it better to move to SQL2008 and then SQl2012 or straight to 2012 and save an upgrade cycle ??
July 4, 2012 at 12:23 am
I would go immediately to SQL Server 2012.
I don't know if you do a lot of BI, but SSIS and SSRS would need a lot of upgrading.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 6, 2012 at 6:35 am
Brendan Wong (7/3/2012)
Thanks - The business wants to know what the risks and benefits associated with going from SQL2005 to SQL2012 - A relatively new version.would you think it better to move to SQL2008 and then SQl2012 or straight to 2012 and save an upgrade cycle ??
Sorry for the late reply. I've been out on a boat for a week.
If you're going to upgrade, just go to 2012. It's been extremely stable. I know several organizations that have used the beta with no/few issues. The benefits are there. Plus, if you're going to go through the pain of the upgrade process you may as well go to the highest level upgrade you can in order to extend out the time to the next upgrade. Since 2008R2 is now about 3 years into it's life-cycle, upgrading to it makes less sense.
"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 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply