Post reply

SQL 2000 -> 2008 migration: business case?

  • September 25, 2008 at 10:13 am

    #877144

    Haven't had time to reply to all

    but do want to ask, is the upgrade plan to SQL Server 2008 Enterprise, or Standard?

    A lot of features you mentioned are only available in Enterprise

    Data/Backup compression, Resource Governor, Transparent Data Encryption

    Auditing

    SQL Server 2008 Enterprise Edition includes all of the features described in this chapter, which

    includes both the SQL Auditing Foundation and Fine Grained Auditing. SQL Server 2008 Standard

    Edition only provides the SQL Auditing Foundation.

    It's worth visiting the Microsoft PDF for comparison

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

  • September 25, 2008 at 10:39 am

    #877169

    Thanks, Jerry.

    My assumption is that the editions used will mirror what we have, so 2000 Ent gets upgraded to 2008 Ent, and 2000 Std to 2008 Std. This simplification should be enough for the project proposal, and then the project team (if the project is approved) could get into the detail of what's needed.

    One reason for this is that the software costs will be much less than the labour and testing costs, so if we spend a few thousand extra on an Enterprise licence that we turn out not to need, it's not the end of the world - and none of the accountants need ever know 🙂

    Bill.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply