[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 259
  • Last Modified:

Replication from MySQL to SQL server

Hello, can some one let me know if it is possible to do a a DB replication from a MySQL server to a SQL server? How can this be done? Thanks for the help.

A
0
aej1973
Asked:
aej1973
3 Solutions
 
Julian HansenCommented:
Is this a once off or do you want to keep servers in synch?
0
 
StampelCommented:
replication from MySQL server to a SQL server is not possible because they do not share the same SQL syntax !
0
 
Julian HansenCommented:
replication from MySQL server to a SQL server is not possible because they do not share the same SQL syntax !
Not true - you can replicate between the two quite easily - that is precisely what layers like ODBC are for to allow databases to communicate using a common protocol.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
aej1973Author Commented:
Julian, I will need to keep both the db's in sync.
0
 
StampelCommented:
Sorry aej1973 it's not directly possible.
you could try this product : https://dbconvert.com/convert-mssql-to-mysql-sync.php
0
 
Tomas Helgi JohannssonCommented:
Hi!

You can use ODBC connections between those databases or heterogeneous replication and you will have to create your own sync mechanism.
Also you can use tools like this one http://www.symmetricds.org/ 
or any other similar heterogeneous data replication tools.


Regards,
    Tomas Helgi
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now