Replication between SQL Server and MySQL server?

These two databases are from two different vendors. While I cannot say for sure, it is unlikely Microsoft has any interest in allowing replication to a different vendor's database server I work with Informix and MySQL. Both those databases have commands that dump the entire database to an ascii file format.

You would need to see how that is done on MS SQL Server; ftp the dump to the server hosting the MySQL server; and then convert the dump into something MySQL can import.

These two databases are from two different vendors. While I cannot say for sure, it is unlikely Microsoft has any interest in allowing replication to a different vendor's database server. I work with Informix and MySQL.

Both those databases have commands that dump the entire database to an ascii file format. You would need to see how that is done on MS SQL Server; ftp the dump to the server hosting the MySQL server; and then convert the dump into something MySQL can import.

No. At least not without doing a lot of dirty, bad things. MSSQL and MySQL speak different replication protocols, so you won't be able to set it up natively (which is the way you'd want to handle it).

At best, you could hack together some sort of proxy that forwards insert/update/delete/create/alter, etc. Queries from one to the other. This is a terrible idea as they don't speak the same SQL except in the most common case. Even database dumps which wouldn't really be replication are generally incompatible between vendors.

Don't do it. If you must use different OSes on your servers, standardize the database to something that runs on both.

My answer might be coming too late, but still for future reference ... You can use one of the heterogeneous replication solutions like SymmetricDS: symmetricds.codehaus.org. It can replicate data between any SQL database to any SQL database, altough the overhead is higher than using a native replication solution.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.