Hmm, I have access to a Win machine, but I need to figure out how to
this on Linux.

External tables solution sounded like a good idea. But every time I try
to create my table using the:

Create Table Orders External '/tmp/orders.tbl' (.....);

It throws an error saying that "Access to external file /tmp/orders.tbl
is denied by server administrator". I checked the read/write permissions
on this file to allow reads, but still have the same problem.
Ideas?

Thanks.


-----Original Message-----
From: Rafael Szuminski [mailto:raf@...]
Sent: Monday, September 29, 2003 1:14 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Import data from flat files
Importance: Low


uh, yeah... that would be a problem ;-)

Do you have any Windows machines on the network that you could transfer
the data from? I always do all my 'data' work on the Windows and then
copy the ready file to the Linux server.

Raf


Oleg Lebedev wrote:

> It doesn't seem to work on Linux.
>
> -----Original Message-----
> From: Rafael Szuminski [mailto:raf@...]
> Sent: Monday, September 29, 2003 12:53 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Import data from flat files
> Importance: Low
>
>
> How about IBPump?
> (http://www.clevercomponents.com/products/datapump/ibdatapump.asp)
>
> Just copy the data out of MSSQL or any other ADO data source.
>
> Raf
>
>
> 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/
>>
>>
>>
>
>

--
Rafael Szuminski
Email:raf@...
Phone:(949)939 - 2458
www.BDCSoftware.com



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.

*************************************