Showing posts with label upload. Show all posts
Showing posts with label upload. Show all posts

Tuesday, March 20, 2012

Reinitialize with upload question

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.)

Re-Initialize subscription did not upload changes?

I'm doing a test.
I dropped a subscription on Subscriber-A
I performed some transactions on Subscriber-A.
I pushed a new subscription to it and indicated that it already had schema
and data.
I'm trying to get those new transactions to the publisher. I chose then to
re-initialize the subscription and checked the box to upload changes. But
the publisher never received those new transactions?
What may I try?
bob
It sounds like that you chose not to apply data and structure during
snapshot set up. Do you have the corresponding stored procedures in your
subscribers?
If not, that may be the first step to look at.
"Robert A. DiFrancesco" <bob.difrancesco@.comcash.com> wrote in message
news:OxqVBuswEHA.2876@.TK2MSFTNGP12.phx.gbl...
> I'm doing a test.
> I dropped a subscription on Subscriber-A
> I performed some transactions on Subscriber-A.
> I pushed a new subscription to it and indicated that it already had schema
> and data.
> I'm trying to get those new transactions to the publisher. I chose then
to
> re-initialize the subscription and checked the box to upload changes. But
> the publisher never received those new transactions?
> What may I try?
> bob
>