I have an Erp software which uses mssql 2012 database. I also use opencart for my ecommerce solution. As you already know opencart uses mysql database.
I want to bidirectional sync the erp with opencart.
Erp will send categories, products, product options, stock to opencart And opencart will send orders to the erp.
I know the schema on both systems so I know which tables must be updated.
The question is What is the best method to sync two different databases? Especially when these two databases are different (mssql-mysql) and the schemas are completely different and also mssql is local but mysql can be accessed only remotely from the web server.
I searched and found the below options -Connect the mysql database as external to the sql management studio and run queries from one database to the other through sql agent. -Use of SSIS? -PHP? But I have little knowledge. -C sharp application? -Third party software like symmetricsds?
Please tell me your opinion. Thank you