Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Which Versions of SQL Server Do You Have?


Which Versions of SQL Server Do You Have?

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36042 Visits: 18736
Comments posted to this topic are about the item Which Versions of SQL Server Do You Have?

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Japie Botma
Japie Botma
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 290
We have 2 x SQL2000 servers and 5 x SQL2008R2 servers. I have an ongoing project to migrate all databases to our new servers (SQL2008R2), but I do it inbetween other projects and that spare time seems to get less and less. We still have about 40% of our databases on SQL2000. Our mix of in-house applications to third party applications is about 70% to 30% and 90% of the third party applications were migrated to SQL2008R2, maybe because it's easier, less integration. ;-)

5ilverFox
Consulting DBA
South Africa
call.copse
call.copse
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2843 Visits: 1857
Probably about 5 on 2000 and a similar number on 2005, a couple set up on 2008, although we have not got many real projects running on 2008 yet, mainly for reasons outside our control. It may be that we miss that one out the way things are going!
joe.trainor
joe.trainor
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 23
We have 2 x SQL 2000 servers in our BI environment. In our OLTP production environment we have a couple of SQL 2005 servers running apps that don't support 2008 yet. And we also have a couple of SQL 2008 servers running an app that does support 2008.

The main reason our BI environment still runs on SQL 2000 is because we have a whole lot of DTS code and we haven't yet gotten around to migrating it to SSIS.

I would be interested to know how many other people are finding DTS a bit of an obstacle to their upgrade progress from SQL 2000.

Best Regards

Joe Trainor
Head of BI
Virgin Active South Africa
RuiMauricio
RuiMauricio
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1547 Visits: 284
Due to limitations and support from vendors, we currently have over 80 servers running sql server 2000. 5 servers running 2005 and the rest is now 2008 R2.
... And we also have 1 running sql server 7.... but that is the most reliable one! Slow but reliable :-)

If we could we would just upgrade everything, but as you may well know.

Cheers
Japie Botma
Japie Botma
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 290
joe.trainor (10/21/2011)
I would be interested to know how many other people are finding DTS a bit of an obstacle to their upgrade progress from SQL 2000.


Yes, that is why 1 of our SQL2000 servers is still there.

5ilverFox
Consulting DBA
South Africa
SG Cowley
SG Cowley
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2305 Visits: 734
We support 7 production SQL Server 2000 with 8 test/development servers mainly supporting in house developed systems with a few third party applications including one third party where they don't seem to understand basic SQL Server...Ermm

Until recently we had another third party application that still ran on 6.5. Luckily I didn't have to support that!
peter.row
peter.row
SSC Veteran
SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)SSC Veteran (284 reputation)

Group: General Forum Members
Points: 284 Visits: 389
We support SQL 2005, 2008 and 2008R2 on the products we produce that I have been involved with. We dropped support for 2000 when MS dropped extended support. 1 product used DTS on SQL 2000 and getting rid of that was the best thing ever! DTS was the bain of my existence every time we released a new version of the product or had to change a DTS package (crashing IDEs are not fun).
SG Cowley
SG Cowley
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2305 Visits: 734
joe.trainor (10/21/2011)
I would be interested to know how many other people are finding DTS a bit of an obstacle to their upgrade progress from SQL 2000.


Several hundred DTS written over the years is the main obstacle to stop our upgrades!
IceDread
IceDread
Old Hand
Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)Old Hand (329 reputation)

Group: General Forum Members
Points: 329 Visits: 1145
I do not know about all products in the entire company but in my department of IT we use sql server 2008. We always upgrade to the latest version when we revisit a product or start a new one. I'm at large Insurance company in Sweden, and insurance companies does their job well here usually so they do not have the band standing I've heard some have in usa where most of you on these forums live I believe.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search