replacement for SQLDMO??

  • Thread starter Thread starter Paul M
  • Start date Start date
P

Paul M

Hi there,

i am trying to find out what is the replacement in .NET for the SQLDMO
object which reads system objects and properties from SQL Server databases,
eg, stored procedures, tables, views, s/proc parameters,etc...?

thanks,
 
Hi there,

i am trying to find out what is the replacement in .NET for the SQLDMO
object which reads system objects and properties from SQL Server
databases, eg, stored procedures, tables, views, s/proc
parameters,etc...?
Click to expand...

There is no replacement. SQL-DMO is perfectly usable from .NET, as
the COM library will be wrapped automatically for you by VS.NET. Be sure to
use SP2 or higher on sqlserver 2000

FB
 
thanks for your prompt reply.

regards,
Paul.

Frans Bouma said:
There is no replacement. SQL-DMO is perfectly usable from .NET, as
the COM library will be wrapped automatically for you by VS.NET. Be sure to
use SP2 or higher on sqlserver 2000

FB
Click to expand...
 
i am trying to find out what is the replacement in .NET for the SQLDMO
object which reads system objects and properties from SQL Server databases,
eg, stored procedures, tables, views, s/proc parameters,etc...?
Click to expand...

Visual Studio "Whidbey" (due out this fall) will ship with a new set
of managed objects called "SMO - Server Management Objects" to replace
SQL-DMO.

Until then, you're either forced to use SQL-DMO, or then just bind to
the SQL Server by means of ADO.NET and then query the
INFORMATION_SCHEMA views inside SQL Server for your metadata info.

Marc
================================================================
Marc Scheuner May The Source Be With You!
Bern, Switzerland m.scheuner(at)inova.ch
 
Back
Top