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.
> -----Original Message-----
> From: Michael Peppler [mailto:email@example.com]
> 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
Michael Peppler Data Migrations, Inc.
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.mbay.net/~mpeppler/resume.html