Post reply

Upgrading from SQL Server 2008 R2 to SQL Server 2012

  • October 5, 2015 at 12:40 pm

    #301189

    All:

    I am having a hard time finding exactly what needs upgraded and hoping some of you might be able to help. We currently have installed SQL Server 2008 R2 with Report Builder 3.0 on our desktops. Most of the team also uses Visual Studio 2008 to manage / maintain some reports that is installed on our SSRS, but Report Builder 3.0 is used for reports housed inside SharePoint.

    When we upgrade to SQL Server 2012, I believe our current tools will no longer work, but I am having a hard time finding the tools that will be needed to be upgraded as well. We also have BIDS installed to do development with VS 2008.

    Could anyone tell me the version of Visual Studio needed to build reports in SSRS 2012 and any other tools needed?

    My apologies for not knowing exactly how to frame my question, but as it takes a LONG time to get new software installed at my place of work, I want to try and find out what all needs installed prior to the upgrade as doing it after isn't as simple as a software download from a Microsoft URL (we cannot install software and it must go through corporate)

  • October 6, 2015 at 1:33 am

    #1831609

    You need SSDT (SQL Server Data Tools) this is a VS2012 based product and comes built into the SQL media so can be installed via the SQL installer on all machines that need it.

    Alternativley is you want to use VS2013 you can you need to download the correct SSDT package from Microsoft to add in the templates for SSRS/SSAS/SSIS etc

    https://msdn.microsoft.com/en-us/library/mt204009.aspx

  • October 6, 2015 at 6:16 am

    #1831687

    Thank you for the reply.

    Now my follow-up question. What will happen to reports created using Visual Studio 2008 and BIDS? Will they need to be upgraded to the new format, or will those work and only new development would need to be Visual Studio 2012 with the SQL Server Data Tools? If they work, we should be able to develop "new" reports still using the old tools, correct?

  • October 6, 2015 at 6:21 am

    #1831689

    Depends on your upgrade method.

    This link may provide better details than I can https://msdn.microsoft.com/en-us/library/ms143747(v=sql.110).aspx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply