• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 61
  • Last Modified:

Need suggestions for refreshing the latest version of PROD server DTS packages in DR server

Hi there,
  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.

Regards
Deepak
0
Deepak Kumar
Asked:
Deepak Kumar
  • 2
2 Solutions
 
David Johnson, CD, MVPOwnerCommented:
Backup/copy/rename/restore seems to be the best way and it can be scripted.
https://blogs.msdn.microsoft.com/psssql/2009/02/18/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008/

You really should move to SSIS packages though.
0
 
Eugene ZCommented:
if it is a DR server for your PROD -- backup on prod and restore on DR the msdb database (where we assume DTS stored, unless you keep them in some folder ).
Just do not forget to disable sql jobs on DR server after MSDB restored (it will bring not just SSIS DTS  but, sql agent jobs, etc

more:

 Support for SQL Server 2000 DTS in SQL Server 2008 R2
 https://msdn.microsoft.com/en-us/library/bb500440(v=sql.105).aspx
0
 
David Johnson, CD, MVPOwnerCommented:
cleanup
0

Featured Post

Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now