How to organize the merging of databases on Test and Production in the case of Bitrix?

Question

MySQL

Standard situation
There is a working site on which new orders, users, results of filling out forms, etc. are added to the database.
We clone the Working site (folder + make a copy of the database) for Test. At the Test, we redo some functionality, rewrite some code, edit something there, add some records to the database.
It's time to roll Test on the Working site. Everything is clear with the files, there are no special problems. And what to do with the base? How to "glue" the worker with the dough? After all, while work was being carried out on the Test, the working base was also changing ...

Answer 1

As usual, use migrations. There are several modules for Bitrix that implement this functionality.

Answer 2

Migrations migrations and more migrations

Answer 3

If I understand correctly what migrations are, then we are talking about rolling the Test database onto the Working database, but it is assumed that there were no changes on the Working database?
Those. requests to the base on the Test are logged and in the future this list of recorded requests is reproduced on the Working base.
But what if there were changes in the Workbase as well? The question mentions Bitrix, which, for example, has a continuous numbering of elements of all infoblocks. Suppose that 10 elements were added on the Test and 10 were also added on the Worker. How is it possible to merge such bases?