Hello! Our organization is planning a large-scale data hygiene project. The goal is to update salutations in our database so they're a little more modern (e.g. replacing "Mr. and Mrs. John Smith" with a form of address that relies less on outdated gender norms). I'm wondering if anyone has any advice about how to go about mass-updating this information, or would be willing to share their experience with similar data hygiene projects? I'm an apprentice and still learning about Tessitura, so if the language I'm using is confusing or incorrect please let me know and I'll clarify. Thanks!
I will say that it was impossible for us to update all of our salutations in one go: I broke up our customers into about 8 or 9 sets and then created SQL Server Agent jobs to run over one of those sets each night, rather than trying to do it through the client utility.
Thank you, that is helpful!