Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Getting Dump from Sybase Tables

by mpeppler (Vicar)
on Jun 25, 2007 at 15:39 UTC ( #623199=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://623199]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (4)
As of 2020-11-24 05:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?