Thursday, February 14, 2013 8:25 PMHi 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
Friday, February 15, 2013 3:07 AMModerator
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.
Friday, February 15, 2013 3:54 AMModerator
Would you please check-out below threads
SQL Server Setup Team
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.
Friday, February 15, 2013 5:04 AM
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
Friday, February 15, 2013 6:15 AM
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"
MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
Linked In: http://www.linkedin.com/in/waqasm1
- Proposed As Answer by Allen Li - MSFTModerator Wednesday, February 20, 2013 6:43 AM
Tuesday, March 12, 2013 10:25 PM
I ended up completely uninstalling SQL Server and reinstalling 2008