in reply to Getting Dump from Sybase Tables

The easiest thing is to just call Sybase's bcp utility from your perl code. It's pretty simple to build the bcp command line based on the table names and then run it... It will also be the fastest solution.

Alternatively, as a bcp OUT operation is really just a select you could just do a simple select in any Sybase perl module (DBI/DBD::Sybase, Sybase::CTlib, etc) and write the results to a text file with the appropriate column separators (by default a TAB character).

Michael

Replies are listed 'Best First'.
Re^2: Getting Dump from Sybase Tables
by ranjan_jajodia (Monk) on Jun 26, 2007 at 02:53 UTC
    Hi Michael,
    Calling the Sybase's bcp utility is definitely an option I am inclined to take currently. Thanks for the suggestion; I will go by it :)
    From what I have seen select queries are way slower than bcp and I have quite a few large tables to take dumps from. So this might not be a good idea.
    Regards,
    Ranjan