On 8/11/06, Deanna Schneider <[EMAIL PROTECTED]> wrote:
>
> Just FYI - what Denny's solution is going to give you is the create
> table statement for a specific table. What my solution is going to
> give you is all the tables, columns and column types for all the
> tables in your Oracle schema. With Denny's solution you'd have to
> parse through the text to get the column definitions - but Denny's
> would be very helpful if you needed to recreate the table in another
> DB.
Yeah, it looked like Lars was past the point of needing it, but I think
it could be used to write a "migrator" which did keys and indexes...
The MySQL Migration Toolkit looked nice, haven't tried it on Oracle
though... Just to put a nifty MySQL migrator out there.
If Lars aleady has the basic table structure in MySQL, and doesn't
have access to the oracle server anymore, there are MySQL ways
to get column names (or do a cfquery, and get the columnlist var).
:Den
On 8/11/06, Lars Gronholt <[EMAIL PROTECTED]> wrote:
> > Thanks all :)
> >
> > think either of those will sort my problem - will confirm on Monday!
> >
> > >This looks cool too (for oracle):
> > >
> > >select dbms_metadata.get_ddl('TABLE','THE_TABLE_NAME') from dual
> > >:D
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249627
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
