Are BI projects for SQL Server 2005/2008 compatible to apply in Visual Studio 2010?


Below are the table to list out the compatible:-

  Visual Studio 2005 (the release version and later service packs) with BIDS in SQL Server 2005 Visual Studio 2008 (Service Pack 1 and later service packs) with BIDS in SQL Server 2008 Visual Studio 2008 (Service Pack 1 and later service packs) with BIDS in SQL Server 2008 R2 Visual Studio 2010 (the release version and later service packs)
SQL Server 2005 BI projects Supported Supported after project upgrade Supported after project upgrade Not supported
SQL Server 2008 BI projects Not supported Supported Supported after project upgrade Not supported

SQL Server 2008 R2 BI projects

Not supported Not supported Supported Not supported

 

Resolution to apply BI projects into Visual studio 2010

To resolve the issue in which you cannot open the project in SQL Server BIDS after you upgrade the project, follow these steps:

  1. Create a new project that has the same name as the original BI project in a different directory by using SQL Server BIDS.
  2. Add all relevant project items from the upgraded BI project folder. For example, for an Analysis Services project, add the .ds and .dsv files. For a Reporting Services project, add the .rds and .rdl files.
  3. Save and then open the new BI project.

    About these ads

    About Yeoh Eik Den

    I am a SharePoint developer, and I like to bringing a visual exploration of the dot net in the real world.
    This entry was posted in BI and tagged . Bookmark the permalink.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Connecting to %s