Re: Export of logical data model

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> schrieb im Newsbeitrag news:8gb9c09sb8u6hpa78f6jncj5v2en4be8pb_at_4ax.com...
> On Mon, 7 Jun 2004 10:10:05 +0200, "André Hartmann"
> <andrehartmann_at_hotmail.com> wrote:
>
> >Hi everyone,
> >
> > how can I export from an Oracle Schema the logical data model
(preferrable
> >as a SQL script) so that I can feed it into another database management
> >system, for example MS Access or MS SQL Server ? I would like to
emphasize
> >the "logical" part here, because the physical details (tablespaces,
pctfree,
> >....) would not be understood by the other DBMS. So with "logical" I mean
> >tables, indexes, constraints, views. Stored procedures and sequences are
> >considered optional because in my special case there arent so many of
those
> >and there are different ways of doing those in other systems.
> >
> > I am aware that what ever I get created I would have to post process,
> >maybe even manually (for example because data typed might be named
> >differently, sets of reserved words do not match totally and so on...),
but
> >my main problem is how to get such a script or similar initially so that
I
> >got something to start from...
> >
> >AH
> >:)
> >
>
> Just configure yourOracle ODBC driver and use the standard Access
> export from external source functionality. Sqlserver will no doubt
> have something similar.

I dont have MS Access. I actually only use the Access ODBC driver rooted to an .mdb file. So What I do is I operate an MS Access data source without actually having MS Access installed anywhere. But I get your point that basically is that it is not Oracle's job to do that. I am aware that there are tools like CASE tools who can pull out a schema from a data base, turn it into a UML or entity relationship diagram and from that one might produce code for a different relational database container. But my hope was there would be something more profound and immediate.

>
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Tue Jun 08 2004 - 03:00:52 CDT