SQLDMO, I am looking for examples/code excerpts, etc

12 Aug 2005 7:31 AM

Enric

Dear folks,

I am not familiarised with SQLDMO and right now I would need some examples
of how it works; concretely my upcoming dutie is to do a little app in VB
using this data library and pulling data and launching some DML, nothing
else. I have always used DAO, RDO or ADO with Visual Basic and although, at
first it seems very intuitive, very similar ADO (
SQLDMO.database,SQLDMO.SQLServer,SQLDMO.table) in order be faster any example
or related link would be welcomed.

Thanks so much for your help,

Enric

12 Aug 2005 8:09 AM

Mike Hodgson

SQLDMO Examples from MSDN Library
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_ex02_6x7z.asp

--
*mike hodgson*
blog: http://sqlnerd.blogspot.com

Enric wrote:

Show quote

>Dear folks,
>
>I am not familiarised with SQLDMO and right now I would need some examples
>of how it works; concretely my upcoming dutie is to do a little app in VB
>using this data library and pulling data and launching some DML, nothing
>else. I have always used DAO, RDO or ADO with Visual Basic and although, at
>first it seems very intuitive, very similar ADO (
>SQLDMO.database,SQLDMO.SQLServer,SQLDMO.table) in order be faster any example
>or related link would be welcomed.
>
>Thanks so much for your help,
>
>Enric
>
>

12 Aug 2005 9:35 AM

Chris Cheney

"=?Utf-8?B?RW5yaWM=?=" <En***@discussions.microsoft.com> wrote in
news:E4A220E7-7043-44A5-BDD9-CD23122CCD43@microsoft.com:

> I am not familiarised with SQLDMO and right now I would need some
> examples of how it works; concretely my upcoming dutie is to do a
> little app in VB using this data library and pulling data and launching
> some DML, nothing else. I have always used DAO, RDO or ADO with Visual
> Basic and although, at first it seems very intuitive, very similar ADO
> ( SQLDMO.database,SQLDMO.SQLServer,SQLDMO.table) in order be faster
> any example or related link would be welcomed.

Be aware that DMO was designed for managing SQL Server, rather than for data
processing. If you attempt queries with a large resultset, it will be very
slow - ADO will be much faster for that sort of thing.

12 Aug 2005 9:47 AM

Enric

Chris,

I though the contrary... so then SQLDMO is not so faster than ADO? It seems
works at most low level.
Thanks anyway and regards,

Show quote

"Chris Cheney" wrote:

> "=?Utf-8?B?RW5yaWM=?=" <En***@discussions.microsoft.com> wrote in
> news:E4A220E7-7043-44A5-BDD9-CD23122CCD43@microsoft.com:
>
> > I am not familiarised with SQLDMO and right now I would need some
> > examples of how it works; concretely my upcoming dutie is to do a
> > little app in VB using this data library and pulling data and launching
> > some DML, nothing else. I have always used DAO, RDO or ADO with Visual
> > Basic and although, at first it seems very intuitive, very similar ADO
> > ( SQLDMO.database,SQLDMO.SQLServer,SQLDMO.table) in order be faster
> > any example or related link would be welcomed.
>
> Be aware that DMO was designed for managing SQL Server, rather than for data
> processing. If you attempt queries with a large resultset, it will be very
> slow - ADO will be much faster for that sort of thing.
>

12 Aug 2005 12:40 PM

JT

ADO would be the choice for querying data into client side recordsets.
DMO would be a better choice for interfacing with bulk copy, deleting
tables, enumerating lists of database objects, etc. becuase it provides an
object model designed specifically for that.
That are some sample applications that come bundled on the SQL Server
install CD. One of them is a Visual Basic 6.0 application that uses DMO to
create a simplistic Enterprise Manager like GUI.

Show quote

"Enric" <En***@discussions.microsoft.com> wrote in message
news:DFC7F56E-12B3-4380-A85A-ADAC6EBAC440@microsoft.com...
> Chris,
>
> I though the contrary... so then SQLDMO is not so faster than ADO? It
> seems
> works at most low level.
> Thanks anyway and regards,
>
> "Chris Cheney" wrote:
>
>> "=?Utf-8?B?RW5yaWM=?=" <En***@discussions.microsoft.com> wrote in
>> news:E4A220E7-7043-44A5-BDD9-CD23122CCD43@microsoft.com:
>>
>> > I am not familiarised with SQLDMO and right now I would need some
>> > examples of how it works; concretely my upcoming dutie is to do a
>> > little app in VB using this data library and pulling data and launching
>> > some DML, nothing else. I have always used DAO, RDO or ADO with Visual
>> > Basic and although, at first it seems very intuitive, very similar ADO
>> > ( SQLDMO.database,SQLDMO.SQLServer,SQLDMO.table) in order be faster
>> > any example or related link would be welcomed.
>>
>> Be aware that DMO was designed for managing SQL Server, rather than for
>> data
>> processing. If you attempt queries with a large resultset, it will be
>> very
>> slow - ADO will be much faster for that sort of thing.
>>

12 Aug 2005 12:52 PM

JT

You are intending to use DMO for administrative type operations on the
database, then perhaps consider using Windows Scripting Host (WSH) instead
of a compiled VB application. VBScript can be viewed and edited in notepad
and would be more easily maintained by the DBA.
http://www.microsoft.com/technet/scriptcenter/default.mspx
http://www.microsoft.com/technet/scriptcenter/scripts/sql/default.mspx

Show quote

"Enric" <En***@discussions.microsoft.com> wrote in message
news:E4A220E7-7043-44A5-BDD9-CD23122CCD43@microsoft.com...
> Dear folks,
>
> I am not familiarised with SQLDMO and right now I would need some examples
> of how it works; concretely my upcoming dutie is to do a little app in VB
> using this data library and pulling data and launching some DML, nothing
> else. I have always used DAO, RDO or ADO with Visual Basic and although,
> at
> first it seems very intuitive, very similar ADO (
> SQLDMO.database,SQLDMO.SQLServer,SQLDMO.table) in order be faster any
> example
> or related link would be welcomed.
>
> Thanks so much for your help,
>
> Enric