Subject Re: [firebird-support] Import data from flat files
Author Marcos Vinicius Dufloth
Hi Oleg,

Can you generate this text files? I so, you can do a script format. Each
line of text is a INSERT INTO ..., commiting for each 500 lines, for
example... After, run this script via ibsql...

Marvin.


Oleg Lebedev wrote:

>Sory, I fogot to mention that I need to be able to import files into the
>FireBird database running on Linux RedHat 8.0. I have 1 GB of data to
>import, so I need a pretty fast utility for that. The best would be a
>similar to GBAK utility that can import data from flat files into DB
>tables.
>Any ideas?
>Thanks.
>
>Oleg
>
>
>-----Original Message-----
>From: M Tuttle [mailto:miket@...]
>Sent: Monday, September 29, 2003 11:15 AM
>To: firebird-support@yahoogroups.com
>Subject: Re: [firebird-support] Import data from flat files
>Importance: Low
>
>
>SMImport at http://www.scalabium.com/
>
>----- Original Message -----
>From: "alecswan2001" <oleg.lebedev@...>
>To: <firebird-support@yahoogroups.com>
>Sent: Monday, September 29, 2003 11:03 AM
>Subject: [firebird-support] Import data from flat files
>
>
>
>
>>I am trying to run some TPC benchmarks on the FireBird database. I
>>have just performed these tests on PostgreSQL by importing data from
>>the flat files and running TPC-R queries. Is there a FireBird utility
>>that would read data from comma- separated flat files and insert data
>>into the tables? Something similar to the COPY command in PostgreSQL
>>that copies data from a file to a table.
>>
>>Thanks.
>>
>>Oleg
>>
>>
>>
>>To unsubscribe from this group, send an email to:
>>firebird-support-unsubscribe@yahoogroups.com
>>
>>
>>
>>Your use of Yahoo! Groups is subject to
>>http://docs.yahoo.com/info/terms/
>>
>>
>>
>>
>>
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to
>http://docs.yahoo.com/info/terms/
>
>*************************************
>
>This e-mail may contain privileged or confidential material intended for the named recipient only.
>If you are not the named recipient, delete this message and all attachments.
>Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
>We reserve the right to monitor e-mail sent through our network.
>
>*************************************
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>


[Non-text portions of this message have been removed]