Re: Export of logical data model

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Mon, 07 Jun 2004 20:05:11 +0200
Message-ID: <8gb9c09sb8u6hpa78f6jncj5v2en4be8pb@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.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Jun 07 2004 - 13:05:11 CDT