Merge replikacija

In Archive Tags #imported #archived Published 10. 07. 2006 2 comments

V SQL serverju 2005 imamo na voljo read-only članke pri replikaciji. Kako to najbolj elegantno implementirat v SQL 2000? (v bistvu bi rad one-way)

- rollback trigerji na subscriberju
- merging changes in pravice glede na uporabnika
- pobrisat merge trigerje
- ExchangeType = Downloadonly
- ...







Avtor: PRiMoZ, objavljeno na portalu SloDug.si (Arhiv)

Leave a comment

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.

spirit1
spirit1 - torek, 18. julij 2006

no glede na to nimam nekih vecjih izkusenj z replikacijo je edini nasvet ki ti ga lahko dam da postas zadevo na kakem forumu. osebno preferiram www.sqlteam.com/forums

PRiMoZ
PRiMoZ - torek, 18. julij 2006

Poizkusil sem nastavit lastnosti Merging changes, ki naj bi preverjale, če ima user pod katerim se poganja merge agent pravice do INSERT, UPDATE in DELETE. Vse nastavim, ampak podatki se še kar prenašajo, čeprav user nima pravic."SQL Server™ 2000 provides the option to validate permissions for a Subscriber to upload data changes to a Publisher. This verifies that the Merge Agent login has the permissions to perform INSERT, UPDATE, and DELETE commands on the publication database. Validating permissions requires that the Merge Agent login be a valid user with the appropriate permissions in the publication database."Tako piše v helpu a jaz kaj ne razumem?