Subject | Re: Support for bulk loading of data |
---|---|
Author | paulruizendaal |
Post date | 2005-09-14T09:52:22Z |
Hi Dipesh,
Two interesting questions. I don't think there are specific items in
the official roadmap, but below some information that might help.
- You could use the 'external table' facility to bulk load data
- You could use one of the many FB management tools (often not open
source, though)
Several oracle-mode users have asked for a sqlloader-like tool. The
thing that is open source and comes closest to sqlloader is pl/loader:
http://sourceforge.net/projects/plloader
If you really need something that closely resembles sqlloader, you
may want to attempt a port of this code.
something like this would be to write a stand-alone mapper in a
language with rich XML support. Maybe you can find a generalised
mapper on sourceforge or freshmeat.
Paul
Two interesting questions. I don't think there are specific items in
the official roadmap, but below some information that might help.
> 1)Will there be any work on developing tool like sqlloader (as inThere are several solutions for this:
> oracle database) for bulk loading to the firebird database.
- You could use the 'external table' facility to bulk load data
- You could use one of the many FB management tools (often not open
source, though)
Several oracle-mode users have asked for a sqlloader-like tool. The
thing that is open source and comes closest to sqlloader is pl/loader:
http://sourceforge.net/projects/plloader
If you really need something that closely resembles sqlloader, you
may want to attempt a port of this code.
> 2) Second thing which i would like to know is the xml support forNo such support is being planned, afaik. Your quickest way to do
> the firebird database and uploading of xml data from isql by
> providing mapping file between xml tags and firebird database
> objects. I would be grateful to you if you please throw some light
> on these subjects.
something like this would be to write a stand-alone mapper in a
language with rich XML support. Maybe you can find a generalised
mapper on sourceforge or freshmeat.
Paul