I have a question regarding database migration. For illustration purposes, I have a DB table and a dependent table such as:
Table 1: Employee:
column EMPLID INTEGER generated always (Primary Key)
Table 2: Address
column: ADDRID INTEGER (FK = Foreign key to Employee table)
Changes in business rules require that I add some additional columns and also to remove (retire) some existing columns in the Employee table, drop and recreate the Employee table while preserving existing data and Parent-Child relationships. My question is:
What are my options in migrating this table with all the changes required while preserving the existing identity column and the RIs? Any issues or concerns that you may have or foresee?
Any and all responses will be appreciated...