Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Which Versions of SQL Server Do You Have? Expand / Collapse
Author
Message
Posted Thursday, October 20, 2011 10:56 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:57 AM
Points: 33,268, Visits: 15,438
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
Post #1194121
Posted Friday, October 21, 2011 12:25 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 11, 2014 7:32 AM
Points: 130, Visits: 186
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
Namakwa Sands
South Africa
Post #1194136
Posted Friday, October 21, 2011 1:10 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:25 AM
Points: 1,696, Visits: 1,114
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!
Post #1194140
Posted Friday, October 21, 2011 1:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 31, 2014 2:29 AM
Points: 35, Visits: 14
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
Post #1194142
Posted Friday, October 21, 2011 1:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 4:27 AM
Points: 1,545, Visits: 257

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
Post #1194147
Posted Friday, October 21, 2011 1:31 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, September 11, 2014 7:32 AM
Points: 130, Visits: 186
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
Namakwa Sands
South Africa
Post #1194148
Posted Friday, October 21, 2011 1:35 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, September 12, 2014 1:06 AM
Points: 1,550, Visits: 426
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...

Until recently we had another third party application that still ran on 6.5. Luckily I didn't have to support that!
Post #1194151
Posted Friday, October 21, 2011 1:37 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:55 AM
Points: 220, Visits: 276
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).
Post #1194153
Posted Friday, October 21, 2011 1:38 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, September 12, 2014 1:06 AM
Points: 1,550, Visits: 426
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!
Post #1194155
Posted Friday, October 21, 2011 1:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 8:16 AM
Points: 295, Visits: 1,011
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.
Post #1194162
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse