Primary Key Change
davedunckley
Posts: 1 New member
Hi Guys,
New to the world of SQL data masker, its an amazing tool. Though I do hope it will get the redgate look and feel in time, as its more developed in house.
One question I have.
We use account number a lot though our data, this is our primary key, waht we would like to do is to be able to make the account number but to keep the mark the same thought the database. So for example I have an account number of 11011101 it will become 5566565 but to be the same new number in all tables. Is this possible?
Any help here would be great.
Thanks
Dave
New to the world of SQL data masker, its an amazing tool. Though I do hope it will get the redgate look and feel in time, as its more developed in house.
One question I have.
We use account number a lot though our data, this is our primary key, waht we would like to do is to be able to make the account number but to keep the mark the same thought the database. So for example I have an account number of 11011101 it will become 5566565 but to be the same new number in all tables. Is this possible?
Any help here would be great.
Thanks
Dave
Tagged:
Comments
Apologies for coming back to you so late, I have just come across this post!
Its perfectly possible to change a PK and all associated FKs using Data Masker - you will need to use a Substitution Rule converted to a Synchronisation Manager rule to do this.
You can read more about this process here: https://documentation.red-gate.com/dms6/data-masker-help/version-6-tech-tips/how-do-i-change-a-primary-key-value-and-all-associated-foreign-keys
I understand that I'm possibly a bit too late with this answer, but hopefully, this helps if not, and if you have any other queries about Data Masker please do feel free to let us know!
Thank you very much.