install both 2008 and 2008 R2 developer edition

Question

I have a SQL server 2008 developer edition on my workstation. Currently we upgraded some of our production database servers to 2008 R2. But some still remain as 2008. As a developer for Databases, SSIS, SSRS,  I need to use both versions, 2008 and 2008 R2. What is the best way to do this? Should I install both 2008 R2 and 2008 on my workstation? Read from this:

http://msdn.microsoft.com/en-us/library/ee210714%28v=sql.105%29.aspx

still confusing about this:

1. for SSIS I can use 2008 R2 version BIDs for developing both 2008 and 2008 R2 SSIS package and deploy them to 2008 and 2008 R2 production server respectively?

2. for Database engine and reporting service, I would install 2008 R2 side by side with 2008.
Since there is a default distance exist in the server (2008), when I install 2008 R2, do I have to create a named instance?

Thanks 

---

SQLFriend

Answer 1

Hello,

1. BIDS 2008 R2 should replaced BIDS 2008. You should be able to open SSIS 2008 projects with BIDS 2008 R2. To move projects between  2008 and 2008 R2 environments, please see the following article:

http://agilebi.com/jwelch/2010/05/13/moving-ssis-packages-with-ado-net-destinations-between-2008-r2-and-2008/

2. You should install a named instance for SQL Server 2008 R2.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi SQL Friend,

Yes you can install versions instances on your work station, but keep in mind that each instance of SQL Server must have a unique name. Yes you are able to open both SQL Server 2008 projects in SQL Server 2008 R2 BIDS.

---

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 3

Thanks, so if I develop a SSIS in 2008 R2 BIDS, and deploy it to SQL server 2008 SSIS server, will it still work?

Thanks,

---

SQLFriend

Answer 4

Yes it will.

---

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.