sybperl-l Archive

From: "Owen, Robert" <robert dot owen at nortonrose dot com>
Subject: RE: The late SybTools and MSSQL
Date: May 21 2004 8:59AM

Michael,

Thanks for that.

We now have freetds, DBlib and perl talking to MSSQL.   Minor celebration.

I'm trying to change as little as possible in this app.   It basically runs query pairs against two databases, 'diffs' the output and generates update and insert statements.   The thing takes 6 hours to run in production - and a weekend to run in development.    Obviously there are better ways to do this sort of thing these days.   The output, incidentally, is picked up by a COGNOS cube build.   

I figure the less I change the less I need to test...   So, if you have no objection, I'll change SybTools.pm to talk DBlib.

Many thanks,
	Rob.


Robert Owen
ITAD Developer
CIT3
Tel. 44 (0)207 444 2509
robert.owen@nortonrose.com


-----Original Message-----
From: owner-sybperl-l@peppler.org [mailto:owner-sybperl-l@peppler.org]On
Behalf Of Michael Peppler
Sent: 20 May 2004 18:50
To: Sybperl-L Mailing List
Subject: Re: The late SybTools and MSSQL


On Thu, 2004-05-20 at 17:59, Owen, Robert wrote:
> Apologies if this has been posted before but...
> 
> I have a pile of legacy perl code that runs on AIX against a Sybase
> database.    It uses SybTools.pm version 1.3.   I'm far too lazy to
> touch it!   
> 
> Naturally, it now must run against MSSQL server on AIX.
> 
> Now I believe that DBI::Sybase can talk to MSSQL however SybTools uses
> CTlib.   BooHoo:(    But the code only uses ArrayOfHash, ExecSql and
> HashOfScalar from SybTools.    Should I / could I hack SybTools to use
> BDlib instead??

Actually, DBD::Sybase and Sybase::CTlib use the same underlying
interface. To get them to talk to MS-SQL you have to use the FreeTDS
libraries instead of the Sybase libs (see http://www.freetds.org/ for
details).

I would suggest that you convert your scripts to use the Sybase::Simple
module, which is the evolution of SybTools, and which is still actively
developed. 

And modifying Sybase::Simple to work on top of DBD::Sybase (or
Sybase::DBlib) should be pretty straightforward if you needed to do
that.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                       http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html



______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________


_____________________________________________________________________
CONFIDENTIALITY NOTICE

The contents of this e-mail are confidential to the ordinary user of
the e-mail address to which it was addressed and may also be
privileged.  If you are not the addressee of this e-mail you may not
copy, forward, disclose or otherwise use it or any part of it in any
form whatsoever.  If you have received this e-mail in error please
e-mail the sender by replying to this message.

A list of the partners of Norton Rose, Solicitors, can be inspected at
www.nortonrose.com

Please refer to www.nortonrose.com/regulation for the firm's regulatory position.

Regulated by the Law Society.
______________________________________________________________________