Windows 10: Are you still running SQL Server 2005? Time to Upgrade.

Brink · Apr 13, 2015

Are you still running SQL Server 2005? We know it’s hard to let go, but it’s been 10 years. In its time SQL Server 2005 was a great choice for your departmental and mid-market IT needs. Over the last decade, Microsoft has continued to invest and SQL Server has evolved to be an enterprise-class solution to support your growing business needs. If you haven’t yet moved on to take advantage of these capabilities, now is the time to start planning.

After 10 great years, extended support for all versions of SQL Server 2005 is coming to an end on April 12, 2016. A year sounds like plenty of time to plan your migration, but, depending on the type of application, the migration destination, the scale of the move and resources allocated, migrations can take several months. In addition to SQL Server 2005, you may have heard that support for Windows Server 2003 is ending soon. As you plan your SQL Server migration, you should also plan your infrastructure migration to get the most out of our modern platform. Planning now will ensure that you are able to make the move in time and Microsoft is here to help you in that process.

First, it is important that you know what end of support means for your business. While SQL Server 2005 instances will continue to run, after the end of support date Microsoft will no longer provide hotfixes or security updates. Additionally, the benefits of upgrading to a modern data platform far outweigh the costs of maintaining security, support and compliance for an unsupported database.

Upgrading is not just a maintenance task, but an opportunity to provide new value to your business. Moving to SQL Server 2014 or Azure SQL Database enables you to achieve breakthrough performance:

SQL Server 2014 has been benchmarked to be 13 times faster than SQL Server 2005, before the additional performance gains available from in-memory OLTP.

AlwaysOn availability groups provide more reliable High Availability.

Together with Windows Server 2012 R2 you can scale up across compute, networking and storage.

New tools in SQL Server Management Studio provide an easy on-ramp to cloud to help you get more from your data platform investment.

You can read more about the benefits to planning for SQL Server 2005 and Windows Server 2003 end of support now. And learn about the quick ROI of SQL Server 2012 and 2014 in a study Microsoft commissioned with Forrester on the Total Economic Impact of SQL Server – read the full study or watch the webinar.

Over the next year, the team will post a series of blogs around SQL Server 2005 end of support and information to help you in your upgrade path including topics on the process of upgrading, tools available to help you upgrade, migration destination guidance and more.

To help you get started, Microsoft has put together several tools and resources to prepare for your upgrade:

Discover: Determine which applications are running on SQL Server 2005 and make the case for an upgrade.

Assess your current IT infrastructure with the Microsoft Assessment and Planning Toolkit

Target: Choose a migration on destination for each application whether on-premises, virtualized or in the cloud.

Get a free trial of SQL Server 2014 and Microsoft Azure

Upgrade: Plan your upgrade, whether you do it yourself or collaborate with a partner.

Upgrade yourself with the SQL Server 2014 upgrade technical guide or Azure SQL Database Migration Wizard

Find a partner to support your upgrade

For more information on SQL Server 2005 end of support, visit us at Microsoft.com.
Learn more about how Microsoft customers are already benefiting from upgrading and migrating to SQL Server 2014:

Stack Overflow uses SQL Server 2014 to provide reliable, high-performing technology to support its mission of providing lightning fast answers online.

Samsung Electro-Mechanics improved OLTP performance up to 24 times and DW up to 22 times when they upgraded to SQL Server 2014.

GE Healthcare delivers applications to healthcare providers worldwide using SQL Server 2014 and Microsoft Azure.

Callaway Golf reduced cost and improved scalability by moving servers to the cloud.

Click to expand...

Source: Are you still running SQL Server 2005? Now is the time to upgrade to a modern data platform - The Official Microsoft Blog

:)

chris-germany · Apr 13, 2015

Will my Business Contact Manager for outlook run under Windows 10?

SQL Server 2008 is not supported on Windows 10. Upgrade MSSMLBIZ Instance to SQL Server 2014 Express, and BCM will run perfectly.

Alberto Morillo · Apr 13, 2015

Windows Upgrade from 8 to 10

Hello,

When you say your Act database is version 2012, do you really mean is SQL Server 2012? The answer to that question is really important in order to provide you more accurate information and reach a solution. For instance, SQL Server
2008 R2 and earlier versions of SQL Server are not supported on Windows 10 while SQL Server 2012 is supported if you apply service pack 2 (SP2). For more information, please read the following article:

https://support.microsoft.com/en-us/kb/2681562

Users who upgraded to Windows 10 having installed on their computers versions not supported of SQL Server are complaining about having to start SQL Server services manually after the upgrade. To start SQL Server service manually,
please read the following article:

How to: Start an Instance of SQL Server (SQL Server Configuration Manager)

Please contact Swiftpage ACT! Support about the possibility of upgrading the database to a supported version.

Hope this helps.

Regards,

SQLCoffee.com

spapakons · Jan 5, 2016

Hello!

I have an computer running my old ERP program which was based on Microsoft SQL Server 2005. After upgrading from Windows 8.1 32-bit to Windows 10 32-bit it has some difficulties connecting to the database and launching the ERP application (user not found in base error). How can I safely upgrade to Microsoft SQL 2014? I installed the Upgrade Advisor and got a report, how do I proceed with the upgrade? Could I just download the Microsoft SQL Express 2014 and install it? Anything else to do?

Thank you in advance

EDIT: Solved! Found the culprit!

The computer has a small 80GB hard disk which was almost full with about 2-3GB free space. So I compressed the disk and now has about 15GB free. Except I unknowingly introduced an incompatibility! Microsoft SQL server doesn't work properly from a compressed folder. I had downloaded the Microsoft SQL Server 2014 Express and run it. Then I chose upgrade and it analyzed my current database before upgrading. Here was were I informed that I could not upgrade a compressed folder and was prompted to select another uncompressed folder. I immediately quitted the setup and proceeded to expand the "Microsoft SQL Server", "Microsoft SQL Server Compact Edition" folders and the EPR application folder. I restarted the computer and now it worked at once without any complain!

So anybody else having problems connecting to your SQL database, first make sure the Microsoft SQL Server folder in Program Files and any other relevant folders are NOT compressed!

Thank you for your time to read this.

Windows 10: Are you still running SQL Server 2005? Time to Upgrade.

Are you still running SQL Server 2005? Time to Upgrade.

Are you still running SQL Server 2005? Time to Upgrade.

Are you still running SQL Server 2005? Time to Upgrade.

Are you still running SQL Server 2005? Time to Upgrade. - Similar Threads - Are still running

Unable to apply SQL Server 2005 SP4 ENU on SQL 2005 ESN Installation

Unable to apply SQL Server 2005 SP4 ENU on SQL 2005 ESN Installation

SQL 2005

SQL 2005

How to uninstall Windows SQL Server 2005?

Microsoft sql server 2005

SQL Server 2005 Compact Edition

Microsoft SQL Server 2005 [ENU] no longer supported

lost SQL Server 2005