Activity overview
Latest activity by BHughes
Any use of Apache's log4j by RedGate?
Currently scanning systems for this Apache log4j issue, and wondering if there is any concern of its use by RedGate products. We're using SQL Monitor and Toolbelt.
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.
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...
Can I turn off deployment of deletes?
I don't want to deploy deletes or "Target Only" for any of my tables, but I can only turn it off after a delete has been identified. Is there a way to turn it off for tables without having to wait...
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...
De-select column for comparison, but still include it in INSERT
I have a situation where I might like to exclude a column from the comparison, but still want it included in a resulting INSERT statement that is ultimately deployed. The column itself is meaningle...