Re: looking for a tool
- From: "Alessandro Vercelli" <alever@xxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Aug 2008 09:39:32 +0200
Just my two cents:
A couple of years ago, we needed to perform a "fork" of a production database
from VMS/Alpha to Linux/x86 and I used DDLWizard to "extract" the application
schema from the old db in order to create a new empty schema: apart from some
STORAGE values in INDEX creation, it worked very fine.
Alessandro
---------- Initial Header -----------
From : oracle-l-bounce@xxxxxxxxxxxxx
To : andrew.kerber@xxxxxxxxx
Cc : "ORACLE-L" oracle-l@xxxxxxxxxxxxx
Date : Wed, 27 Aug 2008 07:42:23 +0300
Subject : Re: looking for a tool
>Since no one answered I will try.
>
>Assumption: Since you talk about "parent primary key entry" I understand
>that you need 2 function:
>1) A tool that create DLL for the objects you want to create on the
>other side.
>2) A tool that will let you create referential integrity subset on your
>data and copy it to another database.
>
>Check out: http://www.net2000ltd.com/
>
>They have 2 tools:
>DDLWizard that create DDL for you.
>DataBee - that create and load a referential integrity subset of you
>data to another database.
>
>Adar Yechiel
>Rechovot, Israel
>
>
>
>Andrew Kerber wrote:
>> I am trying to find some sort of tool that will allow me to give a
>> parent primary key entry, and the tool with either export or generate
>> sql to create the entire object, the parent and all children, to
>> another database. Does anyone know of such a tool? I am sure it
>> could be written, but I dont want to re-create the wheel if it is not
>> necessary.
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>--
>//www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
