We have a table that holds some enumeration values and application parameters values in our app database. These records use identity columns as their primary keys. We also have DEV, TEST and PROD databases. We need to sync the primary keys between TEST and PROD databases every time we release an update.What I want to ask is, what is the preferred method of syncing the identity columns? One option we thought of is to remove the identity property from the primary key column and manually create IDs which will all be same on DEV and PROD.What are your thoughts?
Sync identity columns between test and prod
sql server