Subject | Re: RES: [firebird-support][Martijn] Oracle To Firebird again |
---|---|
Author | David Johnson |
Post date | 2005-08-02T11:57:43Z |
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.
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
>
>
>
>
>
>