I've been using SQL Compare to compare the schema, but we also have some data that is in source control. But when a new row gets added to a table that is source controlled, it scripts out the insert but with an identity insert enabled.
How can I have it script out the insert so that it doesn't include the ID? SQL Compare also drops the constraints, inserts the data, then readds them but some of them have a nocheck.
Am I using the wrong product for this?