Subject | RE: [IB-Conversions] How to do basic Oracle-to-FB conversion |
---|---|
Author | Claudio Valderrama C. |
Post date | 2003-01-24T08:56:12Z |
----Original Message----
From: Todd <tvj@...> [mailto:tvj@...]
Sent: Jueves 23 de Enero de 2003 17:03
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.
From: Todd <tvj@...> [mailto:tvj@...]
Sent: Jueves 23 de Enero de 2003 17:03
>Do you want to clone only metadata?
> 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.
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.