Future of SQLDMO

What is the future of SQL DMO? Samples are available to interop DMO in C#.
There is no equivalent of SQL DMO in .NET world. Will it be part of ADO.NET
technology? What is the roadmap for DMO releases?
Another thing is SQL DMO is MS SQL server specific. How about other
databases like Oracle and DB2?

Frans
Tue May 03 04:13:56 CDT 2005

AJ wrote:
> What is the future of SQL DMO? Samples are available to interop DMO in C#.
> There is no equivalent of SQL DMO in .NET world. Will it be part of ADO.NET
> technology? What is the roadmap for DMO releases?
> Another thing is SQL DMO is MS SQL server specific. How about other
> databases like Oracle and DB2?

Any database system accepts DDL in SQL form. This means that you can
admin your RDBMS system through SQL without problems, thus also without
SQL-DMO, and just use ADO.NET.

FB

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

William
Tue May 03 12:57:45 CDT 2005

SQLDMO is being replaced with SMO in the Yukon timeframe. It's faster,
smarter and more comprehensive. No, it won't be part of ADO.NET, but it is a
managed set of classes that can be accessed like any extension to the .NET
Framework.
Other databases will have their own DDL/DML interfaces and no, they will
need proprietary their own interfaces. SQLDMO was always just for SQL
Server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"AJ" <AJ@discussions.microsoft.com> wrote in message
news:F0AEDAD3-DCFB-4C55-B785-34C32935068C@microsoft.com...
> What is the future of SQL DMO? Samples are available to interop DMO in
> C#.
> There is no equivalent of SQL DMO in .NET world. Will it be part of
> ADO.NET
> technology? What is the roadmap for DMO releases?
> Another thing is SQL DMO is MS SQL server specific. How about other
> databases like Oracle and DB2?
>

Val
Tue May 03 17:43:53 CDT 2005

Hi,

It will be SMO (not DMO) when SQL Server 2005 will be released and it is
based on .NET managed code

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"AJ" <AJ@discussions.microsoft.com> wrote in message
news:F0AEDAD3-DCFB-4C55-B785-34C32935068C@microsoft.com...
> What is the future of SQL DMO? Samples are available to interop DMO in
> C#.
> There is no equivalent of SQL DMO in .NET world. Will it be part of
> ADO.NET
> technology? What is the roadmap for DMO releases?
> Another thing is SQL DMO is MS SQL server specific. How about other
> databases like Oracle and DB2?
>