Microsoft to dump support for old versions of SQLserver

The cattleprod approach to move users on to 2005 version

By Jeremy Kirk, IDG news service
Published: 09:21 GMT, 03 November 06

Microsoft will only support SQL Server 2005 running Service Pack 2 on Vista and Longhorn.

The company have suggested that customers running SQL Server 2000 and earlier versions, such as 7.0 and 6.5, should move to its newest release, SQL Server 2005.

Service Pack 2 (SP2) has not yet been released but should appear early next year. The free version of the database, SQL Server 2005 Express Edition, formerly called Microsoft Database Engine (MSDE), will also not be supported by Windows Vista and Longhorn.

Older versions of SQL Server could potentially work on Vista and Longhorn, but Microsoft isn't testing them, said Matthew Stephen, a data platform technical solution professional who works for Microsoft in the UK. By the time Longhorn server comes out - scheduled for the second half of 2007 - SP2 should be well-tested, he said.

Microsoft positioned the decision as a way to provide users with better security, saying SQL Server 2005 is designed to take advantage of better security and performance features in the upcoming operating systems.

The move may also be designed to wean people off the older database release, which would be expected since SQL Server 2000 is aging, said David Cartwright, a freelance software developer and database tester in the UK "There's going to be a concerted push to get people on [SQL Server] 2005," he said.

SP2 will likely tap into enhancements to Microsoft's .Net development platform as well as in the new OSes, which older versions of the database won't be able to do, Cartwright said. Service packs usually also contain bug fixes.

Mainstream support for versions of SQL Server 2000, including the developer, enterprise and standard editions, is due to end in August 2008. The products will then go into extended support for another five years, according to Microsoft's Web site.

The issue shouldn't be too much of a burden for users. Although Windows Vista is due to debut later this month for business customers, most will wait at least nine months to a year before adopting it, Cartwright said.

What are your views on this subject? Use the form below to post a comment on this article up to 500 characters.

Characters remaining: 500

Related Applications news

Microsoft Office 2010 beta available for download

Developers can get hands on software preview

19 November 2009

Microsoft reveals Silverlight update plans

Version 4 to beef up out of browser application support

Microsoft beta to shake up directory services

Developers to bake access control into applications

Salesforce launches own social networking app

Chatter could be 'Facebook for the enterprise'.

Related Applications reviews

Microsoft Office 2010 beta

Akvis ArtSuite 5.0 review

PeerBlock review

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story, and in case of transmission error. Both your name and the recipient's name and address will not be used for any other purpose.

Techworld White Papers

Database security: Preventing enterprise data leaks at the source

IDC discusses the growing internal threats to business information, the impact of government regulations on the protection of data, and how enterprises must adopt database security best practices...

Download Whitepaper

Service-oriented security

SOA has become an integral part of enterprise software by providing a framework to efficiently develop software as services that is easily sharable, reusable, and integrated. No where is the need more apparent than in the Identity Management space. Welcome to the age of Service-Oriented Security (SOS).

Download Whitepaper

Data protection prospective vendor checklist

Organisations need a way to map business needs against all these challenges in procuring a technical solution. To help, SANS has developed the following Prospective Vendor Checklist.

Download Whitepaper

Unlock the power of the mainframe

This whitepaper presents the notion of CICS as an integration hub based on a component-based, service-oriented architecture supporting Web services. Highlights will review the challenges and contrasted support for Web services natively in CICS.

Download Whitepaper

Techworld UK - Technology - Business

COLT White Paper

Are all VoIP services the same?

Questions to ask your service provider to ensure you get the VoIP service you need
With careful choice of partner, your business can have all the advantages of VoIP access - reduced costs, flexibility and simplicity - without the drawbacks.
This white paper is your guide to ensure you get right the VoIP service and details the pitfalls which businesses would do well to avoid.

Download white paper
BMC

Ride the express lane in the journey to speed ITIL adoption

Explore the challenges in making the journey to ITIL and the criteria for selecting consulting services
By following ITIL practices, your IT organisation will become more closely integrated with the business. We recommend making the journey to ITIL in a sequence of six incremental steps, the phases of which are driven through execution of a strategic transformational roadmap.

Download white paper

Webcast: IT Financial Management: Cost Optimisation for Efficiency and Agility.
On Demand Webcast
Join this webcast to learn about the techniques and technologies that can help you prove the value of IT to the business by understanding the true cost of today's IT services and those that will be necessary to deliver future success.

Register Today

Site Map

IDG Network

* *