Using SMO with Oracle?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All,

Microsoft has Sql Server Management Object (SMO) for use with Sql Server
databasess.
Is there something simliar for using ADO.NET with an Oracle
database?

Thanks in advance.
 
SMO is SQL Server specifi management object model. So, no way to use it with
Oracle.

I do not know if there is similar thing offered from Oracle to do the
simillar thing with Oracle database.
 
Found the answer on Oracle's web site.
Use Oracle Data Provider for .NET (ODP.NET).

However their ADO.NET version is currently in beta (10.2.0.2.10)
 
Not directly. Oracle has some libraries for access and if you have proper
permissions you can query the tables necessary to get the same type of
information with the OracleClient namespace objects, but it is not as simple
as SMO.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************
 
Back
Top