November 26, 2012 at 12:35 pm
I have a SQL server 2008 developer edition on my workstation.
Currently we upgraded some of our database server to 2008 R2.
But some still remains as 2008.
As a developer for database, ssis, 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?
Thanks
November 26, 2012 at 1:51 pm
I don't think you will be able to have SSIS 2008 and 2008 r2 on the same box as SSIS is shared across major versions. The Database engine, Analysis servers, and Reporting services can be both 2008 and 2008 r2.
http://msdn.microsoft.com/en-us/library/ee210714%28v=sql.105%29.aspx
November 26, 2012 at 2:42 pm
Does this mean
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,
November 26, 2012 at 3:20 pm
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?
since SSIS and BIDS are shared across 2008 and 2008 r2 then the integration services installed on your box should serve both the 2008 and 2008 r2 instance. Don't have anywhere to test this so I can't be sure.
from linked article
Components shared across all instances of the same major version of SQL Server
SQL Server versions that have the same major version share some components across all instances. If the shared components are selected during upgrade, the existing components are upgraded to the latest version.
Examples: Integration Services, SQL Server Management Studio, Business Intelligence Development Studio, and SQL Server Books Online.
you could try upgrading SSIS and not BIDS or vice versa and see how that works. Or upgrade both and if it does not work for the lower version, uninstall BIDS and reinstall just the 2008 version.
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?
correct, your 2008 r2 instance would have to be a named instance.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply