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 |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2008-12-03 : 12:59:00
|
| Hi -We are considering upgrading from SQL 2005 to 2008 and, unfortunately, I just have one server for testing. I have found a few articles and posts on news groups regarding a side by side install, some indicate no problems and some indicate that there can be problems.The one common thread is that you have to install SQL 2008 as a Named Instance. Not a big deal. However, are there other issues that I might run into?We use SSIS in 2005 extensively, so I would think that there might be an issue with SSIS in 2008 being able to open/run the 2005 SSIS packages? Or is this backwards compatible? And, would I need to install VS.Net 2008 as well?Thanks for any help or ideas.- will |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-12-03 : 13:42:03
|
| I run 2005 and 2008 in dev just fine, with 2008 being a named instance. The only issue is that the 2008 mangement studio cannot connect to 2005 services other than Database Engine (like Analysis Services, Integration Services, etc). And I think I have the full version of 2008 and not a beta version installed. |
 |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2008-12-04 : 17:30:46
|
| Thanks for the information. It seems like we should be all right in installing the two versions side-by-side. Naturally...we'll have some contingency plans in case things don't work out.Thanks. |
|
|
|
|
|
|
SQL 2008 and 2005 side by side?