Merge replication after a restore publisher

Merge replication works fine, but if I restore publisher database on SQL
Server 2000,
and I have some records in SQL Server CE database was already merged (after
last backup),
when I synchronize, these records exists on SQL Server CE, but they are lost
on
SQL Server 2000.
I have to put these records on SQL Server 2000, but how can I compare
records that are
both on SQL Server 2000 and SQL Server CE ?
Thanks.
You can update these records in the SQL CE database again, and they should
replicate to back to the publisher the next time you run the activeX
program.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Now available on Amazon.com
http://www.amazon.com/gp/product/off...?condition=all
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"El Ricoun" <elricoun@.yahoo.fr> wrote in message
news:4207ca97$0$6615$8fcfb975@.news.wanadoo.fr...
> Merge replication works fine, but if I restore publisher database on SQL
> Server 2000,
> and I have some records in SQL Server CE database was already merged
(after
> last backup),
> when I synchronize, these records exists on SQL Server CE, but they are
lost
> on
> SQL Server 2000.
> I have to put these records on SQL Server 2000, but how can I compare
> records that are
> both on SQL Server 2000 and SQL Server CE ?
> Thanks.
>
|||Ok, thanks, it works fine, but I have to update all records of all tables
on SQL Server CE. Is it possible to use s_Generation column to know
which record that I have to update ?
Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> a crit dans le message de
news:egF1ekZDFHA.936@.TK2MSFTNGP12.phx.gbl...
> You can update these records in the SQL CE database again, and they should
> replicate to back to the publisher the next time you run the activeX
> program.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Now available on Amazon.com
>
http://www.amazon.com/gp/product/off...?condition=all
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "El Ricoun" <elricoun@.yahoo.fr> wrote in message
> news:4207ca97$0$6615$8fcfb975@.news.wanadoo.fr...
> (after
> lost
>