PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: What's the best option for BCP
Date: Dec 17 2003 4:16PM

On Tue, 2003-12-16 at 06:45, Wechsler, Steven wrote:
> Michael (or anyone else who wants to answer)...
> 
> Previously I've always used Sybperl for BCPing into ASE servers; however,
> it's been more than 3 years since I've last had to do it. Is Sybperl still
> the best method for BCPing in inside Perl scripts on Unix and possibly NT?
> Or has something new come along?

sybperl's functionality in that respect hasn't changed much.

However, I personally usually write the data to a temp file, and then
use sybase's bcp command to bulk-copy the data, as that is usually the
faster option.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html