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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-01 : 11:04:38
|
Pete writes "I have several DTS packages created and saved to a standard msdb database. I want to use this msdb database to replace all newly install standard msdb databases that I have accross many states.
I have two options / Questions:
1. Backup the msdb to disk. Automate by writing a batch file couple with an osql script to restore from the backup disk by replacing the existing msdb database. This is what I would prefer but I am not sure of the implications would be due the different server?
2. The manual way. Save the packages to file on disk then use Enteprise Manager Data Transformation Services to open and save to the Local Server(mdsdb) database. I tested this process. It works fine, but I prefer not to have my installer to navigate to Enterprise Manager. Is there an easy way to scripting to a batch file and run the batch file to save the package files from disk to the msdb database?
Please let me know if there a better way or any suggestions will be greatly appreciated.
Thanks.
Pete" |
|
|
|
|
|
DTS package distribute to many msdb databases