Do you replicate views, stored procedures, and user functions?

Greetings,

We have recently begun using transactional replication to keep the data in our SQL Servers synchronized in a geographically dispersed environment. We replicate our tables but we have never replicated views, stored procedures, or user functions in our production systems. We are thinking of doing so but wonder if the overhead of running the replication agents doesn't outweigh the benefits of having replication assist with the occassional change to these design elements.

Is anyone on this forum replicating views, sprocs, and user functions? What has your experience been?

Thanks for any ideas that you share.

BCB

There shouldnt be any issues replicating views , sprocs , udfs.

|||

It works great appart from when you want to run the snapshot. It will take much longer to run the snapshot for a couple of 100 sp's than for a couple of hundered tables.

Other than that it works great and with 2005 will replicate your changes nicely.

We keep them in a separate publication because of the snapshot issue and to make things simpler for the main publication.

Martin