MySQL and SQL Server

[Henry]

I have just been informed that I have to synchronise an SQLServer 2000
database with MySQL.

I have never done this before an am a bit confused by it.

Can anyone point me in the right direction ?
Any sites/tutorials online would be most appreciated so I can do so
research.

Thanks in Advance

[Yi Mao [MSFT]]

Why not use a MSDE instead of MySQL? It will be much easier. Thanks.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Henry" <pa...@themedialounge.com> wrote in message
news:eC6WDOXN...@tk2msftngp13.phx.gbl...

[Henry]

I dont think you can use MSDE on a web server.

"Yi Mao [MSFT]" <yi...@online.microsoft.com> wrote in message
news:#Jt7P2fN...@TK2MSFTNGP11.phx.gbl...

[Mario Splivalo]

In article <#zdv1QkN...@TK2MSFTNGP12.phx.gbl>,
pa...@themedialounge.com says...

> I dont think you can use MSDE on a web server.

Why would you think that? I can see no reason why not using MSDE on a
web server. It's just that you can't run MSDE on unix. If you allready
have web server on unix, i presume apache, with php, you need to
recompile php to be able to pull data form mssql (or msde).

Once, i had set up way of replicating data from mssql to mysql, using
myodbc, and setting up triggers on mssql wich filled in the data. I
needed that because some analisys i run on mssql were too slow. MySQL is
much much much faster then mssql (it has no constraints, no stored
procedures, no nothing).

Mike