BIDS 2005 and BIDS 2008 on the same machine?

[Database Administrator]

Hi, has anyone installed SQL 2008 (which includes BIDS 2008) on top of a
machine that already has SQL 2005 (and BIDS 2005)?

I'm pretty sure that I can have two different database systems on my
development machine (so long as I have a named instance) - but wasn't
sure whether two different versions of BIDS would cause issues.

Thanks...

[Database Administrator]

On Nov 9, 7:21*am, Scott wrote:
> Hi, has anyone installed SQL 2008 (which includes BIDS 2008) on top of a
> * machine that already has SQL 2005 (and BIDS 2005)?
>
> I'm pretty sure that I can have two different database systems on my
> development machine (so long as I have a named instance) - but wasn't
> sure whether two different versions of BIDS would cause issues.
>
> Thanks...

It works.
BIDS 2005 works on top of VS2005.
BIDS 2008 works on top of VS2008
More important: if you only have BIDS 2008, you can design a solution
for SSAS 2005 and deploy it to a SSAS 2005 instance.

Marco Russo
http://www.sqlbi.eu
http://sqlblog.com/blogs/marco_russo