I have a list of 180+ business rules that I want to implement on my MDS model. They are quite similar but with minor differences. Normally, I will use the MDS web service to create the rules one by one but this is very tedious and requires lot of my time. I rather want to create these rules directly in SSMS by t-sql statements and simply replicate the rules and make the minor modifications as needed. Could someone help on how I am about to do this? what is the process and how do I replicate so many business rules on the same MDS entity in a efficient way?
