all groups > sql server replication > march 2005 >
You're in the

sql server replication

group:

replication problem


replication problem mgarner1980
3/25/2005 4:17:53 PM
sql server replication:
Ok I'm going to post this again in another way.

Here's what I have.

2 databases p3e_master and winship.

winship has a merge publication that I use with sqlserverce for pocketpc
users. That works fine.

p3e_master has a transactional updateable publication that includes 3
tables. Those 3 tables are also included in the merge publication for
winship.


here's my problem.

If I update a value in any of the three tables either from winship or
p3e_master (with the sqlquery analyzer for instance) the change propogates
in either direction as it should.

However, when I change data on the pocketpc and the data is synced. The
update shows in winship (as it should), but it does not propogate back to
p3e_master.

Does aybody know if this aproach should work, and if so what do I need to do
to get it working correctly?

Thanks in advance

Re: replication problem Hilary Cotter
3/26/2005 2:36:31 PM
The various forms of replication don't work well together. You would be best
to use merge all the way for such a scenario as you describe.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com


[quoted text, click to view]

AddThis Social Bookmark Button