Sybase DB to File

nvalia · Post by **nvalia** » Mon Jan 22, 2007 8:21 pm

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

DSguru2B · Post by **DSguru2B** » Mon Jan 22, 2007 8:25 pm

number of bytes per row multiplied by number of rows,
that will give you a good approximation

narasimha · Post by **narasimha** » Mon Jan 22, 2007 9:09 pm

Run through a sample data of say 100 rows. Check the size of your output file.
You could estimate the size by multiplying accordingly.