sql server replication: How to replicate stored procedure changes? -- sql server replication

How to replicate stored procedure changes?

Khor Xiang Yi
8/26/2003 9:10:27 PM

sql server replication:

Hi expects,

Currently I am using Merge publication.

I would like to be enable changes made to the stored
procedures in the publication database be replicated down
to the subscriber database.

I tried to drop the published stored procedures so I
can create the updated stored procedure but SQL Server
did not allowed me to delete, stating it was used for
publication.

I looked around the Net and MSDN but I could not find
any article on how to replicate stored procedure
changes. Could you please kindly advise me how to
replicate stored procedure changes?

How to replicate stored procedure changes?

Ray
8/27/2003 6:57:24 AM

Hi Khor ,

The practice I followed is :

- Firstly, Publish all the Stored procedures in a
separated SnapShot Publication,make a push Subscription
and start syncr. with subscriber. (so they are replicated
to Subscriber)
- Then make all the changes you need in the Stored proc.
- Restart Snaphot Agent.
- Stop Distribution Agent and Restart Sync.
- Restart Distribution Agent.

You'll get All the changes.

Hopping this helps ,
Ray.

[quoted text, click to view]

Re: How to replicate stored procedure changes?

Samrat
8/27/2003 3:09:23 PM

The practice we follow here is:

All the stored procedures are seperatly published in a publication. Whenever
there is a update to the stored proc, we remove the entire publication (Drop
It). Write our Alter Stored proc commands and then re run the publication
scripts. And then run the new snapshot.

BTW, all this is done by using Snapshot replication.

The scripts to remove publication and add publication is generated with
script manager functionality of EM.

HTH,
Samrat

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.