SQL-DMO for Beginners
-
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/sqldmoforbeginners.asp
-
Good article with detailed explanation for programmers who are new to SQL DMO.
Thanks
Prakash Machiraju
-
Overall this is a good article. The point about blank "sa" passwords was well done! The only thing I would change would be to name the text box and the controls and not leave them as the default command1 etc. Examples should always illustrate good programming habits. Your ample comments are a good model to follow.
-
Thanks both of you. And I agree. I should rename the controls, even if this is the simplest form
, I may reuse it. And may want to reference the control from another place.I'll be sure to clean that up in part 2!
Steve Jones
-
As a dba with very little programming experience I've used sql-dmo in the past in a vb6 app doing the simple task of comparing and promoting tables and stored procedures throughout development, test and production environments..
I'm curious though, what practical applications are there for sql-dmo? Scratching my head and wondering I came up with only a few scenario's. I've seen backup management programs written using sql-dmo. The only time I'd use sql-dmo is if I (pretending I was a programmer) if I had to create a database and oodles of objects. An erp package is a great example of this. And I wanted to do this programmatically.
About the cleanup tasks, good job for mentioning! At the time I'd written my app I had to laugh at myself when looking at all the silly dmo connections left behind on every server I touched.
-Ken -
Great article. This should have came out before I wrote my first SQLDMO app. I remembered I was having a hard time with that using only the Object Browser and some random net resources. Andy offered great help that time.
This one is very suitable for newbies like me. Hopefully, we'll tackle the more complex issues soon. Right now, I'm still lost with the last problem I encountered regarding my logins being erased after restore. For more info, here's the link http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6053&FORUM_ID=22&CAT_ID=2&Topic_Title=SQLDMO%2ESQLRestore+erases+loginames&Forum_Title=DMO
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett -
Can you update that thread with what you have for code now? We'll work on it some more! Also, what would you consider good examples of complex issues?
Andy
, I may reuse it. And may want to reference the control from another place.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply