We have a SQL 2000 database and a SQL 2008 data warehouse. The first must be copied each night to the second. Sometimes small changes are done on the first. We're trying to do a bulk copy that also copies the schema.
Before the 2008 upgrade, we used DTS for that. But now we're using Integration Services. IS seems to be unable to copy the schema like DTS can.
How to do this efficiently and flexibly?