locked
Co-existence of Visual Studio 2005 (BIDS) and Visual Studio 2008 (BIDS) RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have been using SQL Server Management Studio 2008 and VS 2008 (BIDS) for a while without any problems. I now have a requirement to work with some Reporting Services 2005 reports, which cannot be upgraded to 2008 for operational reasons.

    In order to manage these reports I've installed VS 2005 succesfully but I cannot get VS 2005 to include the appropriate Reporting Services functionality so I can't open any RS 2005 Projects or Solutions. It appears tto me that the only way to do this is to install them from the SQL Server 2005 installation, but when I try to do this, it won't do it as it tells  that the Management Tools are already installed - I can only assume that this is because I have VS 2008 (BIDS) installed, which was installed from the SQL Server 2008 install.

    I'm guessing that the "standard" way of doing this is to de-install the SQL Server 2008 Shared Components and the VS2005 & VS2008 prgrams and then re-insall then in sequence (SQL 2005 Mangement Tools, then SQL 2008 Managment Tools) which is a very long process. Is there any way of installing the BIDS extensions to my VS 2005 program?

    Regards
    • Moved by YiChun Chen Thursday, October 29, 2009 6:37 AM SQL issue (From:Visual Studio Setup and Installation)
    Wednesday, October 28, 2009 8:47 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    Thanks for your feedback.

    Actually, you don't need to do that. I did a small test, I create a Reporting services project using BIDS 2005, when I opened it using VS2008 (with BIDS 2008), it (VS2008) popuped with Visual Studio Conversion Wizard, I click Next, the project was converted successfully.

    So, could you please try to open the project using VS 2008 (with BIDS 2008), the project should be upgraded.

    Any more questions, please let me know.
    ChunSong Feng
    Microsoft Online Community Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Friday, October 30, 2009 2:23 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi MagicalHorn,

    I am moving this thread from Base "Visual Studio Setup and Installation" forum to the "SQL Server Setup & Upgrade" forum, since the issue is related to SQL. There are more SQL experts in the "SQL Server Setup & Upgrade" forum.

    Thanks
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Thursday, October 29, 2009 6:36 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Since you have installed SQL Server 2008 Mangement Studio, you can not install SQL Server 2005 Mangement Studio separately.

    Focus on the problem, you can not open RS2005 projects using VS 2008 (BIDS), right? If so, you can install BIDS 2005 without installing the Mangement Tools, follow the steps:

    Run setup.exe from the Tools folder of the SQL Server 2005 installation media.
    Select Business Intelligence Development Studio feature under Client Components list in the Feature Selection dialogue box


    After installed, you should get SQL Server Business Intelligence Development Studio 2005. Any more quesitons, please feel free to let us know.

    ChunSong Feng
    Microsoft Online Community Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Thursday, October 29, 2009 7:03 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

     

    I have tried exactly waht you suggested above, but to no avail. When I slect the Business Intelligence Development Studio feature and proceed I get a screen saying that my upgrade has been blocked becasue I have a later version installed (I am assuming that this is referring to VS 2008).

    The installation appeasrs to be making an assumption that I want to upgrade VS, but in fact i don't want to upgrade - I want to have VS2005 and VS2008 side by side. The only reason I need to do this is that VS2008 will not Edit SSRS2005 Report Files without upgrading them to SSRS 2008 Report Files.

    I guess it's back to square one of my original post - uninstalling everything and then tryingto isntall them in sequence i.e. SQL 2005 and then SQL 2008.

    Regards
    Colin

    Thursday, October 29, 2009 12:51 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi,

    Thanks for your feedback.

    Actually, you don't need to do that. I did a small test, I create a Reporting services project using BIDS 2005, when I opened it using VS2008 (with BIDS 2008), it (VS2008) popuped with Visual Studio Conversion Wizard, I click Next, the project was converted successfully.

    So, could you please try to open the project using VS 2008 (with BIDS 2008), the project should be upgraded.

    Any more questions, please let me know.
    ChunSong Feng
    Microsoft Online Community Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Friday, October 30, 2009 2:23 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    HOW DO YOU INSTALL BIDS 2005 ONCE BIDS 2008 IS ALREADY INSTALLED? 

    SOME REPORTS CAN NO LONGER BE BUILT OR MAINTAINED IN BIDS 2008 DUE TO MASSIVE REWRITE OF TABLES/GROUPING FUNCTIONALITY.
    Thursday, March 18, 2010 12:12 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    TechnetKaren,

    Is it safe to assume you never got both versions of BIDS installed concurrently?

     

    Wednesday, May 18, 2011 5:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Does anyone have a solution for this?  I have VS and SQL 2008 already, but I now need to support some 2005 SSIS packages.  i've install VS 2005, but it won't open my DTS packages.
    Thursday, July 7, 2011 6:39 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Brune,

    BIDS just uses Visual Studio shell, after you have VS2005 installed, you still need to install BIDS from SQL Server 2005 installation media which will install related components for BI projects.

    Hope this helps.

    Friday, July 8, 2011 1:08 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    huh? how did this answer the question? why has someone marked it as the answer?

    The question was how can both 2005 and 2008 both be edited on the same machine.

    In fact the original question said

    "I now have a requirement to work with some Reporting Services 2005 reports, which cannot be upgraded to 2008 for operational reasons."

    if there was a mark down option i would mark that answer down.

    Here's some actually useful links about this topic in case anyone ends up stumbling on this thread in the future(like i did ) and then needing to look elsewhere.

    It looks like it is possible according to this:

    http://dbaspot.com/sqlserver-olap/427405-bids-2005-bids-2008-same-machine.html

    and Daren Gosbell and Dan English explain the compatibility of the different components pretty well here:

    http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/a161f2c2-fb09-49ad-9fc9-9dab51ec45b2/

    • Edited by JaySeeAre Wednesday, July 18, 2012 11:34 AM Found some other threads:
    • Proposed as answer by JaySeeAre Wednesday, July 18, 2012 11:35 AM
    Wednesday, July 18, 2012 11:21 AM