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: Using isql-type Unix tool to connect to MSSQL2000...
Date: Jun 30 2003 5:33PM

On Mon, 2003-06-30 at 19:28, Pantera, Joseph F. wrote:
> Thank you Michael.  Is there something similar to replace a straight "bcp" (out of ksh...)?  My programmers here pointed out they need that type of functionality too (only isql and bcp).

FreeTDS has a bcp implementation, though I don't know how good it is.

Michael


> -----Original Message-----
> From: Michael Peppler [mailto:mpeppler@peppler.org]
> Sent: Saturday, June 28, 2003 10:53 PM
> To: Pantera, Joseph F.
> Cc: Sybperl-L Mailing List
> Subject: Re: Using isql-type Unix tool to connect to MSSQL2000...
> 
> 
> On Sat, 2003-06-28 at 02:59, Pantera, Joseph F. wrote:
> > Michael / Sybperl List-Serve:
> >     I know this is not a Sybperl question, but I think the people who
> > normally get involved here might be able to provide some insight on
> > this...  Have some rather old Unix korn shell scripts that do data
> > extraction (isql), insertion (bcp) from other Sybase databases.  Those
> > databases are about to be converted to MSSQL2000.  Does anyone know of
> > a way to make Sybase isql (or perhaps a third party tool that works
> > "just like" Sybase isql) work with MSSQL2000?  I have many perl
> > scripts that I'm converting to do this type of thing, but the scripts
> > I'm talking about using here are in another support group's domain,
> > and they really don't want to touch them at this time...
> 
> Install FreeTDS (http://www.freetds.org) and then build sqsh
> (http://www.sqsh.org). That'll give you something that is very close to
> isql.
> 
> 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