What are the challenges you face when working across database platforms? Take the survey
Options

SQL Data Compare - moving data with parent and child tables

I think this has been asked previously, but wanted to confirm.   I have 3 tables, a parent and two child tables.  Table A has a 'modifier', table B can be linked with a sequence # to A, and table C is linked to B with a date/time stamp.   Can I use a "Join A, B, C WHERE A.Modifier = 'xx' " in Data Compare similar to a SQL query to pull data to compare for all 3 tables, or do I need to do separate WHERE statement for each table to pull the data (A = Modifier, B = seq42 , C = '11/15/2023 4:57pm')

From what I've been able to glean from other postings, it would have to be a separate Where statement.  And then follow-up question: are there any plans to actually develop a process to use a multi-table Join command as part of SQL Data Compare in the future?

Thank you!
Tagged:

Answers

  • Options
    Hi @bbergman72,

    SQL Data compare does operate on a "WHERE by case" basis, comparing data against a single table.

    Expanding the comparison process to map multiple tables would indeed be a significant feature enhancement and could be quite complex to implement. At this time, it's not part of our existing roadmap, but it's a great suggestion.

    I would recommend you share this on our UserVoice forum as a feature request. This platform allows our community to voice their preferences and upvote ideas, providing us with a better understanding of user priorities.
    https://redgate.uservoice.com/forums/147879-sql-data-compare

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

Sign In or Register to comment.