Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2009-01-19 : 11:19:52
|
| 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 2008I have only 2 source tables in the source db. Please let me know which one will be the best way of doing this. Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2009-01-19 : 14:07:51
|
| Shall I use SQL scripts for the backup/restore and schedule those sql scripts as part of sql job? Thx. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Copy the database from sql 2000 to sql 2008