Is there an easy way to make changes to a publication using procedures like
sp_repladdcolumn and sp_changemergefilter with @.force_reinit_subscription set
to true but also force the reinit to be a reinit with upload? For
sp_changemergefilter I rewrote the procedure to force upload and am currently
working on repladdcolumn, but am now thinking that there has to be an easier
way. Thanks, Scott
Why can't you change the merge agent so it doesn't run continuously, kick
all the users off the subscribers, then stop the merge agent and start it so
it uploads all changes and then do the sp_repladdcolumn.
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:AAA3CD94-BDE6-4B5E-9FC7-E6959CD3042A@.microsoft.com...
> Is there an easy way to make changes to a publication using procedures
like
> sp_repladdcolumn and sp_changemergefilter with @.force_reinit_subscription
set
> to true but also force the reinit to be a reinit with upload? For
> sp_changemergefilter I rewrote the procedure to force upload and am
currently
> working on repladdcolumn, but am now thinking that there has to be an
easier
> way. Thanks, Scott
|||I don't have control over the subscribers. They buy a subscription to use
our program and we store the data they generate and allow them to view it on
the web. The subscriber databases are all sql ce. I looked into recreating
sp_repladdcolumn and it looks too intertwined with other procedures for it to
be an easy job to add the upload changes flag. Thanks, Scott
|||Some larger SQL CE deployments will pull down an entirely new database when
they want to make significant schema changes. I'm not exactly sure what is
the best option for you.
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:172BB951-41A2-4D6E-AD5E-B47BB9C01A3C@.microsoft.com...
> I don't have control over the subscribers. They buy a subscription to use
> our program and we store the data they generate and allow them to view it
on
> the web. The subscriber databases are all sql ce. I looked into
recreating
> sp_repladdcolumn and it looks too intertwined with other procedures for it
to
> be an easy job to add the upload changes flag. Thanks, Scott
Tuesday, March 27, 2012
Changing the publication and uploading changes
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment