I have an application that I wrote in VB 2005 that accesses data in SQL 2000. There are currently 3 environments here; Production, Test and Dev. I created a DTS package that I use to copy the production data to the test environment. I want to allow the client to click a button in the app and have this data transfered.

OK. Now to the question.
- Do I push the DTS DLLs to the users and allow them to call the DTS package?
- Do I just create a backup and restore Stored Procedure and let them call that? (The databases are all on the same server.)

I don't really want to take the time to determine which DLLs to push, plus it will make the deployment files that much larger, not to mention that the DTS mechanism is a lot slower than a backup and restore. The only drawback to the backup and restore mechanism is that it will generate a file on the server with no easy way to delete it.