<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Upgrading to 2012?
Upgrading to 2012?
Rate Topic
Display Mode
Topic Options
Author
Message
meridius10
meridius10
Posted Sunday, December 30, 2012 3:02 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, April 30, 2013 7:13 AM
Points: 53,
Visits: 91
Is it worth upgrading from SQL Server 2008 R2 Developer to 2012 Developer?
I believe most companies are still using SQL Server 2008 or 2005...
Post #1401241
opc.three
opc.three
Posted Monday, December 31, 2012 12:24 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 6,703,
Visits: 11,731
It depends on what you need to support. You can have an instance of both versions of the database engine and SQL Agent installed side-by-side. Just be careful when in comes to SSIS, installing SQL 2012 can mess with the DLLs needed in BIDS 2008.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1401477
meridius10
meridius10
Posted Tuesday, January 01, 2013 2:29 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, April 30, 2013 7:13 AM
Points: 53,
Visits: 91
Thanks. I think you read my mind!
My experience of uninstalling SQL Server 2005 and then installing 2008 R2 wasn't wonderful. This meant I had to reinstall my home operating system, which is why I asked this question in the first place.
I am not sure how quick or keen businesses will be to upgrade to 2012...
Post #1401564
opc.three
opc.three
Posted Tuesday, January 01, 2013 4:50 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 6,703,
Visits: 11,731
SQL Server 2012 offers a lot of great new functionality but with upgrading comes cost and companies are typically slow to shell out the money if the current system supports their business. The thing most hampering sales of SQL Server 2012 in my opinion is how feature-rich and stable of a product SQL 2005 and SQL 2008 have proven to be. I think new projects will tend to be funded with SQL Server 2012 as the product but upgrades may come at a slower rate until new features catch on and IT departments can use them as selling points to upper management to justify the cost.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1401574
meridius10
meridius10
Posted Tuesday, January 01, 2013 11:52 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, April 30, 2013 7:13 AM
Points: 53,
Visits: 91
That sounds like a pretty accurate analysis.
I also guess that in this time of austerity, IT departments will have to provide very good reasons to upgrade.
Some of the databases I used were constructed by firms using SQL Server 2005 as a back end, so I guess it would be a major decision for them to upgrade to 2008/R2 or 2012 as they would have to pass on the additional costs to their clients.
Post #1401614
opc.three
opc.three
Posted Tuesday, January 01, 2013 2:11 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 6,703,
Visits: 11,731
meridius10 (1/1/2013)
Some of the databases I used were constructed by firms using SQL Server 2005 as a back end, so I guess it would be a major decision for them to upgrade to 2008/R2 or 2012 as they would have to pass on the additional costs to their clients.
Most of the third party apps tha rely on SQL Server that I have supported have appeared to drag their feet when it came to certifying their product on newer versions. In the worst case only when a product version was about to be end-of-lifed by Microsoft in terms of support did the company finally certify their software for use with a newer version. The sad thing is that the upgrade path from 2005 to 2012 is actually quite smooth. Not many mainstream use-cases that run 2005 will have much trouble running on 2012.
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Believe you can and you're halfway there.
--Theodore Roosevelt
Everything Should Be Made as Simple as Possible, But Not Simpler
--Albert Einstein
The significant problems we face cannot be solved at the same level of thinking we were at when we created them.
--Albert Einstein
1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples.
--Giordy
Post #1401626
Stupeo
Stupeo
Posted Wednesday, January 02, 2013 3:59 AM
SSC Eights!
Group: General Forum Members
Last Login: Thursday, February 07, 2013 3:07 AM
Points: 890,
Visits: 774
We sell software to the Healthcare industry (mainly NHS in the UK) and our customers are usually really slow to adopt new versions.
However, we've got half a dozen of customers who are moving to SQL 2012 from SQL 2000. They've never wanted 2005/2008/2008R2 as they didn't see the benefit!
I think SQL 2012 adoption will really pickup this year so it would be good to be prepared.
Post #1401750
EdVassie
EdVassie
Posted Wednesday, January 02, 2013 6:51 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 2,621,
Visits: 2,758
We upgraded the SQL instances that serve our web applications to SQL 2012 last year, as part of our migration to AWS.
Over the years we had upgraded from SQL 2000 to 2005, then to 2008 and by 2011 we were running everything on SQL 2008 R2. The migration from SQL 2008 R2 to SQL 2012 was the least troublesome of all that we have done.
We are looking forward to upgrading our BI stack to SQL 2012 and SharePoint Online in March/April, as the SQL 2012 BI stack is significantly improved over previous versions.
If you want to see how a site that runs on AWS and delivers over 2 million page hits per day performs, visit
http://www.totaljobs.com
Author:
SQL Server FineBuild
1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005.
25 March 2013
: now over 23,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1401817
dan-572483
dan-572483
Posted Wednesday, January 02, 2013 10:48 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 5:23 PM
Points: 330,
Visits: 945
Ed, were your non-troublesome upgrades from 2008 R2 to 2012 done by ungrading existing instances, installing new names-instances side by side and migrating the DBs or by migrating DBs to new hardware with 2012 installed?
Post #1401967
EdVassie
EdVassie
Posted Thursday, January 03, 2013 2:45 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 7:57 AM
Points: 2,621,
Visits: 2,758
Our SQL 2012 upgrade was done as part of a migration to AWS. This had much the same experience as moving to a new conventional data centre, except that we could concentrate on just building the Windows and SQL instances we needed and did not have to worry about getting kit racked up and cabled.
We built a parallel environment in AWS, spread over two Availability Zones for resilience. We used SQL P2P replication within our old DCs and within AWS, but network capacity limits at our DCs meant we had to use standard Transactional replication from the DCs to AWS to keep AWS up-to-date with our live site.
We did have one unexpected SQL issue after cutover, due to a bug in Full Text search. Microsoft found us a workaround, and we are hopeful the next CU will include a fix for the underlying problem. Apart from this, I do not recall any issues related to the move to SQL 2012.
We hope to share the story of our move to AWS at SQLBits XI, so please vote for
http://sqlbits.com/Sessions/Event11/AWSome-Totaljobs_moves_to_the_cloud4
if you want to hear more.
Author:
SQL Server FineBuild
1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005.
25 March 2013
: now over 23,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1402254
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
