Subject | Re: [firebird-support] Looking for library to create external tables without FB |
---|---|
Author | Martijn Tonies |
Post date | 2008-04-16T11:16:09Z |
Hello Maxim,
right?
If so, you can just read the DBF table and create plain text from it in
a small application, then use Firebird to transfer the data between the
external table and an internal table.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
> I'm looking for a tool to bulk load from DBFs. Probably via externalYou do know that an "external table" in Firebird is a plain text file,
> table. Simple way of reading DBF and executing INSERT's takes 30 min
> for 1mln records. Copy of 1 mln inside FB between two tables takes 5
> min for 1 mln records.
>
> I'm thinking about some tool to create FB external table from DBF.
right?
If so, you can just read the DBF table and create plain text from it in
a small application, then use Firebird to transfer the data between the
external table and an internal table.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com