Hi Guys,
Does anybody know how to make a bulk copy of a table from one database to
another using Fb Net provider?
I am trying to achieve this goal using something like this:
FbDataAdapter sourceDA = new FbDataAdapter(SELECT * FROM TEST_TABLE,
fbSourceConn);
DataSet ds = new DataSet();
Hello:
The problem with this approach is that FbDataAdapter.Update() is too slow.
It takes almost 1 hour to copy aprox 500.000 rows.
Is there a faster way to do this? or am I missing something?
Can you try to wrap the inserts inside a single ( or several ones )
transaction ??
On 7/20/07, Eduardo Gamboa [EMAIL PROTECTED] wrote:
Is there a faster way to do this? or am I missing something?
With .net provider? AFAIK QLI (old tool, like isql) can do this as
fast as possible.
BTW I'll try to use DataReader and not filling dataset and pump it
into in one foreach loop.
Carlos,
Wrapping the process in a single transaction reduced the time to only 4mins.
Thanks,
Eduardo
Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello:
The problem with this approach is that FbDataAdapter.Update() is too
slow.
It takes almost 1 hour to
Is there a way to use a single transaction with multiple database
connection?
Carlos Guzmán Álvarez [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello:
The problem with this approach is that FbDataAdapter.Update() is too
slow.
It takes almost 1 hour to copy aprox 500.000
On 7/20/07, Eduardo Gamboa [EMAIL PROTECTED] wrote:
Is there a way to use a single transaction with multiple database
connection?
In Firebird yes. FB has support for 2PC protocol. But with .net
provider you can't use this.
--
Jiri {x2} Cincura (Microsoft Student Partner)