MySQL Forums
Forum List  »  Microsoft SQL Server

Replicating Data from SQL Server to MySQL
Posted by: Tom Cole
Date: October 15, 2004 12:59PM

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.

Options: ReplyQuote

Written By
Replicating Data from SQL Server to MySQL
October 15, 2004 12:59PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.