Upgrade to SQL 2005?

Posted on 2007-08-08
Last Modified: 2010-03-19
I have a client that is upgrading an accounting package that is currently installed on Windows 2003 SBS Premium and is using SQL 2000. The new accounting upgrade supposedly works in SQL 2000 or 2005.  Would there be any advantage or reason to upgrade to SQL 2005?  Would that be done by adding SQL 2005 to the SBS or would we just upgrade to SBS R2?
Question by:baggio8
    LVL 6

    Accepted Solution

    At this point there may not be an advantage to upgrading to SQL2005.

    It is a superior piece of software in that it has additional features,  but at the same time it is more resource intensive (especially on tempdb). If it will just be the backend for another piece of software you may not need those additional features.

    In the longterm it is good to upgrade the software for future compatibility (i.e. the next version of your accounting software may not support SQL2000).

    If you are to choose the path to upgrade you wouldn't necessarily need to upgrade to SBS R2, although that would be a good idea. You would want to install or upgrade SQL 2000 to 2005.

    Microsoft has some migration paths on MSDN that could guide you through this process.

    Author Comment

    DantheDBA,As it turned out I had to update to SQL 2005 for the requirements of the accounting package.  The free standing copy of SQL 2005 for Workgroups was $1499, but the upgrade to SBS R2 was only $699.  Obviously I chose the SBS R2 upgrade.  Thanks for your comments.


    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now