Hi Chris, Dear Sir/Madam seems a little formal for a public mailing list! Anyway, we use perl scripts to transfer information from Microsoft SQL server (which was and is somewhat compatable with SyBASE) use the freeTDS sybase/mssql drivers to mysql. I modeled the databse with ErWIN first then used a perl script to SELECT the data and INSERT it into mySQL.
so the short answer is yes, a routine can be written that does this. Hope this helps, Ken ----- Original Message ----- From: "Christopher E. Aston" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 1:05 PM Subject: MySQL & SYBASE > Dear Sir/Madam, > > An odd question. Can a SYBASE database and a MySQL database interact? That > is, can routines be written that, at a specified time or time intervals, > syncronize specified data between these two databases? An comments or > opinions would be appreciated. > > Thanks > > -chris > > Christopher E. Aston, Ph.D. > Director, Genetic Epidemiology Unit > Oklahoma Medical Research Foundation > > > > -------------------------------------------------------------------- - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
