Ability to limit what is considered Static Data?
ppat
Posts: 6
We have some tables that we ship with default static data. For these tables, we start our Identity sed at let's say 1000, and our data is usually just some rows with Id 1-20 or so. Sometimes also we may have a client Id or some other field with a 0 for common data and any custom data the client adds has their id set.
The problem is that now the sql diff scripts are wanting to purge customer added data. Is there any way that I can tell the Static Data to limit itself to PrimaryKeyId<1000 OR ClientId=0, etc?
The problem is that now the sql diff scripts are wanting to purge customer added data. Is there any way that I can tell the Static Data to limit itself to PrimaryKeyId<1000 OR ClientId=0, etc?
Comments
Thanks for your post!
There is currently no way to do this but there is an existing feature request for this available on here https://redgate.uservoice.com/forums/39 ... -selection
I highly suggest you comment/vote on this idea if you would like to see it implemented- please let me know if I can be of service in any other way- I have followed up with you via email as well.
Warmly,
Technical Sales Engineer
Redgate Software