SQL Server Performance

SQL 7 to SQL 2008 upgrade?

Discussion in 'General DBA Questions' started by TimE_DCT, Sep 21, 2009.

  1. TimE_DCT New Member

    I am currently running SQL 7 and need to upgrade to SQL 2008. Is this possible?
    TimE_DCT, Sep 21, 2009
    #2

  2. moh_hassan20 New Member

    Welcome to the forum
    You can not upgrade from sql 7 to sql 2008
    The minimum version to upgrade to sql server 2008 is SQL 2000 SP4
    review: http://msdn.microsoft.com/en-us/library/ms143393.aspx

    You can do one of the two methods:
    • - make upgrade to 2000 SP4 or to 2005 then sql2008 (the prefered method)
    • -generate schema /login script in sql 7 and execute them in sql 2008 , and use bcp to move the data ,
      review: http://msdn.microsoft.com/en-us/library/ms177398.aspx

    moh_hassan20, Sep 21, 2009
    #3

  3. satya Moderator

    Welcome to the forums.
    For you the ease of path is you can simply restore SQL 7 database to 2000 which is patched upto SP4 as per Moh's reference and then carry further.
    satya, Sep 21, 2009
    #4

  4. TimE_DCT New Member

    Thanks to both. With needing to upgrade to 2000 first, will it require a license other than the one for 2008?
    TimE_DCT, Sep 21, 2009
    #5

  5. satya Moderator

    How big is the database?
    How many users are using the SQL SErver 7 and for 2008?
    satya, Sep 21, 2009
    #6

Share This Page