Replicating Data from SQL Server to MySQL

[Tom Cole]

I have two environments that need to share data:

1. Intranet using SQL Server 2000
2. Website Using MySQL

There are 5 tables on my SQL Server that store order information. I need a way to replicate that data to 5 tables on my MYSQL instance. This can be batched at regular intervals, but would be less overhead to perform as part of an update/insert/delete trigger.

I am no super-DBA, although I have basic T-SQL abilities, know SQL and program in J2EE (at least JSP/Servlets/Taglibs) and Java using database access all the time.

Does anyone have any ideas how best to perform this? I don't know how to get SQL Server to trigger a Java class to execute, yet alone pass information (like the GUID for the row(s) being affected). Is XML something to look at? I don't know much about web services, but is this a job for web services?

Thanks a ton.