Post reply

Have complex SSRS reports that were developed in VS 2010-can I upgrade them to VS 2012 or 2013 without problems?

  • October 28, 2014 at 4:01 pm

    #312088

    I developed some reasonably complicated reports using Visual Studio 2010 (shell) some time ago. It's been almost a year since I worked with them but now they are needed again. If I open them in Visual Studio 2013 against a new SQL Server 2014 database (originally the reports used SQL Server 2012), will I encounter any gotchas that aren't readily apparent at first?

    In other words, have any of you had any issues with doing something like this? I googled for the answer for a while but I haven't been able to find a clear answer one way or the other. They seem at first glance to be ok but I need to work up an estimate of how long it will take me to get everything upgraded and populated with new data, otherwise I would just work with them and see what problems I encounters, if any, before posting.

    Thanks in advance for your response.

    Thanks.

  • October 29, 2014 at 2:03 am

    #1755424

    There aren't a lot of changes between 2012 and 2014, so I don't expect a lot of issues.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 29, 2014 at 3:11 pm

    #1755648

    Thanks for your help. I worried about the Visual Studio versions with respect to SSRS than the database versions. Usually SSRS availability lags after a new version of the database engine is released.

  • October 30, 2014 at 2:16 am

    #1755704

    pharmkittie (10/29/2014)

    Thanks for your help. I worried about the Visual Studio versions with respect to SSRS than the database versions. Usually SSRS availability lags after a new version of the database engine is released.

    It's pretty OK for SSRS, it's SSIS that's having the most troubles.

    From the MSDB blog post Business Intelligence for Visual Studio 2013 (SSDT BI)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 31, 2014 at 10:41 am

    #1756097

    Thanks again. But now I'm concerned about SSIS. After working on upgrading my reports, I am going to be setting up SSIS packages to process an external inbound data feed. What are people doing about the issues to workaround them?

    Maybe using VS 2012?

    Thanks.

  • November 4, 2014 at 1:20 am

    #1756461

    VS 2010 --> SQL Server 2012

    VS 2012 --> SQL Server 2012

    VS 2013 --> SQL Server 2014

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 6 posts - 1 through 5 (of 5 total)

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