Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Using isql-type Unix tool to connect to MSSQL2000...
Date: Jun 29 2003 5:53AM
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