Good morning, is there any way to transfer fields from more than one table to another?
I have an outdated database and need to create the new fields in multiple tables. Is there any query that does this, I use firebird 2.1 with IBExpert
Example
I have 2 tables, and one of them has new fields and add the fields to the table in the other database. And I have to do this with all the tables to keep the databases with the tables up to date.
IBExpert has the database comparison tool (Menu Tools, Database Comparer), which compares the two databases and generates a script with the necessary changes. When you run this script on the target database, you are copying the structure. There are other tools that perform the comparison and generate the necessary DDL, go to: link .
I have for practice copying to a script file all DDLs running under development, so I have the script needed to update all the databases in production.
