SQL Server Performance

Copy the database from sql 2000 to sql 2008

Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by sqlserverdeveloper, Jan 19, 2009.

  1. sqlserverdeveloper New Member

    I am planning to use either one of the following to copy the data from sql 2000 DB to sql 2008 database:
    1. SSIS: to copy only the new changes over to the sql 2008 DB from SQL 2000 DB.
    2. Merge function of sql 2008
    I have only 2 source tables in the source db. Please let me know which one will be the best way of doing this. Thanks!
    sqlserverdeveloper, Jan 19, 2009
    #2

  2. moh_hassan20 New Member

    i prfere method 1:
    SSIS: to copy only the new changes over to the sql 2008 DB from SQL 2000 DB.
    moh_hassan20, Jan 20, 2009
    #3

Share This Page