With merge replication, can I be guaranteed that when I reinitialize a
subscription with upload changes set to true that the changes with either be
uploaded or that an error will be thrown?
I have never had a problem with it.
If you have some other errors where someone merge is totally broken you
might have problems with the upload.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Scott Simons" <Scott.Simons.At.MealMagic.Com.Remove.This> wrote in message
news:33F9FDF9-09F0-44F6-B42D-136F49E6AD25@.microsoft.com...
> With merge replication, can I be guaranteed that when I reinitialize a
> subscription with upload changes set to true that the changes with either
be
> uploaded or that an error will be thrown?
|||I was having problems running into different bugs. Have you ever really had
a problem with bug #811611* or is that not really an issue? Bug 811611 is
there reinitialized subscribers may experience data loss.
*http://support.microsoft.com/default...b;en-us;811611
|||I was unaware we were talking about SQL CE.
I have never had this problem because
1) I carefully monitor my agents to avoid the expensiver reinitialization
2) I don't do a lot of SQL CE, although I do run it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Scott Simons" <Scott.Simons.At.MealMagic.Com.Remove.This> wrote in message
news:92EC9DC3-8169-4D05-8F64-190011F10CAD@.microsoft.com...
> I was having problems running into different bugs. Have you ever really
had
> a problem with bug #811611* or is that not really an issue? Bug 811611 is
> there reinitialized subscribers may experience data loss.
>
> *http://support.microsoft.com/default...b;en-us;811611
|||This problem that is forcing me to reinitialize is actually coming up due to
other bugs with the merge replication. I don't think that the sql ce merge
replication was designed for anything other than simple replication (ie not
40-some tables with filters on most every table.)
|||I urge you to open a support incident with Microsoft PSS on this one.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Scott Simons" <Scott.Simons.At.MealMagic.Com.Remove.This> wrote in message
news:BD1F835C-F132-469C-ABDD-15B2C446DF44@.microsoft.com...
> This problem that is forcing me to reinitialize is actually coming up due
to
> other bugs with the merge replication. I don't think that the sql ce
merge
> replication was designed for anything other than simple replication (ie
not
> 40-some tables with filters on most every table.)
Tuesday, March 20, 2012
Reinitialize with upload question
Labels:
asubscription,
database,
guaranteed,
merge,
microsoft,
mysql,
oracle,
reinitialize,
replication,
server,
sql,
upload
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment