Subject | RES: RE: [firebird-support][David] Oracle To Firebird again |
---|---|
Author | Carlos Arguilar |
Post date | 2005-08-02T12:35:25Z |
David,
I am grateful for your kindness. People like you evidence the true spirit of
the "Open source", the spirit of mutual aid.
Once more, thank you very much and God bless you.
Sincerely,
Carlos Arguilar
-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]Em nome de David Johnson
Enviada em: terca-feira, 2 de agosto de 2005 08:58
Para: firebird-support@yahoogroups.com
Assunto: Re: RE: [firebird-support][David] Oracle To Firebird again
The tool I use is called JDBC.
Read rows from the Firebird database using the Jaybird driver, and write
the rows to Oracle using the oracle thin JDBC driver. By making the
input and output drivers configurable, you have a generic datapump for
about a day's worth of work.
With about 3 day's work I put together a tool that is replacing (and out
performing) a $100,000 / year ETL tool.
I am grateful for your kindness. People like you evidence the true spirit of
the "Open source", the spirit of mutual aid.
Once more, thank you very much and God bless you.
Sincerely,
Carlos Arguilar
-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]Em nome de David Johnson
Enviada em: terca-feira, 2 de agosto de 2005 08:58
Para: firebird-support@yahoogroups.com
Assunto: Re: RE: [firebird-support][David] Oracle To Firebird again
The tool I use is called JDBC.
Read rows from the Firebird database using the Jaybird driver, and write
the rows to Oracle using the oracle thin JDBC driver. By making the
input and output drivers configurable, you have a generic datapump for
about a day's worth of work.
With about 3 day's work I put together a tool that is replacing (and out
performing) a $100,000 / year ETL tool.
On Mon, 2005-08-01 at 11:35 -0300, Carlos Arguilar wrote:
> Dear Martijn,
>
> At first, Thank you very much for your kindly tip!
>
> By the way, Martijn, I don't think it's trivial to build a tool to
convert
> Ora/FB, contrariwise, it must be hard enough. However, be dificult it
isn't
> cause for it be not free. Moreover, I believe the Firebird prove this
> thought. Indeed, I am sure that the Firebird is too much dificult to
develop
> than the convert tool referenced, even so, Firebird is for free. Based
on
> this, I thought it would can exist a tool for convert for free. And that
was
> all.
>
> Best regards,
>
> Carlos Arguilar
> [Carlos Arguilar] -----Mensagem original-----
> De: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]Em nome de Martijn Tonies
> Enviada em: segunda-feira, 1 de agosto de 2005 10:18
> Para: firebird-support@yahoogroups.com
> Assunto: Re: [firebird-support] Oracle To Firebird again
>
>
> > Does anyone know a free tool for convert Oracle database to
Firebird? I
> am
> > needing to perform such a job.
>
> No offence, but if - according to you - it's trivial enough to build a
> free
> tool
> to do this, feel free to do so :)
>
>
> If this is a one-time thingy, you might want to download the trial of
our
> software, Database Workbench, which includes migration tools for data
> structures (tables, views, indices, constraints).
>
> www.upscene.com
>
>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> ------------------------------------------------------------------------
----
> --
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "firebird-support" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
> ------------------------------------------------------------------------
----
> --
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
----------------------------------------------------------------------------
--
YAHOO! GROUPS LINKS
a.. Visit your group "firebird-support" on the web.
b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
----------------------------------------------------------------------------
--
[Non-text portions of this message have been removed]