Does Dta Compare have the ability to source parent records for all the records you will be inserting

KalebM

If I do a comparison between two databases on a table EMP, and that table depends on the table DEPT, is there a feature in SQL Compare that will get the corresponding inserts for the DEPT table for each record I will be using from the EMP table?

I tried looking around for a similar problem but found none. Please let me know if there is a similar article. 

Thanks!

Rob C

Hi @KalebM

I think you may be referring to SQL Data Compare. If you have a foreign key relationship between tables, at the moment it doesn't generate inserts for dependent tables to satisfy the foreign key. There's a user voice issue open for this - https://redgate.uservoice.com/forums/147879-sql-data-compare/suggestions/3153083-should-be-easy-to-synchronize-related-records-by-f - is that what you are suggesting? If so, then I recommend that you add any comments you have there.

Thanks!

KalebM

I did mean SQL Data Compare. Thank you for pointing that mistype out.  
And yes, that is that is the issue I was referring to. Thank you for giving the proper information.