Subject | Fastest way to export records as CSV from IB? |
---|---|
Author | David Montgomery |
Post date | 2002-03-07T20:50:49Z |
Hi,
I'm looking for the fastest way to export about 8.5 million records from a
v4.2 server (running on Win2000) in a CSV format. I have been trying to use
the "Export" function from IBO's WISQL utility, but the connection drops
after the first 1.6M records every time.
If possible, I'd like to use a process that doesn't spike the CPU since this
is a live database...but I can wait to do this until the middle of the night
if it will take all available horsepower.
Any suggestions from the crowd?
Best Regards,
David Montgomery
_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com
I'm looking for the fastest way to export about 8.5 million records from a
v4.2 server (running on Win2000) in a CSV format. I have been trying to use
the "Export" function from IBO's WISQL utility, but the connection drops
after the first 1.6M records every time.
If possible, I'd like to use a process that doesn't spike the CPU since this
is a live database...but I can wait to do this until the middle of the night
if it will take all available horsepower.
Any suggestions from the crowd?
Best Regards,
David Montgomery
_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com