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

Question

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?

what is youre approach? to synchronize mysql to ms sql ? or to rewrite mysql querries to ms sql? — lordkain
– lordkain, Commented Sep 16, 2014 at 13:08
If you're looking at migration you might get more help on dba.stackexchange.com, your problem doesn't seem to be a programming one, unless you intend on creating an application to do this. Your description isn't exactly clear but you might be looking at triggers or jobs, if you clarify your actual requirements maybe with a descriptive example you might get more help :) — talegna
– talegna, Commented Sep 16, 2014 at 13:10
I tried to use linked server and it's works to rewrtie data from mysql — margott
– margott, Commented Sep 16, 2014 at 13:11
If you're looking at going cross-platform you are probably looking for a more in-depth and specialized solution which is why I pointed out you should look at dba.stackexchange.com as there are more database specialists there (this is more code). You might require the implementation of a trigger which sets off an SSIS package with the required data; without a more detailed description of your requirements, all we can do is point you at resources or spout key-words for you to google (and your English is fine by the way). — talegna
– talegna, Commented Sep 16, 2014 at 13:22

Nadim · Accepted Answer · 2014-09-16 13:14:11Z

1

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.

answered Sep 16, 2014 at 13:14

Nadim

4041 gold badge12 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

margott Over a year ago

I know that I need trigger but how to create trigger in mysql which will fire insert on ms sql server database?

Nadim Over a year ago

please have a look at this link: http://stackoverflow.com/questions/13080765/insert-data-from-mssql-to-mysql-using-trigger

Sébastien Over a year ago

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post.

Collectives™ on Stack Overflow

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

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related