Page 1 of 1

Sybase DB to File

Posted: Mon Jan 22, 2007 8:21 pm
by nvalia
Hi,

Has anyone tried to copy around a few million rows with each one having 100-150 columns in to a Sequential file or a dataset from a Sybase table. No data transformation required.

How much would the file size be aproximately?

Regards,
NV

Posted: Mon Jan 22, 2007 8:25 pm
by DSguru2B
number of bytes per row multiplied by number of rows,
that will give you a good approximation

Posted: Mon Jan 22, 2007 9:09 pm
by narasimha
Run through a sample data of say 100 rows. Check the size of your output file.
You could estimate the size by multiplying accordingly.