Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2011-09-08 : 17:30:56
|
| I already have the full blown SQL Server 2005 (Std Edition ) 64 bit, SP3 installed on our DEV server.We are in midst of upgrading it to SP4 but are waiting and testing some vendor database that sit on this server.There is a need for the Development team to have the Integration Services (SQL Server 2008) installed.No upgrade to existing SSIS but a separate install.Is there a problem in doing this, as I have lots and lots of SSIS packages (SQL 2005) already in place and that are running daily called in sql jobs ?Also what steps should I take before this installation, any kind of backup (all dtsx are stored on the file system) ?How do I rollback if necessary, just uninstall ?Will any dll or other shared files be affected ?I just want to be really sure before installing, I know it would be pretty simple click of GUI but still..........Kindly advise |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-09-09 : 03:51:02
|
Integration Services is a shared feature so it's not possible to have two instances of it running in parallel on the same machine. From http://msdn.microsoft.com/en-us/library/ms143786.aspx ->quote:
Features shared by all instances of SQL Server on a single computer are installed to a single directory. They include the following:Client ToolsSQL Server Books OnlineBusiness Intelligence Development StudioIntegration Services
- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
Posted - 2011-09-09 : 09:37:31
|
| Thanks Lumbago for your response, I went through the site.Even if I do specify a separate location to install the feature, do you still think it would be a problem ?So after installation,I would only have SQL Server 2008 SSIS service running and my existing SQL 2005 packages will need to use sql 2008 service to execute ?I know I have lots of question, but Im just try to gather as much information to be sure if this installation is worth it on the same server .Thank You |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-09-12 : 02:04:21
|
| I don't think you will have any problems running SSIS2005-packages on SSIS2008 but to make sure you can try to run the upgrade advisor. I don't think it matters if you install SSIS 2008 in a different location, it will still upgrade the existing instead of installing it in parallel with 2005.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
|
|
|
Install SQL 2008 SSIS side by side SQL 2005