Database design - MySQL database integration of two systems

Question

1. There are currently systems A and B, and B is the upgraded system of A;

2. Most of the database tables in the two versions of the system mysql database have the same structure, and the data of A can be directly integrated into another system B; but some tables have different structures, or are split into B Multiple tables;

3. We are going to transform the data table in system B so that it can cover the data of A. I would like to ask the master if there are any good solutions or tools to recommend. How can we clearly design the integration solution and formulate effective verification at the same time? Integrity of data after fusion? ? ?

Answer 1

You are not very clear about what you said.
There are some tables in library A, but they are also in library B? Then copy it directly and match the name and so on.
Library A has some tables, and some of the fields in these tables are present in A but not in B, or in A but not in B. So I don’t know what tool to use.
Usually, it is safest to sort out SQL scripts one by one. For tools, look at ETL-related tools such as kettle.
I feel like your problem is still not described clearly enough. The person above is right. Specific problems need to be analyzed in detail.

Answer 2

To discuss a plan without basing it on the actual situation is to act like a hooligan...

Answer 3

First of all, it is not reliable to directly merge the data of the two libraries. 1. It is difficult to do. 2. Even if it can be done, how can we ensure the integrity of the data?
It is recommended to find out the different performances in the two systems, and then troubleshoot the data. Export the differential data into a script, and then import it into the corresponding library.
This way, even if a problem occurs, you can easily troubleshoot the problem and have room for rollback. Of course, make a backup in advance