NOT FOR REPLICATION

Wubti

I love the concept of ready roll, it is working well. However when I use SQL Compare to compare my source database to a test deployment, it recognizes that the NOT FOR REPLICATION on identity columns was not kept. Is there a way to control this in Ready Roll, or will I be forced to manually add these?

dnlnln

Hi there,

Thanks for getting in touch, I'm glad to hear that ReadyRoll is working out for you so far!

In order to include the "not for replication" attribute in the scripts that ReadyRoll generates, you'll need to make a one-time edit to your project file.

To do so, close your solution and open your .sqlproj file in a text editor, and add the following to the top of the file (after the <Project> tag):

<PropertyGroup>
<SyncOptionIgnoreConstraintNotForReplicationAttribute>False</SyncOptionIgnoreConstraintNotForReplicationAttribute>
</PropertyGroup>

The next time you generate a script, the attribute should be included in the comparison process.

Any issues please let me know.