What are the challenges you face when working across database platforms? Take the survey
Options

Ability to limit what is considered Static Data?

ppatppat Posts: 6
edited April 6, 2016 12:37PM in SQL Compare 11
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?

Comments

Sign In or Register to comment.