Difference between sql server 2005 and 2008

  • Hi guys..

    can anybody refere me any article or can tell me what's the basic difference between sql server 2005 and 2008, acutally i want to move to 2008 but, if there not much mager difference then i won't..

    Thanks and looking forward.

    -MALIK

  • The new features are summarized on https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470

    There are many new features, so it depends on what you need. If you store large files in SQL Server, migrated from Oracle and want to use date and time data types, need to encrypt your databases, etc you will definitely want to look at 2008. The nice thing is that it upgrading should be much easier from 2005 to 2008 than it was from 2000 to 2005.

    Regards,

    Andras


    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • I'd argue that if you are considering the move, and can wait until the fall, I'd go with 2008. There are now going to be releases every 2-3 years, which means you'll get about 6 years of support on a version. So if you go to 2005, you'll be considering an upgrade in 3 years, which you may not need. If you go 2008, you can still upgrade in 3 years if you want, but can wait 6 years if you don't need to.

  • The Denver SQL Server Users group has had some really good presentations over the last couple of months on the new features in SQL 2008 including one from Paul Nielsen just last week shortly after he got back from "Jump Start" up in Redmond (if I remember the name of the event correctly).

    A couple of caveats on all of the "new features" for SQL 2008, the triage to determine which features will be in the various editions is still in progress. Many/most of the new/very cool features like data compression, partitioned indexes, policies, etc. are only going to be in the enterprise edition. Unless you're planning on running enterprise edition a lot of the features that are in the CTP's will probably not be in SQL 2008 standard, etc.

    On other minor but often overlooked issue - SQL 2008 will only be 64-bit, if you're buying new hardware shouldn't be an issue but if you're planning on using existing hardware... also, if you've got dependencies on third party drivers (e.g. oracle) best be sure that a 64-bit version is available/works.

  • Good input. I was looking for these kinds of information.

    Webcast is also a good place to go. http://www.microsoft.com/events/series/technetsqlserver2008.aspx?tab=webcasts

  • Joe Clifford (2/25/2008)


    ...

    On other minor but often overlooked issue - SQL 2008 will only be 64-bit, if you're buying new hardware shouldn't be an issue but if you're planning on using existing hardware... also, if you've got dependencies on third party drivers (e.g. oracle) best be sure that a 64-bit version is available/works.

    This SQL Server 2008 version feature comparison implies that there will be a 32 bit version:

    http://download.microsoft.com/download/2/d/f/2df66c0c-fff2-4f2e-b739-bf4581cee533/SQLServer%202008CompareEnterpriseStandard.pdf

  • CC -

    I stand corrected; apparently there will be 32 bit versions of SQL 2008 which is a change from what I had read at CTP5, I thought it was pretty aggressive of MS to force folks to 64-bit, if I remember correctly they said that only developer would run 32-bit at that point in time.

    That document is dated 2/22/2008 and well worth a read, thanks for pointing it out. This is the first "official" thing I've seen that clarifies what will be in each version - just be sure to note the disclaimer on the bottom of each page.

    Joe

  • During recent Hero's (SQL 2008 + Server 2008 + VS 2008) events, MS SQL guys noted that NEXT release of SQL (2010+) will be 64-bit only. That bit of info has not been confirmed.

  • I've seen many times where MS said they plan on post Windows Server 2008 and SQL 2008 to be 64bit only. If you don't have a 64bit server by 2011, you have to be trying to not upgrade. With old memory holding stagnant for price drops and new kingston/crucial DDR2-667 ecc memory going for 2x2GB going for $120, how would someone not want a newer computer with those prices?

  • Could somebody refer a site where the differences between SQL Server 2008 and 2005 versions are detailed. Also, being a small sized organisation is it really necessary to upgrade to SQL Server 2008 ? What are the advantages of upgrading ?

    I would really appreciate help in this regard.:)

  • arijit_manna (11/1/2008)


    Could somebody refer a site where the differences between SQL Server 2008 and 2005 versions are detailed. Also, being a small sized organisation is it really necessary to upgrade to SQL Server 2008 ? What are the advantages of upgrading ?

    I would really appreciate help in this regard.:)

    http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx

  • Hii dude find the link ...http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx

  • SQL SERVER 2005:

    1.Both are combined as SSMS(Sql Server management Studio).

    2.XML datatype is introduced.

    3.We can create 2(pow(20))-1 databases.

    4.Exception Handling

    5.Varchar(Max) data type

    6.DDL Triggers

    7.DataBase Mirroring

    8.RowNumber function for paging

    9.Table fragmentation

    10.Full Text Search

    11.Bulk Copy Update

    12.Cant encrypt

    13.Can Compress tables and indexes.(Introduced in 2005 SP2)

    14.Datetime is used for both date and time.

    15.Varchar(max) and varbinary(max) is used.

    16.No table datatype is included.

    17.SSIS is started using.

    18.CMS is not available.

    19.PBM is not available.

    20.PIVOT and UNPIVOT functions are used.

    SQL SERVER 2008:

    1.Both are combined as SSMS(Sql Server management Studio).

    2.XML datatype is used.

    3.We can create 2(pow(20))-1 databases.

    4.Exception Handling

    5.Varchar(Max) data type

    6.DDL Triggers

    7.DataBase Mirroring

    8.RowNumber function for paging

    9.Table fragmentation

    10.Full Text Search

    11.Bulk Copy Update

    12.Can encrypt the entire database introduced in 2008.

    --check it(http://technet.microsoft.com/en-us/library/cc278098(SQL.100).aspx)

    (http://www.sqlservercentral.com/articles/Administration/implementing_efs/870/)

    (http://www.kodyaz.com/articles/sql-server-2005-database-encryption-step-by-step.aspx)

    (http://www.sql-server-performance.com/articles/dev/encryption_2005_1_p1.aspx)

    (http://geekswithblogs.net/chrisfalter/archive/2008/05/08/encrypt-documents-with-sql-server.aspx)

    13.Can compress tables and indexes.

    -http://www.mssqltips.com/tip.asp?tip=1582

    14.Date and time are seperately used for date and time datatype,geospatial and timestamp with internal timezone

    is used.

    15.Varchar(max) and varbinary(max) is used.

    16.Table datatype introduced.

    17.SSIS avails in this version.

    18.Central Management Server(CMS) is Introduced.

    -http://msdn.microsoft.com/en-us/library/bb934126.aspx

    -http://www.sqlskills.com/BLOGS/KIMBERLY/post/SQL-Server-2008-Central-Management-Servers-have-you-seen-these.aspx

    19.Policy based management(PBM) server is Introduced.

    -http://www.mssqltips.com/tip.asp?tip=1492

    -http://msdn.microsoft.com/en-us/library/bb510667.aspx

    20.PIVOT and UNPIVOT functions are used.

    -http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

    --

    Thanks & Regards,
    N.S.Sathish(SQL DBA)

Viewing 15 posts - 1 through 15 (of 17 total)

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