Syncing table and related data

idsids Posts: 2
edited February 8, 2017 11:20AM in SQL Data Compare 11
I am trialing SQL Data Compare to solve the issue of copying / syncing data from a production database to a training environment.

I don't want to copy all the data but instead a selected snapshot - the last weeks data.

The main table I want to copy has a date on it so I can easily filter the rows I want from that using a WHERE clause. However linked to the main table is a number of other tables that I can't use the same restriction on.

Is there anyway to have the data synchronization copy a row from a table and then all dependent rows from related tables?

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Thanks for your post and apologies for the delay in getting back to you.

    If the table has dependency can it not use the same clause? Do these table have Foreign key relationship?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Is there any update on this?
    If table A has a foreign key relationship to table B, is there a way to automatically include those records?
    (Data compare will fail at the end of the deployment, quoting the foreign key relationship as the reason for failure.)
  • I am also interested to know if this is possible. The WHERE clause is great, but I have a hierarchy of related tables with dependent data. Not all of them relate back to the top level key, only the second level. Third and fourth level tables relate one level up.

    It would be cool if the Deployment Options had a toggle to exclude orphaned data or include only related data so all those rows without a parent don't get moved.
  • StevieStevie Posts: 7 Bronze 1
    Has there been any progress/updates on this front? I'm attempting to automate data compares and avoid the FK failures without leading to untrusted FK relationships.
Sign In or Register to comment.