For example:

A, B two databases, there is A a1, a2, b1 table B, need time from a1 and a2 table to retrieve the Name, sex, age three fields in the b1 table, but the data in the table a1 and a2 are can change, change after b1 also need to make A change, there are hundreds of tables and hundreds of thousands of data (need to take into account the database is MySQL database is SQL server and A B)

O bosses can give a better solution or plan,

CodePudding user response:

Can write A trigger SqlClr, any change to modify MySQL data directly, or you get A service regularly read A data to change the MySQL

CodePudding user response:

In SQL Server side:
1. Create links (link server) to the MySQL server.
2. In the a1, a2 table create a trigger, synchronous update when source table data have updated MySQL tables (via the link server).

CodePudding user response:

reference 1/f, big watermelon cut A piece of A kilo of reply:

write A trigger can add SqlClr, any change to modify MySQL data directly, or you get A time read A data service have to do is to change the MySQL

refer to the second floor started the first response:

in SQL Server side:
1. Create links (link server) to the MySQL server.
2. In the a1, a2 table create a trigger, synchronous update when source table data have updated MySQL table (via the link server).

Have also considered the trigger, but the table is more, written words