In PHP, this is rather simple because there are functions for MSSQL.
However, these require some additional drivers to be installed.

Now, I'm not a perl person, but, I assume you can create sub-routines or
whatever, or they probably already exist, that use an ODBC connection...that
method might work.

Here is a link explaining how PHP does it...it has a link to the drivers
(Sybase CT, a free version)
http://www.php.net/FAQ.php#4.1



-----Original Message-----
From: Mike Starke [mailto:mgcon@neta.com]
Sent: Sunday, July 23, 2000 1:28 PM
To: plug-discuss@lists.PLUG.phoenix.az.us
Subject: SQL 7 -> MySQL


First of all, I would like to thank everyone who has answered or responded
to my questions in the past. I have a bad habit of posting, getting loads
of great repsonses, but sometimes fail to whip back a quick Thanks.

I am trying to figure out how to create a Perl script to access a MS SQL
server, grab/copy some tables, and dump them into my MySQL server. This
would not
be a one time shot, it will probably be something I would like to run
thru cron.  I quess my question is how do I connect (providing they will
give me access to the SQL 7 server)? Do I have to install some Perl
Modules that will handle this?

All bones thrown are always appreciated.

Mike
mgcon@getnet.com
http://www.getnet.com/~mgcon
Phoenix, AZ
USA


_______________________________________________
Plug-discuss mailing list  -  Plug-discuss@lists.PLUG.phoenix.az.us
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss