Geeks With Blogs
devnotebook Juan Ignacio Gelos

Sadly, this is Microsoft's official position.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2473242&SiteID=1

From MVP Teo Lachev: "VS.NET itself doesn't support BI project types. They get added to VS.NET when you install the SQL Server client tools. Since SQL Server 2005 client tools don't know anything about VS.NET 2008, nothing gets integrated with VS.NET 2008.

I believe that working with SQL Server 2005 projects will require you stick with BIDS 2005 or VS.NET 2005. That's because when you open a RS 2005 project in BIDS 2008, the report definitions will get converted to the new RDL format so you won't be able to publish them back to SQL Server 2005. I hope someone from the RS team reads and confirm this."

 

From Microsoft's Robert Bruckner: "In CTP November, BIDS 2008 is essentially equivalent to BIDS 2005 (based on RDL 2005).

However, this will change in future CTP's as BIDS 2008 receives all the updates for a new and improved report design experience.  It will then also use the RDL 2008 format and upgrade old reports on loading into BIDS."

 

Conclusion: You need to keep a side-by-side installation of Visual Studio 2005 in order to open/edit SQL Server 2005 Reporting Services projects, until you are able to install the SQL Server 2008 Client components on your machine.

Posted on Wednesday, December 12, 2007 4:52 PM Visual Studio | Back to top


Comments on this post: Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects (until you install SQL Server 2008)

# re: Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects
Requesting Gravatar...
It is too bad, however I can understand their reasoning.
It's not like it was included in VS 2005 either, there was just an addon packaged with SQL2005 that added it to VS2005.

I can't wait for the 2008 version to be available.
Left by Jereme Guenther on Jul 01, 2008 8:42 PM

# Im done with Reporting Services
Requesting Gravatar...
I am moving to a custom reporting solution. Reasons:

1) Integrated permissions with my asp.net apps
2) One less server to worry about (actually two, DR and Production).
3) I no longer use vs2005 and don't want to have dependency to it.
4) Moving RS to sql 2005 was a real pain. I don't want to repeat that.
5) I can develop my own XML based reporting solution in a few days using asp.net.
Left by Stuart Wain on Sep 05, 2008 1:04 PM

# re: Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects (until you install SQL Server 2008)
Requesting Gravatar...
It makes total sense, right?

I mean, with the next version of MS Office they're probably not going to let you edit old .doc or .xls files, right?

Oh wait, that would be stupid. Right.
Left by Dave on Feb 17, 2009 3:50 PM

# re: Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects (until you install SQL Server 2008)
Requesting Gravatar...
Need VS 2008 to support RS 2005 projects out of the box?

It is like asking Microsoft to release a version of VS that will support all current Project types like WPF projects, Silverlight projects, Sharepoint 2007 and 2010 projects, RS Projects, and who knows what other kind of project might still come out.

This will be a nice 5GB download with all possible project types. Noooo!

I prefer the bare minimum projects installed, and the ability to add more project types, when I need to develop in those technologies, like RS 2005/2008.

Moving to custom reporting solutions mean more headaches in support, and you have to upgrade the clients anyway every time you add major functionality. I know because I have been there!

VS will support whatever SDK's and tools are installed.

I think that is awesome.Well done Microsoft.

Report Builder 2 is great for editing reports, and helps us to move away from the clunky VS environment, just for reports development.

The only thing I do not like about the MS Products, is the price tag.

That is a whole new debate.
Left by Shaun on Nov 10, 2009 9:32 PM

# re: Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects (until you install SQL Server 2008)
Requesting Gravatar...
Visual Studio 2008 Team System bug:

If you create a class diagram in VS2008 Team System.
Check-In the class diagram. Then, check-out the member,
make a change, then check-in the member, it causes VS2008 Team System to crash. Also, takes a long time
between updates.
Left by Nelson Rivers on Dec 14, 2009 11:21 AM

# visual studio 2008 is compatable with sqlserver 2005
Requesting Gravatar...
pls give the report
Left by manikumar on Jun 23, 2010 7:58 AM

# re: Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects (until you install SQL Server 2008)
Requesting Gravatar...
Hi All,

i have a tool that converts 2008 rdl to 2005 to provide backward compatibility. Please contact on my email : amarsale@gmail.com

Thanks & Regards,
Amar Sale
Left by Amar on Aug 10, 2010 2:16 AM

# re: How To Create .Rdl File in .net 2008
Requesting Gravatar...
Please Send Me Example Of Show .rdl File in reportviewer if Any extra Service Require Then Tell Me
Left by Ankur on Jan 08, 2011 11:42 AM

# re: Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects (until you install SQL Server 2008)
Requesting Gravatar...
i am trying to install sql server 2005.
i already have visual studio 2008.
but after installation i am not able to connect to server as it is not picking up the local server by default.
i manually configure my machine than also i am getting an error.
Left by iti tyagi on Mar 21, 2011 2:31 AM

# re: Visual Studio 2008 Will NOT Support SQL Server 2005 Reporting Services projects (until you install SQL Server 2008)
Requesting Gravatar...
I am using .net 2008 and 2005 sql Server now..during the sql installation there are some options disabled and sql not installed properly...what can i do?pls help me...
Left by praba on May 02, 2011 12:49 AM

Your comment:
 (will show your gravatar)


Copyright © Juan Ignacio Gelos | Powered by: GeeksWithBlogs.net