If you are planning to synchronise the data from one to another, that should not be rocket science. However, if you want both database servers to update the data, you're in for something rather heavy.
In the easy case, I would probably get the replication feature to output all the database updates, and then write my little parser that would transform dates and other peculiarities from the format of the master to the format of the slave. In the hard case, you will need to do some heavy lifting in order to control concurrency. That is, you will need to make sure databases A and B are identical even when both database servers write data at the same time. It is to the best of my knowledge feasible, but it is definitely not easy to do, and even harder to do without sacrificing performance. Anyhow, that's my 2c. best regards, Jeppe -----Original Message----- From: Paul [mailto:[EMAIL PROTECTED] Sent: 19. juni 2003 11:31 To: [EMAIL PROTECTED] Subject: Synchronising SQL Server and MySQL I need to synchronise an SQL Server 2000 back end with a MYSQL database on a different box (windows). Can anyone point me in the right direction. I have found a number of resources on synchronising 2 sql server databases but I cant find anything on SQLServer and MySQL. Thanks in Advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
