Since the stable and mainly feature-complete versions of SQL Server 2012 have been available, I have been heads-down on multiple BI projects using this software.  SQL Server 2012 is not just the next, incremental build of the same database platforms with a few added features here and there.  No, SQL Server 2012 ushers in a new era of user-driven BI analytics and data visualization.

Here’s a little information about my upgrade experience.  First of all, let’s talk about where we are in the pre-release cycle.  Release Candidate 0 was made available to the general public about a month ago.  There was talk about another, internal build with bug fixes and some added BI model functionality & Power View features.  If this internal release were to actually exist and if it had been made available to yours truly, the existence of such a product build would be protected under a non-disclosure agreement with Microsoft and I would not be at liberty to tell you that I had it installed not to discuss any details.

I started with a completely working install of SQL Server 2008 R2, including all SQL Server services and a SharePoint 2010 Enterprise Edition farm with Reporting Services & PowerPivot integration.  When attempting to upgrade from 2008 R2 to 2012 RC0, setup would freeze and become inoperable.  There were several issues, all of which I don’t remember but the a did not go well.  At that point, I rolled my machine back to a snapshot and performed a side-by-side installation of 2012 with all services, alongside the existing 2088 R2 install. Both cohabitated and worked well.  Moving the content databases was done manually but it went smoothly.  I then manually migrated all the user databases by detaching them from the 2008 R2 instance and then attaching them to the 2012 RC0 instance.  I got there but it was on the long road.

What about the alledged more-recent, internal, super-secret build that no one knows about?  If it did in-fact exist, and if I did in fact have a copy; it would have installed seamlessly and the upgrade from 2012 RC0 would have gone very smoothly.  If that did indeed happen, I would hev been quite pleased that the upgrade from RC0 went quite well.  Nudge nudge, wink wink - it looks like the upgrade story is good news.

Filed under: BI Industry, Microsoft BI Platform, MVP Community, SolidQ, SQL Server, SQL Syndication