WMI
-
Hi Andy,
I read an acticle about WMI by Robert Viera and he indicated that SQL-DMO will soon be face out and will be replaced by WMI.
Is it WMI is the right tool? what are the benefits?
-
I have heard that, don't know if it's definite. I guess the advantage is that if you can manage one product with WMI you can manage them all. I've only looked at it briefly, a while back, and wasn't impressed. I have a hard enough time convincing people to try DMO!
Do you have the link to the article you mentioned handy? I'd like to read it and other readers may be interested as well.
Andy
-
The book is 'Professional SQL Server 2000 Programming' by Robert Viera and publisher is Wrox. Chapter 32/ page 1174. It says
- SQL-DMO is no longer the recommended approach to manage your SQL Server System.
- WMI will become the standard way to manage your database.
- Aside from the unique feature tha WMI bring to the table, there are a few reasons why SQL-DMO is being phased out in favor of WMI. and .....
-
I am not sure that WMI will become the end all management tool for everything. I
have used : ADSI / WMI / DMO in projects I have done before, and AFAIK they all
provide quite different funtionality. ADSI and WMI sometimes overlap, but that
is often only in a few namespaces like WinNT, but there are things that each one
can do that the other can not. More often than not I see scripts with
combinations of the varying technologies to perform tasks. None of the tools
overlap with DMO though, as it was designed to manage SQL Server. I like DMO too
Andy. And I have greatly enjoyed your aticles on DMO.
I use ADSI to :
-Use Exchange as contacts repository (Has one of the best
contact DB's out there that hardly anyone ever uses with their apps)
-To manage Active Directory
-Used to use it to manage NT before WMI, including Users, Groups, Printers,
Shares, Services, etc...
-etc...
I use DMO to :
-Manage SQL server
-generate automated code
-backup / restore / scripting com objects that extend the DMO functionality
-etc...
I use WMI to :
-Manage NT
-Remotely run tasks (Remote WSH can do this as well)
-Run backups on event logs, including scans for specific errors
-etc...
As a software developer who is a quasi-modo NT administrator / dba I have done
most of these scripts at one company or another that I have worked at. Together
these tools combined make my life easy. I have just found a book that finally
talks about all 3 from an admin scripting point of view. (actually a tome) I
bought it aminly for the WMI knowledge because I am still in the process of
absorbing that technology.
Jack of all trades, Master of one.
Tim C.
//Will write code for food
Tim C //Will code for food
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply