What is a database migration?

What does this mean?


I have never used multiple databases (I think that’s clear by now!) because the beta editor doesn’t allow to add an existing table created in another app to a database, and switching to the classic editor only allows to add existing tables to the default database.

Has this limitation been removed or is there a workaround?