David Kearns Central RSS 2.0
# Friday, November 03, 2006

So you've been backing up your server, and it fails. You restore all of your databases, but onto a fresh install. You don't restore the system tables because you aren't using the same OS or Hardware or something, and aren't sure that's a good idea. But where are your DTS scripts? You need them, and don't have any other copies since they're a friggin' pain to develop in a development environ.

This article will try and explain the different ways you can transfer (DTS) packages between servers and other storage locations, either directly or as files. The most common requirement is to transfer between two SQL Servers, and this is the main focus here, but some methods can be adapted for any of the other storage locations....

You can also use a simple DataPump task to transfer the contents of sysdtspackages directly between servers...

[ Transferring DTS Packages ]

Come on, could it be that easy? Seems to be so far...

Thank you Internet, bawk bawk!

Friday, November 03, 2006 1:40:38 PM (Eastern Standard Time, UTC-05:00)  #    Comments [0] -
admin
Comments are closed.
Archive
<November 2006>
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789
Blogroll
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions.

© Copyright 2010
David Kearns
Sign In
Statistics
Total Posts: 1300
This Year: 1
This Month: 0
This Week: 0
Comments: 1761
Themes
Pick a theme:
All Content © 2010, David Kearns
DasBlog theme 'Business' created by Christoph De Baene (delarou)