0

I have configured two servers: one MySQL and one MS SQL server.

Application will run on Linux server with MySQL database as data storage.

When a new row is added to specific table in MySQL I need to push that row into specific table in MS SQL server.

I know that on MSSQL can be configured Linked Server targeting MySQL server via MySQL ODBC Driver.

But how to force synchronization from MySQL? Can I somehow use trigger in combination with something to do my job?

2

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.