Post reply

Comparison of SQL 2005 and SQL 2008

  • November 4, 2009 at 1:12 am

    #213183

    Hi,

    We are using SQL Server 2005 and .Net framework 2.0 to develop our application and following features of SQL Server 2005.

    1)Data partitioning

    2)Transaction Replication

    3)SSIS

    4)SSRS

    I want to suggest my customer to migrate database from SQL 2005 to SQL 2008. But before that can anyone let me know that what benefits of SQL server 2008 I should tell my customer for example

    1)How it affect the application performance

    2)How it is easy to maintain database in SQL 2008 compare than SQL 2005.

    3)……………….

    Regards

    Raj

  • December 7, 2009 at 7:57 pm

    #1088981

    What you'll most likely see is enhanced performance, especially in SSRS with large result sets. While SQL 2008 has the major version number of 10 it is really (IMO) really 9.5 and SQL 2008 R2 is more like 9.9. However, the upgrade path is fairly painless from 2005 to 2008.

    I'm curious how you are using transactional replication, I haven't been a big fan for a long time and am always curious..

    CEWII

  • December 8, 2009 at 10:19 am

    #1089360

    There are many new features in SQL 2008 that make it worth upgrading to.

    I have complied a list of the easiest features to sell a client on.

    http://chrisbarba.wordpress.com/2009/03/29/whats-new-in-sql-2008/[/url]

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

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