Hi,

I have 2 identical databases. I make changes to one and that should get
updated to the other DB. I have identity columns as primary key on the
master tables and also the child tables. What approach I can used to
syncronize? I was thinking of removing identity and using GUID instead. It
will be then simply copying data from one db to another. In case of Identity
I have to replace the new id generated in all the child tables.

Please suggest the best approach,

Regards,
Vineet

Identity columns are supported in this case - you can have automatic number
management in which case the subscriber will have a completely different
seed to the publisher, or you can manually manage the identity numbers, in
which case the seed and or increment are set by yourself in the subscriber.
In each case the ranges are chisen so as to not overlap at all. If you want
to do a nosync initialization, the manual option is your method.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)