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! |
mosi_8008
2006-08-30 |
Hacked by M.8008 HAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACK hack |