Future of SQLDMO

[Guest]

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 Bouma [C# MVP]]

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

--

 

[William \(Bill\) Vaughn]

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.
__________________________________

 

[Val Mazur \(MVP\)]

Hi,

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