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!