Downgrade BIDS 2008R2 to 2008

Question

Hi Currently I have 2008R2 installed on a machine.  All of the stuff in production is on 2008 SQL Server.  I cant use 2008R2 Bids with the packages, it will update them for compatibility then have problems with 2008 environment.  So, I need to downgrade to Bids 2008.  I have access to all of the versions, I guess I am asking if someone has done this before, what is the best way.  Im thinking of completely uninstalling and re installing, but Im hoping I dont have to. Sorry if this is a stupid question

Answer 1

Hello,

BIDS 2008 and BIDS 2008 R2 are compatible. Packages created on BIDS 2008 R2 will run on BIDS 2008 unless you are using components that exist only in SQL Server 2008 R2.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Would you please check-out below threads

http://social.msdn.microsoft.com/Forums/eu/sqlanalysisservices/thread/671f9b6b-12c5-41ee-aa34-9e1dfbd804a7

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/67254c6b-2aad-477a-bcd6-50317340f832

---

FAQ
----
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 3

Ahmed, I had already read both of those before posting.   I am not downgrading the server, just the client tools.

Alberto, I just uninstalled the SSIS, SSAS, SSRS components of SQL Server 2008R2.  Tomorrow Im going to try an install them with SQL Server 2008.  I heard this is possible through a freind. Any feedback on that?

Thanks for both of your input

Answer 4

Yes,

That is possible, it worked for me.

---

Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

Waqas

MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
Twitter: @Waqas_m1
Linked In: http://www.linkedin.com/in/waqasm1

Answer 5

I ended up completely uninstalling SQL Server and reinstalling 2008