I have one more question:

Will the SQL2005 Replication handle the conflicts better than SQL2000 Replication? I'm considering of moving the databases to SQL2005.

Thanks 😀

Steve Jones - Editor (1/18/2010)

---

What are your PKs? Are they integers or characters? You could have conflicts. Typically if you are merging things, you want GUIDs to minimize conflicts.

Depending on...

Vinay Thakur-585143 (1/18/2010)

---

see my comments in bold...

I have multiple databases (with the same structure but the data may be different) distributed in many locations. Now, I want to collect all...