0
Good morning, is there any way to transfer the fields to more than one table?
I have an outdated database and need to create the new fields in several tables. Is there any query that does this, use Firebird 2.1 with Ibexpert
Example
I have 2 tables, and one of them has new fields and add the fields in the table of the other database. And I have to do that with all the tables to get the databases up to date with the tables.
0
Ibexpert has the database comparison feature (Menu Tools, Database Comparer), which compares the two databases and generates a script with the necessary changes. By running this script in the target database, you will be copying the structure. There are other tools that perform the comparison and generate the necessary Ddls, access: https://www.firebase.com.br/downloads.php?categ=4.
I have practiced copying to a script file all DDL executed in development, so I have the necessary script updating of all databases in production.
Browser other questions tagged database firebird
You are not signed in. Login or sign up in order to post.
show your structure and what you want to do, give an example
– Rovann Linhalis
I made an edit on the question with an example.
– Antonio Gomes
you should have the base update script. There is no specific command to update one base by comparing it to another. There is third-party software that can do this, but usually paid in addition to that, may have problems
– Rovann Linhalis