|
|
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 6:14PM
On Mon, 2003-06-30 at 20:04, Pantera, Joseph F. wrote:
> 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...
I'd say quite a few people use FreeTDS - but if I were you I'd go over
to www.freetds.org and check it out, and also join the FreeTDS mailing
list.
The alternative for you would be to get an ODBC driver for MS-SQL, and
then to use something like DBI/DBD::ODBC and build isql and bcp-like
functionality in perl. It wouldn't be all that hard to do, btw.
Michael
> -----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
|
