January 19, 2009 at 8:59 am
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!
January 19, 2009 at 9:38 am
SSIS would be perfect for this task.
Or you could try a backup/restore
January 19, 2009 at 11:54 am
I need to copy the database every night on a scheduled basis. In this case, is it better to use SSIS and schedule it to run daily? If so, which SSIS tasks I can use? Thanks.
January 19, 2009 at 12:09 pm
Yes SSIS would be able to dp this nightly, schedule it as a job to run each night.
The best/easiest place to start would be open a new SSIS project and run the import/export wizard to get started, then modify this package to suit your needs.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply