Subject | Re: [firebird-support] Bulk Upload facility in Firebird |
---|---|
Author | Helen Borrie |
Post date | 2005-10-10T05:48:19Z |
At 10:03 AM 10/10/2005 +0530, you wrote:
text format, you can read this data file directly as an external table with
cols defined to be compatible types. It's very quick, as you read from
the external table and insert to the real table in one go using the syntax
insert into realtable (<column_list>)
select <type-matched_column_list> from externaltable
However, there are datapump tools around that can convert data directly
from a number of common data or database formats, including Access and
CSV. Refer to the appropriate page in the Contributed Downloads area at
www.ibphoenix.com.
./hb
>Hi,No.
>
>
>
>Is there any kind of bulk upload (BCP) utility available in firebird
>database?
>We need to insert thousands of records in bulk into a table.That's a different question. If you can convert the data to a fixed length
text format, you can read this data file directly as an external table with
cols defined to be compatible types. It's very quick, as you read from
the external table and insert to the real table in one go using the syntax
insert into realtable (<column_list>)
select <type-matched_column_list> from externaltable
However, there are datapump tools around that can convert data directly
from a number of common data or database formats, including Access and
CSV. Refer to the appropriate page in the Contributed Downloads area at
www.ibphoenix.com.
./hb