SQL 7 -> MySQL

My first step into this kind of venture would be to shop around CPAN for any
kind of module that says MS SQL Server in its title or description. Or, if
you have one for (SQL Server) 6.5, see if that one works.

If all else fails, I know of one for python :)

-----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


From Adam Muntner <adam@alienzoo.com> Sun Jul 23 21:22:09 2000
From: Adam Muntner <adam@alienzoo.com> (Adam Muntner)
Date: Sun, 23 Jul 2000 14:22:09 -0700 (MST)
Subject: html mail... boo!
In-Reply-To: <200007231900.MAA04853@snappy.wiredglobal.com>
References: <200007231900.MAA04853@snappy.wiredglobal.com>
Message-ID: <20000723212209.AC8BA72AEA@mail.alienzoo.com>

As a coutesy to those using GUI mail readers, would you mind setting
your 'default message' type to 'TEXT'?! I get the digest, and it's a
pain in the ass to scroll through pages of the following and try to
find the messages. Thanks.

<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01BFF495.EAD9A5E0">
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
----------------------------------------------------
-  Adam Muntner         \      Save the Whales!    -         
-  adam@alienzoo.com     \     Collect Valuable    -
-  Systems Engineer       \        Prizes!         -
-  http://www.alienzoo.com \                       -
----------------------------------------------------

-----------------------------------------------------
    Get free email and alien enlightenment from
             http://www.alienzoo.com