Saturday, August 12, 2006

Unidirectional Merge az SQL2005-ben

Amint arra sikerult rajonni a merge tipusu replikacional is be lehet allitani a Synchronization Direction-t, ami lehet:

-Bidirectional
-Download-only to Subscriber, allow Subscriber changes
-Download-only to Subscriber, prohibit Subscriber changes

Azzal volt bajom, hogy barmelyiket is valasztottam az visszaallt Bidirectional-ra mindenfele figyelmeztetes nelkul. Aztan vegul itt talaltam meg, hogy mitol van ez:

“to take advantage of this property (@subscriber_upload_options) the subscription must be marked as a ‘Client’ subscription and not the default of ‘Server’ subscription (see below). If you leave the default ‘Server’ option, the subscriber will always be created as bidirectional.”