1
Vote

Allow option to use nulls for identity fields or selection to turn IDENTITY_INSERT on and off for appropriate tables

description

it would be nice, when scripting a database, to allow the user to choose to insert nulls in identity fields to allow SQL Server to populate them itself. Another option would be to be able to select to script "SET IDENTITY_INSERT {tbl_name} ON" before the inserts for a given set of tables and "SET IDENTITY_INSERT {tbl_name} OFF" after those inserts.
 
Otherwise the script throws numerous errors when inserting into identity-keyed tables.

comments