i'm testing redgate's data compare (which is by the way 14 days trial and not 30) and it seems good to add / update / delete rows very easily
but this is the problem,
old database has 120 records on tableA (primary key 1-120) when i left it
new temp database doesn't have all 120 records because only 100 records was backed up so it has only 100 records (primary key 1-100)
since we continue using the temp database it now has 140 records (primary key 1-100 from original database and 101-140 from temp database)
the sql compare would want to insert 40 new records to the tableA but it cannot use 101-120 key because it's already exists on the original database so i guess it will try to update and destroy them.
and anyway, it cannot insert with correct keys because
i have table "tbl_users" (code(index), firstname, email)
and table "tbl_priceoffers" (code(index), usercode(from tbl_users), price)
redgate generate script to insert "tbl_priceoffers" before "tbl_users"
but even if it was the correct order (i can edit), it cannot insert "tbl_priceoffers" row without having @@identity from the recently inserted "tbl_users" row
any thoughts ?