May 17, 2003 at 12:22 pm
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
May 19, 2003 at 11:30 am
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]
May 19, 2003 at 9:21 pm
yeah, that's what i have been doing
May 20, 2003 at 5:42 am
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.
May 21, 2003 at 8:25 am
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