Aluminum
Ten Centuries
Points: 1152
More actions
June 18, 2009 at 9:18 am
#133246
I have a disaster recovery server. It is constantly restoring a database from another server. How can I synchronize the agent jobs and SSIS packages between the two servers?
Steve Jones - SSC Editor
SSC Guru
Points: 736478
June 18, 2009 at 12:07 pm
#1011971
Moved to 2005 forums.
The only way I've seen to synchronize these is manually. You need to script them out and move them as they change.
June 18, 2009 at 12:15 pm
#1011974
I found this:
http://www.databasejournal.com/features/mssql/article.php/3734096/Using-dtutil-to-copy-SSIS-packages-stored-in-SQL-Server.htm
But I was hoping to get away from xp_cmdshell
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply