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 |
|
cat_jesus
Aged Yak Warrior
547 Posts |
 Posted - 2008-02-21 : 11:18:59
|
| Another DBA on my team is trying to tell me that it is a widely accepted best practice to only have a single version of SQL server in the enterprise environment. This seems counter intuitive to me and I cannot find a confirming source for this assertion.I would think that it largely depends on your environment but that once a new version of SQL server has been decided on for a given application, for whatever reasons, that new version should be used moving forward on all new development.It also seems like that as other databases grow and hardware comes to its end of life that older databases be either migrated or ported to the new version as seems appropriate.Is there any reason an enterprise should always be on X version and only X version? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-02-21 : 11:47:15
|
| Lack of support for older versions from the manufacturer?We wouldn't bleeding-edge, but neither do we have SQL v1, v2, v3, v6.5, v7,,,2000, 2005 running at the same time either. I can see it being valid to have 2 ongoing during an upgrade/migration phase, but 3/4/5 versions in production...I'd be uncomfortable. |
 |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-02-21 : 11:54:35
|
| I'd be uncomfortable with more than 3 versions and I prefer two. But insisting on a single version across an entire enterprise and using "It's a widely accepted SQL Server best practice" as the reason seems ... false. It seems to me that insisting on such a standard creates more work(and thus costs more) than is necessary. I do not see the benefit, nor do I find evidence of this widely accepted best practice.But I'm open to the possibility that I'm wrong. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 15:14:53
|
| I'm second you on this. |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-02-21 : 16:48:41
|
quote:
Originally posted by rmiao
I'm second you on this.
"You" being me or "you" being Andrew? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 17:52:09
|
| You cat_jesus, and Andrew is in kind of same position. |
|
|
|
|
|
|
|
|
Homogenous VS Heterogenous Enterprise environments