Re: backupRestore progress bar

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 23:36:02 +0200

hi,
"dev" <anonymous@discussions.microsoft.com> ha scritto nel messaggio
news:07DA4684-529D-48D5-9D6A-56DDFDB077A7@microsoft.com...
> oh no.. so what is this sql-dmo. What is the purpose of it's existance.
Why do we need it
>(besides for the progress bar). How is it different from programming with
T-SQL. How can
> we choose which way to go, T-SQL or SQL-DMO. What are it's advantages and
disadvantages.
>
> Thanks

SQL-DMO is an acronym for SQL Distributed Management Object and is a full
object model to manage and administer SQL Server..
it exposes a nice object model you can navigate to perform quiet all
management tasks on SQL Server..
it's not designed for data manipulation even if it provides some features
to.
it comes with MSDE and/or can be installed from the Client Tools
installation package of SQL Server.
it is not provided as a separate download and/or package, so you have to
depoly it yourself in MSDE scenarios (you are legitimate to) ... this can be
count as a disadvantage too :-)
it's a little buggy =;-) and eats a lot of memory, but is very handy for
some admin scenario....

Transact-SQL, on the contrary, is the language SQL Server better understand,
and can perform both data manipulation and administration tasks... it's a
separate language where DMO is just a COM object model you can use in any
COM compliant client, so they can not be compared... you shoul'd stick with
Transact-SQL, and use DMO where and when appropriated...
by the way... there's only 1 book worth reading about SQL-DMO, by SQL Server
MVPs Allan Mitchell and Mark Allison,
http://www.compman.co.uk/cgi-win/browse.exe?ref=552118 , which I personally
recommend reading...

FWIW, you can have a look at a free prj of mine at the link following my
sign to have an idea aboout what you can do with SQL-DMO, a prj that
provides a user interface similar to Enteprise Manager written in VB6 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.8.0  -  DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Relevant Pages

  • Re: Problem Executing Stored Procedures
    ... Both SQL Server and Agent are running under the Local System account so they ... should have enough privileges. ... The same application that is having problems with SQL-DMO also uses SQL-DMO ... and both procedures you are mentioning are run with success... ...
    (microsoft.public.sqlserver.msde)
  • Re: "Best Practices" way to distribute MSDE
    ... if SQL-DMO is locally present) and try a connection to the server... ... if you can't connect with that login, ... object privileges... ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • RE: How to find available SQL Server on local network
    ... QueryInterface for interface SQLDMO.NameList failed??? ... > You can do this using SQL-DMO. ... > You can also connect to an SQL Server instance and enumerate all objects for ... >> Using VB.NET how can I find all available SQL Server on a local network and ...
    (microsoft.public.dotnet.general)
  • RE: How to find available SQL Server on local network
    ... Doesn't it show instances installed on local machine? ... > You can do this using SQL-DMO. ... > You can also connect to an SQL Server instance and enumerate all objects for ... >> Using VB.NET how can I find all available SQL Server on a local network and ...
    (microsoft.public.dotnet.general)
  • Re: ODBC and SQL Server and VBA
    ... You can execute commands from an ADO Connection or Command object. ... DNS address for the remote machines but In SQL Server there is no way that I ... What VB object model reference is needed? ...
    (microsoft.public.data.odbc)