Lance Harra Blog

SQL DMO application

I have been working on a VB and SQL DMO application to script out all the objects in a database. I am using this to get snapshots of our development databases.  I have finished round 1 and can automatically script out all the user databases and objects on a specified server except for the DTS packages.  I have not found any info on scripting DTS packages via DMO.  I use this for servers where I do  not have the space to perform backups. (Yes I should have the space but that is another $$$ issue that management and I disagree on).  At least these scripts give me the ability to put the schemas back in the event of a disaster.

Legacy Comments


Tara
2003-10-24
re: SQL DMO application
DTS packages are stored in msdb.dbo.sysdtspackages. So you could bcp the data out into a file for backup purposes.

ValterBorges
2003-10-26
re: SQL DMO application
There is a method in DMO to save a package as a dts file that's how you'd script it out.

FGHF
2005-06-23
re: SQL DMO application
FGH

Steven
2005-11-21
re: SQL DMO application
Good!