Re: Data modelling tool - Seeking for recommendations

Hi Don,

Excellent Michael! But, the bad news is I downloaded the trial and cannot get it reverse engineer my Oracle 10g db. I tried using ODBC, ADO, and several drivers to import into the ORACLE8 target. Don't know if this is the best place to discuss this and I don't see forums on your site. I can detail the steps I took and the results here if you like or we can go to email when you return from vacation. My email is: dons at hammerpackaging dot com.
Your best bet on reverse engineering Oracle would be to extract
SQL script into file and then reverse engineer the script. This way you
should be able to get most information.
Using ADO you should be able to get tables, columns, indexes and possibly
relationships & views, depending on the capabilities of ADO Provider.
ODBC will only return you tables, columns and indexes.

Please, e-mail me if still have problems with this and unable to
get at least tables, columns & indexes.

Regards,
Michael




"Michael Baytalsky" <mike@xxxxxxxxxxxxxxx> wrote in message news:44d11a6e$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Thank you, Michael. That would be great. If you do that, you've definitely got yourself a new customer.
Nice to hear that ;). I've done it already today - took about 20
minutes as you may guess, however I can't release 2.09 until Aug 15th
... cause I'm going on vacation tomorrow for 1 week ;). Please
bear with us till mid August and you'll have it alone with few
more things.


.

Relevant Pages

  • ADO.NET and ODBC { CALL ..... } Syntax
    ... Coonecting to Oracle 8i DB running on Unix ... ADO is used as connecting mechanism ... OleDB connection with provider as MSDAORA. ... Especially the using ODBC Call syntax to fetch the data either via Stored ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OO4O 2.1 vs MDAC
    ... We're planning to move VB3 using OO4O 2.1 ... Now I must distinguish and list out some of the features that ADO / ... (OLE DB or ODBC) ... Also you don't mention the Oracle version there are differences between ...
    (microsoft.public.data.ado)
  • Re: Ado Oracle Performance
    ... > seconds while the same query thru sql explorer using the same ODBC ... > connection completes in 1-2 seconds. ... > Is ADO that slow or are there properties/ cache that i need to set. ... Instead of using ODBC use the Oracle ...
    (borland.public.delphi.database.ado)
  • Re: TADO table open exception
    ... > design time that the data can be loaded to a dbgrid by opening the TADO ... Why are you using ODBC and ADO together? ... Oracle has its own OLE DB provider which AFAICR is ...
    (borland.public.delphi.database.ado)
  • Re: ADO.NET and ODBC { CALL ..... } Syntax
    ... > Coonecting to Oracle 8i DB running on Unix ... > OleDB connection with provider as MSDAORA. ... > the same way as it works in ADO arena. ...
    (microsoft.public.dotnet.framework.adonet)