Can I find all columns with date/time and mask them simultaneously?
jj1
Posts: 3 New member
My database has more than 30 tables each of which can have between 15-30 columns. Can I create a rule to find all date time columns and set them to dates, random?
Tagged:
Answers
Not exactly, if you create a substitution rule on one table and mask the date/time column with the dates, random masking set. You can then use Table-To-Table Sync rule to update the date/time column in another table.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com