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

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!

KalebM June 12, 2018 19:54

Comments

2 comments

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!

Rob C June 14, 2018 15:18

0
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.

KalebM June 14, 2018 15:21

0

Add comment

Please sign in to leave a comment.

How can we help you today?

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

Comments

Add comment