Comments
Sort by recent activity
Hi @Dan_J It doesn't appear as though the "Exclude all in target" option in the UI is being saved with the project. Like I said earlier, without any sort of indication that it's even been selected (looks to be a space for a checkmark beside it, but no checkmark), it's difficult to tell if its even turned on. When you actually have records for deletion you'll see the checks for individual tables turned off, but if it happens to be an iteration where there are no deletes, there's no way to tell if it's on or off. I tested in a situation where I did have deletes and saw the individual delete checks disappear when I selected "Exclude all in target". Saved the project, reopened, recompared, and all of those delete checks appeared again. In my project, I'm transferring data from one with a low retention period to another where we can preserve the history for a longer period by retaining the last-known state of the records. I want the inserts and updates, I'm transforming the hard deletes into soft deletes (updates of IsDeleted = 1), and so I want to completely disregard the actual deletes. It would have been crazy simple if I could just "turn off delete deployment" in SQL Data Compare. As it stands, I've implemented "instead of delete" triggers on my target tables so that SDC can send the deletes through and I'll just ensure that the IsDeleted flag is set for those records using the trigger instead of running the actual delete on the target. Thanks for your help with this! / comments
Hi @Dan_J It doesn't appear as though the "Exclude all in target" option in the UI is being saved with the project. Like I said earlier, without any sort of indication that it's even been selected...
Hi @Dan_J Thank you for taking the time to reply. That switch is meant to exclude objects from comparison, isn't it? I want them compared, but I want to only deploy inserts and updates. There is an "Exclude all in target" setting from the UI that was mentioned by support that I will do some testing with. I'm unsure if it gets saved with the project so that it remains set when the project is run from the CLI. It would be far more reassuring if the option showed a checkmark or something beside it once it was selected I also don't see an obvious CLI switch or option for this except for the one you mentioned, but I discounted it because it reads as though it excludes from comparison. For my project, I've ended up with a pretty wide workaround utilizing CDC so that I can filter out the deletes before they even get to the SQL Data Compare tool. Would have been more convenient if I could simply choose not to deploy deletes. / comments
Hi @Dan_J Thank you for taking the time to reply. That switch is meant to exclude objects from comparison, isn't it? I want them compared, but I want to only deploy inserts and updates.There is a...
Has anyone found a solution to this? We've recently opened up monitor to other users and are encountering the same issue. / comments
Has anyone found a solution to this? We've recently opened up monitor to other users and are encountering the same issue.
Is there a way to specify this before the situation arises? For example, in the screencap above I am unable to turn off deploy for the UPDATEs since there are none as a result of this particular comparison. Am I forced to wait until the situation arises before I can deselect it? I don't want to deploy deletes to the target for only some of my tables. If I'm forced to wait until the situation occurs before I can deselect it for each of these tables, then I am delayed in rolling out my automated solution since I have to monitor until all tables have been deselected. / comments
Is there a way to specify this before the situation arises? For example, in the screencap above I am unable to turn off deploy for the UPDATEs since there are none as a result of this particular c...