I have two databases on separate servers. One is MS SQL on SQL Express 2008, the other is MySQL 5.1.49. I have an application that needs to write to the MS SQL database, but I have another that needs to use that information, but also needs to use the MySQL database. So far I have linked the MySQL database using the ODBC 5.1 driver, but am at a loss at what to do next. Should I look at creating procedures and scheduling it? Should I trigger an update on a second, identical database on the mysql server, then use mysql to update the real database with information from the temporary one? Should I be trying to trigger everything to go straight to the mysql db? This is not what I normally do, so please, I am starting from scratch knowledge wise (especially with MS SQL).