Claudio, I guess I wasn't as clear as I thought I was. Please forgive my
lax terminology, I am not a DBA, just a developer with enough knowledge to
be dangerous. :-)

We need to clone both the table structures (= metadata?) and the data.

The vendor of this legacy product is resistant to giving us (a third-party
developer) the DDL, so we have no scripts to process. If they do give us
the DDL, we will still need to get the data across somehow, and it's
terribly unclear to me how to do that via an intermediate file format. So
copying DB->DB directly seems to be the easiest route. (Note that this
should be a one-time process.)

The HSQL tool used JDBC to read the source database's metadata, create
similar tables in the target, and then copy all the records over. That's
what I'm looking for now. I will probably try the HSQL tool again, but was
looking for something a bit more mature and reliable.

Again, there's no stored procedures or other programmatic SQL, so I think
there's not much more to worry about that the metadata and data.

Thanks,
.T.

On 1/24/03 3:56 AM, cvalde@... wrote:

> ----Original Message----
> From: Todd <tvj@...> [mailto:tvj@...]
> Sent: Jueves 23 de Enero de 2003 17:03
>>
>> This is all well and good, except for the fact that I need to
>> bootstrap the process by cloning the oracle schema (and data) into
>> Firebird.
>>
>> Can anyone suggest a tool that can do this? A year or so ago, I used
>> a simple migration tool that was part of the HypersonicSQL
>> distribution, but it was a bit clumsy and had a hard time copying
>> tables in the proper order. I'm hoping that Firebird/InterBase
>> devlopers can suggest something appropriate.
>
> Do you want to clone only metadata?
> Well, www.datanamic.com has a tool that can reverse engineer almost any
> script to the format used by that CASE tool. Then, the CASE can generate a
> script for other db engine.
> For USD 149 + 41, it's not bad. I've used the two tools for over a year for
> my needs and it's enough. I don't need the complexity of ER/Studio and in
> this way, I don't need a live connection to a db. I can reverse engineer any
> supported engine's script without having that engine installed. Hence,
> someone could give me an Oracle script (I don't have Oracle), I convert it
> with ImportER Scripts and then load the resulting file in Dezign. Finally, I
> tell Dezign to generate the script for FB. Done. (I'm not associated with
> Datanamic; I'm only a happy customer.)
>
> C.