Need suggestions for refreshing the latest version of PROD server DTS packages in DR server
Posted on 2016-09-09
could you point me the best way to refresh the latest version of DTS packages in DR server from Prod server.
As per the various blogs there are many ways we can achieve, but what could be the best and easy practices bearing any issue it would pose or anything i must do pre or post activity?
Please note PROD and DR server are running with SQL server 2008 R2 enterprise edition and the packages are DTS 2000.