Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Ask about replication

Author  Topic 

wilber purwanto
Starting Member

1 Post

Posted - 2009-08-11 : 14:01:32
Dear all,
I want to ask about my problems i had in replication, I need to replicate data from few spot to entry data, abd once every few minutes replicate to the main database.
After I some reference on the web, are encouraged to use merge replication, I have tried to replicate this database and on the publisher database sql server automatically add a GUID field to replicate this process.
Now that I want to ask is:

1. What if there is a input of data from several spot to entry data i explained earlier, i have to make a new insert statement for provide a GUID field that merge replication add to my table?
2. I also want to ask if this merge replication accumulate new data on old data in the database, or replace the old data with new data from replication process?
thanks for help :D
   

- Advertisement -