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.
| Author |
Topic |
|
chen149
Starting Member
19 Posts |
 Posted - 2006-10-18 : 14:16:30
|
| Hi everyone,After I replicate the data to another server, if I didn't start agent and only start synchronizing, the data will not be replicated and the last action will show "No replicated transations". If I start agent and then start synchronizing, it works fine but overwrite my subscripted data.I set up db as snapshot replication. If is that true? I have to 1.push data from publishtion to subscription2.pull back data from subscription to publishtion3.start agent and start synchronizing to overwrite data.If there is any way only push new data to subcription and pull data back to publishtion whenever you want to.Thank you very much!JC |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-18 : 14:22:00
|
| What does pull back data from subscription to publisher mean? The data is moving only one way, from publisher to subscriber. Why not just use transactional replication so that only the new data is copied over?Tara Kizer |
 |
|
|
chen149
Starting Member
19 Posts |
Posted - 2006-10-18 : 14:31:05
|
| Hi Tara,Our web user use the subscription database and they can pay the bill online. After they paied, the data changed and has to be back to publishtion database. otherwise, the data will be overwrited by every night job which push data from publishtion to subscription.Maybe my understanding was wrong. Could you please explain more for me?Thanks,JC |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-18 : 14:44:15
|
| Why don't you use merge replication or two-way transactional replication then? Snapshot replication is not the solution you want.Tara Kizer |
|
|
|
chen149
Starting Member
19 Posts |
Posted - 2006-10-18 : 15:02:02
|
| Thanks Tara,This application we brought from the other company. I'll call them later.JC |
|
|
|
|
|
|
replication question