Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have 2 production servers and 2 development servers. All SQL Server 2008 r2.

In production, I had one of our DBAs create a replication publisher and distributor on ProdServer1 and Subscriber on ProdServer2. This has been running for a few months with out issue.

Now, I'm working on a new project and asked for replication to be set up in our dev environment, identical to production. So publisher and distributor on DevServer1 and Subscriber on DevServer2.

Now that this is complete, I'm looking at my databases and in DEV I have 3 stored procedures for each replicated table. They appear to be simple crud procedures (Insert, Update and Delete).

In production, I do not have these stored procedures. DBA number 2 is saying these are required for replication. However, Production is still working and these stored procs aren't there.

The DBA who set up the original replication in production isn't available so I can't ask what was done differently there.

Can anyone tell me what would cause these stored procs to be created in one instance yet not in another? This is very confusing to me, and has me concerned because my development environment is so much different from production.

share|improve this question

migrated from stackoverflow.com Jun 13 '12 at 16:30

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer 1

up vote 1 down vote accepted

Jeff - Have a look at the parameters for sp_addarticle. Notice the parameters @ins_cmd, @upd_cmd, and @del_cmd can be configured to replicate inserts, updates, and deletes as either stored procedure calls or straight SQL.

DBA number 1 likely setup the production publication to replicate inserts, updates, and deletes as SQL. DBA number 2 likely setup the development publication to replicate inserts, updates, and deletes through called stored procs.

share|improve this answer
    
I think it might be that replication in production is doing Snapshot replication and in Dev they are doing Transactional Replication. –  Jeff Reddy Jun 13 '12 at 16:56
    
That would be a good explanation for the differences. –  Brandon Williams Jun 13 '12 at 17:06
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.