i have two tables table_1 in database_1 and table_a in database_A. from different programs. they contain 60% the same columns. 40% is different. the columns are sorted differently. I would like to to edit only one of them an update the other automatically. Any idea on how to? Thank you in advance. With kind regards Jo Pi

Question

MySQL sql

Answer 1

use triggers. maybe a database link is needed

Answer 2

y dont u link the database and compare

Answer 3

You can use database mirroring for automatic updation of data, but both the dB should have same schema. In your case you need to write custom code to write the data to second database. Otherwise you can send the data to a Message Queue and it will poll the data to both the dBs.