CODEWITHSUNDEEP
mysqlsqlsql-server
margott
margott

Reputation: 1

How to update ms sql database after insert data on mysql database?

I have a database on mysql (request from applestore) and now I must rewrite one table to ms sql. It's easy to rewrtie old rows, but when new row appear on mysql I need get this to ms sql table, and I don't know how to connect this and do it. Someone can hel me?

Upvotes: 0

Views: 362

Answers (1)

Nadim
Nadim

Reputation: 404

Why don't you try with triggers??..you need to create a trigger which insert the same data in a table when it is inserted in another table.

Upvotes: 1

Related Questions