Re: [gentle-devel] Merge Replication (SQL Server 2000)

[<mar...@gm...>]

On Jan 28, 2006, at 12:43 AM, Morten Mertner wrote:

Hi Morten,

> Gentle will ignore additional columns in the database tables as =20
> long as
> the (inappropriately named) configuration option Analyzer/Silent is =20=

> set
> to true. If you toggle it to false, additional columns (to which no
> member maps) will cause an exception to be raised.
Yeah, I learned that the hard way a long time ago.. :)
I am worried about the PKs and IDs because replication uses an =20
identity pool which is later modified... so for example:

ServerA has IDs from 1..500
ServerB has IDs from 501..1000
ServerC has IDs from 1001..1500

A simultaneous insert in server A, B and C would result in rows with =20
ID =3D 1, 500 and 1000; these rows will be later merged appropiately.



--
Mart=EDn Marconcini

A: Because id10ts do not know how to configure their email programs.
Q: How does top-posting happen?
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?