SSRS in VS 2010 tool, VS 2012 Data services, what is compartiblity??

  • Hi,

    I have SSRS proj developed in VS 2010 Shell on SQLServer 2012 which is most standard setup, but now we want (or asked) to use VS 2012 for our SSRS, I might lost of track of all versioning and compartability, is there any good reason to do so? its still against Sqlserver 2012??

    I tried to pen my proj/solution in VS2012 (there is not initial reporting services default settings, so I choose some c#...) and could not open SSRS project, neither got any conversion options.

    Or do I need to do some 3rd party conversion?

    Main goal for our mgmt to make sure that everything is upto date to most recent SQL Server 2012 and so no any compartability issue will pop up in the future if SSRS reports done on VS 2010 Shell/Data Tools.

    Appreciate your help in this navigation, what is the optimal setup for this situtation.

    Best

    Mario

  • Normally Visual Studio 2012 works against SQL Server 2012.

    Make sure the business intelligence templates (SSDTBI) are installed though, otherwise you cannot open SSRS projects.

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

  • I did all installs and see that VS2012 works fine on any VS2010 projects, without any compatibility warnings or conversions, I also could not find any differences in functionality or extra features between both of them,

    does it mean that it's completely the same? just different look? in both cases they used SSDT pack.

    Order of install was:

    1. Install VS2012

    2. Install en_visual_studio_SSDTBI_VS2012_x86_ENU withe SQL Server 2012

    3. Apply vs update #4 aka VS2012.4.exe

    (from http://www.visualstudio.com/downloads/download-visual-studio-vs)

    4. Change appeareance back to vs2010

    ColorThemeEditor.vsix

    AntyCap menu items

    Tx

    M

  • mario17 (5/27/2014)


    I did all installs and see that VS2012 works fine on any VS2010 projects, without any compatibility warnings or conversions, I also could not find any differences in functionality or extra features between both of them,

    does it mean that it's completely the same? just different look? in both cases they used SSDT pack.

    Order of install was:

    1. Install VS2012

    2. Install en_visual_studio_SSDTBI_VS2012_x86_ENU withe SQL Server 2012

    3. Apply vs update #4 aka VS2012.4.exe

    (from http://www.visualstudio.com/downloads/download-visual-studio-vs)

    4. Change appeareance back to vs2010

    ColorThemeEditor.vsix

    AntyCap menu items

    Tx

    M

    That's just the appearence. It is not actually installing VS2010.

    You install SSDTBI for VS2010 by running the SQL Server set-up and installing the client tools.

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

  • Thanks, Koen.

    So it's the same features re SSRS development, right ?

  • mario17 (5/27/2014)


    Thanks, Koen.

    So it's the same features re SSRS development, right ?

    Yes.

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

  • Thanks, Koen.

    Now i'm relieved and can get back to my biz people who asked us to be all on 2012 software, feel like your avatar.

    Best

    Mario

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

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