All geek questions in one place

Replication between SQL Server and MySQL

I want to configure replication between SQL Server and MySQL, in which SQL Server is the primary database server and MySQL is the secondary server (on Linux).

Is there any way to set up such a scenario? Help me.

+6
source share
4 answers

My answer may come too late, but still for future references ... You can use one of the heterogeneous replication solutions such as SymmetricDS: http://www.symmetricds.org/ . It can replicate data between any SQL database to any SQL database, although the overhead is higher than using its own replication solution.

+9
source

of course you can replicate the MSSQL database in MYSQL

  • Using Linked Server in MSSQL. To do this, you need to download the ODBC drivers. and you can continue your search on how to create a Linked Server in SQL SERVER. This option is very simple and absolutely free. You can use the OPEN REQUEST FOR THIS.

  • Using SSIS Packages. To do this, you need the Business Intelligence SQL SERVER service. You can create SSIS packages in Visual Studio and run them for replication.

+4
source

These two databases belong to two different providers. Although I cannot say for sure, it is unlikely that Microsoft is interested in allowing replication to another vendor database server.

I work with Informix and MySQL. Both of these databases have commands that upload the entire database into ascii file format. You will need to see how this is done on MS SQL Server; ftp dump to the server hosting the MySQL server; and then convert the dump to what MySQL can import.

0
source

Not. At least not without a lot of dirty, bad things. MSSQL and MySQL use different replication protocols, so you won’t be able to configure it initially (that’s how you would like to handle it). In the best case, you can hack some kind of proxy server that forwards insert / update / delete / create / change, etc. Requests from one to another. This is a terrible idea, because they do not speak the same SQL, except for the most common case. Even database dumps that are not really replication are usually incompatible between providers.

Do not do that. If you must use different operating systems on your servers, standardize the database on what works on both.

0
source

Source: https://habr.com/ru/post/887411/

More articles:


All Articles