How to correctly transfer data from an old database to a new one (with a changed structure)?

Question

Database

If I had a database and it ceased to satisfy me and created another database, where, for example, I added new tables and in general the data is stored differently, then in order to transfer data from the old database to the new one, how is it customary to do this?
PS The only option that comes to my mind is to write a program in any PL that allows you to work with my type of database (Access, for example), which reads data from the old database and writes it to the new one.

Answer 1

Write a script that transfers data from one database to another, taking into account the changed structure.

Answer 2

Write a script in PL that will perform this task. Consider only the following points:
1) When forming SQL, think about whether you need data from the old database.
2) If necessary, then use the mechanisms of renaming tables and inserting data into a new database with a new structure.
3) When performing these operations, set the operations to check the correctness of the script.