|
|
sybperl-l Archive
Up Prev Next
From: "Pantera, Joseph F dot " <JPantera at gibsondunn dot com>
Subject: RE: Using isql-type Unix tool to connect to MSSQL2000...
Date: Jun 30 2003 6:04PM
Thanks again. Any idea how many people out there are using freeTDS? We're talking about using it on critical firm data. Are people out there using it in this capacity? Maybe if anyone can give me some examples...
- Joe Pantera
-----Original Message-----
From: Michael Peppler [mailto:mpeppler@peppler.org]
Sent: Monday, June 30, 2003 10:33 AM
To: Pantera, Joseph F.
Cc: Sybperl-L Mailing List
Subject: RE: Using isql-type Unix tool to connect to MSSQL2000...
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
==============================================================================
This message may contain confidential and privileged information. If it has been sent to you in error, please reply to advise the sender of the error and then immediately delete this message.
==============================================================================
|