Syncing table and related data
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?