A
andrei
Hi Group,
I have two databases, one containing the code and another containing all the
data tables. The first database links to tables in the data database.
I need to update the structure of a few tables in the data database and it
cannot be done because the tables are linked (see the message subject). For
example, add some new fields in a table, add a constraint, a foreign key.
I found a way of updating the structure by creating a new empty data
database with the new structure and then importing the data from the old
data file to the new one.
But this is often a lengthy operation because of the size of the data files
and I would prefere a simpler method for the customers.
Is there any other way of doing that ?
Thank you for any suggestions !
Andrei.
I have two databases, one containing the code and another containing all the
data tables. The first database links to tables in the data database.
I need to update the structure of a few tables in the data database and it
cannot be done because the tables are linked (see the message subject). For
example, add some new fields in a table, add a constraint, a foreign key.
I found a way of updating the structure by creating a new empty data
database with the new structure and then importing the data from the old
data file to the new one.
But this is often a lengthy operation because of the size of the data files
and I would prefere a simpler method for the customers.
Is there any other way of doing that ?
Thank you for any suggestions !
Andrei.