-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sun, 8 Dec 2002, shawn xu wrote:
> We have an application software which uses MSSQL 7.0 > or 2000 server on Windows. Now we want to use the > MSSQL as a master, and MYSQL on UNIX as a slave. How > can we configure Windows MSSQL and UNIX MYSQL both > sides to implement replication? > > Any idea? Thanks in advance. Hi, With the normal replication supported by MySQL OR the replication schemes (merge, transactional, snapshot) supported by MSSQL it's not possible. But have you tried to schedule certain DTS transformation on MSSQL that format the data properly and then send them to MySQL via ODBC? Iikka ======================================== Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE99DkCCVGYZ+r4ZncRAu13AKCSK2DnfzQQq7TSY0lv7BniqVx5WQCeO/L/ uk3w+BU4KKUVzzWeaoRChy0= =TKr0 -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php