|
Hello All: I need guidance on how move some changes that I have made to
my production database. On my development database I made changes to a table called
DEPT. I added a column, added a couple of records and did some general data cleanup What I did not do was change any of the keys on existing
records. The primary key of DEPT is a foreign key in several other tables. Here is my question: Can I do a table restore on to
the production database and expect these changes to be moved over? Will the restore handle, via
some magic, “suspend” the foreign key constraints
and allow the new table structure to be created and then populated with new
data. I have not changed the keys of existing records so that
existing relationships should be restored. Thanks for considering my issue. |
