Post reply

Sql Server Enterprise vs Standard

  • May 16, 2006 at 11:26 am

    #172565

    Hello,

    I have a question.

    I want to migrate from mySql to Sql Server, and I should decide which version will I use.

    The problem is that I need partitioning, and it is included only in the Enterprise version. But the Enterprise version costs 5 times more than the standard and the workgroup version.

    Is it worth to spend so much money only for the partitioning?

    Also, maybe I am wrong, and the partitioning is also included in the Standard version?

    Thanks,

    Edi.

  • May 16, 2006 at 4:35 pm

    #638307

    http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

  • May 17, 2006 at 9:23 am

    #638464

    Partitioning is available only in the Enterprise Edition.  Enterprise Edition has MANY other features as well that help increase availability such as Database Snapshots and Asynchronous Database Mirroring to name just a couple.  Before spending the $$$ for Enterprise, try out the Developer or Enterprise Evaluation Editions first to see if Partitioning really solves the problem that you have.  I think that Partitioning is a really neat feature, but I would want to have more pushing me to Enterprise Edition than just one feature.  It may end up that other features in Enterprise Edition will be more valuable to you than Partitioning.  BTW, Partitiioned Views are available in Standard Edition - perhaps that will help you out.  PVs do not have the exact same benefits that you have with Partitioned Tables, but it might be worth some investigation to find out.

  • May 17, 2006 at 2:23 pm

    #638556

    Got it.

    I will probably use the Workgroup or Standard edition to try it first.

    Thanks,

    Edi.

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

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