Replication & User Defined Defaults

  • Hi,

    I am trying to set up a merge replication with some of the columns bound to a user defined default.

    after the replication is successfully set up, the defaults are not there on the subscribers.

    Has anyone come across this error? Waiting for your valuable suggestions.

    Thanks

  • As far as I remember, you can't replicate user defined data types or defaults. You need to create them at the subscriber. Best thing is to create a script and run it at the subscriber.

    [font="Verdana"]Markus Bohse[/font]

  • yeah, that's what i have been doing

  • Hi,

    You CAN replicate user defined defaults. You have to do two things :

    - make sure the UDD already exist on the subscriber (I always create them in the Model Database, so they will be created when the replication creates the new Subscriber DB)

    - Check the option "Convert user-defined to base data types" OFF (this option is well hidden at the replication wizard : At the Screen "Specify Articles" press the button "Article Defaults...", choose "Table Articles", "Snapshot" Tab 😉

    Good luck, it works fine for me.

  • Jan,

    you're right about this option, but technically it's not replicating the UDD's. So you still have to script your data types and create them on the subscriber.

    [font="Verdana"]Markus Bohse[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply