How to replicate automatically any newer articles.

Question

Post reply

How to replicate automatically any newer articles.

ram4tech

Hall of Fame

Points: 3140
More actions
April 26, 2006 at 9:19 am

#91725

Hi,
Is it possible to configure a replication (publisher) to automatically take newer articles as part of a publication? Like, let's say a user created a new table or stored procedure, I would like to make that part of the publication.
Thank you,
R

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Scorpion_66 SSCertifiable Points: 7891 More actions · Answer 1

Of course it's possible.....isn't everything....I'm not sure it would be wise though....

Set up a process that monitors for new objects and schedule it...

feed the results of the monitoring process into procs which do the sp_addarticle....

handle the re-initialization of you publication in whatever manner you need (rebuild schema, transfer snapshot, etc...)

Some obvious gotcha's are the number of modifications made to virtually any table, proc, etc before it becomes final....do you really want these transferred.....the number of rebuilds going into your publications, the frequency of snapshot rebuilds, etc....

I use a table of objects as a master for my replication builds, and loop the table to build publications, articles, and subscriptions.....then when there is a change, I just add the object name to the master table for the next rebuild....kinda keeps it manageable that way...

ram4tech Hall of Fame Points: 3140 More actions · Answer 2

I used EM to setup snapshot replication. If we had more time to write scripts to setup the replication it would have been great.

Scorpion,

Can you show how to setup a process that will monitor for any new objects created in the database?

I understand the way your replication setup. How long would it take in order to implement the solution you have?

Thank you.

R

Scorpion_66 SSCertifiable Points: 7891 More actions · Answer 3

With the structures in place, and an understanding of the procs I wrote for it, not long at all.....a few hours maybe just to test the setup.....it's VERY straightforward.....and I would be happy to send you the structures and procs.....it's all scripted.....

basically, it would amount to create the tables...populate the tables correctly.....schedule the proc's to run.....verify that it did what you expect....