I am using merge replication in SQL 2012.
Why can't you mark default constraints as NOT FOR REPLICATION? You can disable all default constraints for a merge article, but it is all or nothing so it doesn't seem to offer enough control.
How about this scenario,
- The user inserts a record 'Shape' at a client
- The 'Shape' has a default constraint to set the NumberOfSides field to 4
- The client user edits the value of NumberOfSides and sets it to 5
- They sync with the server
When they sync with the server won't it repeat the default constraint and set the value of 'NumberOfSides' back to 4?
Am I missing something here?
I don't want to disable the default constraints being replicated to the client either because there are valid default values that need to be set. The client side user needs to have these values set to use the software.
The explanation about the default constraint being applied only once makes sense.
So my only remaining question is if I have default contraints which use sequences I am in trouble because sequences cannot be replicated. Are these my only two options?
- Turn off all default constraints for a particular table (not ideal if some of them are not for sequences)
- Create the sequences manually at the client side, and then create a custom handler to apply the correct sequence values at the server when syncing