Using SMO with Oracle?

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

Norman Yuan

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

Guest

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)
 
C

Cowboy \(Gregory A. Beamer\)

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!
*************************************************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SMO with Oracle? 1
Using SMO for SQL Server 2008 Express AND SQL Server 2005 Express 6
Where is SMO? 2
Problem with Restore (SMO) PercentCompleteNotification 2
Check if table has LOB columns 1
SQL Server Management Objects (SMO) 4
SMO question 1
Backup MSSQL db from C# code using SMO without knowing server version 7

Top