SQL To Sql help ....

[Bill Campbell]

On Fri, Nov 09, 2007, Ben Duncan wrote:
>As a newbie to SQL, I have picked up a project from one of my clients and 
>need
>to figure out if it an be done.
>
>They are a manufacturer and have a process control machine running winders
>with SQL server (Dont ask why). I have their internal server (Not the
>COBOL accounting machine) which has MySql and some WEB based reports on it.
>
>My question is:
>
>Is it POSSIBLE to have the MySql PULL that tables over from the SQL Server
>machine every night and update it's tables? How is it done? What do I need
>to do .... Inquiring minds want to know .....;->

There are various options to connect to M$-SQL servers from
python and perl, at least one of which is commercial.  I did some
fiddling with a python version a couple of years ago to establish
that I could talk to a customer's Microsoft system in python, but
I don't remember offhand which one it was.

Bill
--
INTERNET:   bill at celestial.com  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

Anyone who cannot cope with mathematics is not fully human.  At best he
is a tolerable subhuman who has learned to wear shoes, bathe and not
make messes in the house.
		-- Lazarus Long, "Time Enough for Love"