Analysis on the implementation of data synchronization between different software databases

Target: K3 database of sales orders automatically entered production management system

Method: Database Trigger

Process:

1. Export Analysis K3 database table structure, production Management system database table structure

2. Make K3 foreground item--k3 the corresponding column in the database--the corresponding column in the production management system database--production management system foreground project

3. Understand K3 's sales data Entry database process: order form, order Detail table in the order of data insertion

4. Understand what data the K3 database can pass directly to the production management system database, transfer those data indirectly (data needs to be taken from other tables, split, merge, etc.)

5. Trigger test (from simple to complex: roller skates--skateboard--bicycles--electric cars--cars--trains)

EG:K3 "Order Detail table" data is inserted before "order form" (and there is no order number in the Order Detail table, and the order number cannot be removed from the "Order table" by querying the Finterid value-because the order form is not yet inserted), I will first "Order Detail table" The required data is inserted into the production management system database, and the data records inserted into the production management system database that do not meet the requirements are removed from the triggers in the Orders table--"The Place is Dead"

Analysis on the implementation of data synchronization between different software databases