August 5, 2003 at 6:15 am
Hello everyone
I am looking to perform some admin task programmatically and I believe SQL-DMO is the way to go about this. I have been looking through SQL BOL and I am having a little trouble finding samples of scripts or code for SQL-DMO. Does anyone have script/code (VB/VBA) samples that performs the following task?
Scripting a Database
Scripting a particular Table in a Database
Scripting of DTS package/packages
Scripting of a Job.
Any sample code/script will help. Thanks in advance.
August 5, 2003 at 7:39 am
Their is an excellent book out called "Real-World SQL-DMO for SQL Server" by Allan Michell and Mark Allison. It has all the code you are looking for.
Diane
August 5, 2003 at 4:12 pm
Have a look at http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1
Have used SCPTXFR.exe myself for awhile!
August 6, 2003 at 6:06 am
I am using the same book suggested by Diane.
This is very good book to learn many DBA tasks using SQL DMO
August 6, 2003 at 7:06 am
I took a look at the knowledge Base Article but it seems to be refering to Database Upgrade process from SQL6 to SQL7. I guess my main question is, does this program "SCPTXFR.exe" applies the same way in SQL 2K?
Have a look at http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1
Have used SCPTXFR.exe myself for awhile!
[/quote]
August 6, 2003 at 1:45 pm
DMO is the right tool for scriping. I've done a few DMO articles over the last couple years with lots of different examples:
http://www.sqlservercentral.com/columnists/awarren/allarticles.asp
Andy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply