Re: Reverse Engineer Oracle Database
From: Carlos J. Quintero [.NET MVP] (carlosq_at_NOSPAMsogecable.com)
Date: 01/12/05
- Next message: micc: "Upgrading Visual C++ Projects to Visual Studio .NET in Batch Mode"
- Previous message: Gary Chang[MSFT]: "RE: Button not function"
- In reply to: MGBloomfield: "Reverse Engineer Oracle Database"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 12 Jan 2005 10:45:46 +0100
I don´t know much about the modeling tools of VS.NET but about Oracle:
1) Microsoft Data Access Components (MDAC) should be installed on your
machine (it is a prerequisite of VS.NET) and provides Microsoft ODBC drivers
for Oracle (see Control Panel, Administrative tools, ODBC Data Sources item,
Drivers tab) and OLE DB Providers for Oracle (create a file with .udl
extension, open it and see the Provider tab).
2) VS.NET 2003 supplies a Microsoft .NET Data Provider for Oracle, just in
case your modeling tool uses .NET Data providers instead of ODBC drivers or
OLEDB Providers.
3) Apart from those Microsoft components, Oracle provides also an ODBC
Driver, an OLEDB Provider and a .NET Data Provider, but Microsoft components
should work fine with Microsoft modeling tools.
4) ODBC Drivers from from Microsoft or Oracle require Oracle 7.3 or higher,
and OLEDB Providers require Oracle 8 or higher. So, I hope that "Oracle
database version is 7.1.something" was a typo, because otherwise it's going
to be difficult. Oracle 7.1 is really aged.
-- Carlos J. Quintero MZ-Tools 4.0: Productivity add-ins for Visual Studio .NET You can code, design and document much faster. http://www.mztools.com "MGBloomfield" <MGBloomfield@discussions.microsoft.com> escribió en el mensaje news:C434218A-F606-42BD-BB45-E432DCF375DB@microsoft.com... >I need to Reverse Engineer an Oracle Database into a Logical diagram. > > As a consultant, I have Visual Studio .NET 2003 Enterprise Architect (yeah > baby!) on my laptop. > > Oracle database version is 7.1.something > > Unfortunately, I don't have Oracle database drivers on my laptop so VS.NET > is not able to make the connection to Oracle. > > Installing the appropriate Oracle database drivers from Oracle.com > requires > the "Oracle Universal Installer" which I'm not able to find. I've tried > installing their "Instant Client" to get the drivers but that also > requires > "Oracle Universal Installer". I'm stumped. > > Using the client's machine, I'm able to get Oracle SQL Scripts (DDL). > Perhaps there's a way for VS.NET to reverse engineer using the DDL script? > I've searched VS.NET Help and didn't find anything. > > Or, perhaps, use Oracle SQL Scripts (DDL) to create the database on my SQL > Server. Then, reverse engineer the SQL Server? > > This is my first time dealing with Oracle databases. > > Any suggestions? >
- Next message: micc: "Upgrading Visual C++ Projects to Visual Studio .NET in Batch Mode"
- Previous message: Gary Chang[MSFT]: "RE: Button not function"
- In reply to: MGBloomfield: "Reverse Engineer Oracle Database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
