extract consistent subset, identity problem

• dovidf

  Old Hand

  Points: 348

  More actions

  October 1, 2003 at 12:26 pm

  #159901

  Is there some utility that can extract a consistent subset of data from a schema with existing data with all foreign key relationhips maintained?

  In moving data from production to QA environments to tables with identity primary keys, how can the identity be temporarily defeated so that foreign key data contained in the tables will be correct?

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  October 1, 2003 at 12:28 pm

  #476624

  Use SET IDENTITY_INSERT to allow explicit values to be inserted into the identity column of a table.