Tell me more ×
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.
up vote 4 down vote favorite

I have a SQL Server 2008 R2 server with a bunch of published databases that are currently operating under compatibility level 90 (2005).

The subscription databases are also SQL Server 2008 R2, however the destination databases are set to compatibility level 100 and replication is working fine.

If I change the compatibility level for the Published databases, will it affect replication in any way, or will it just be a case of reinitializing all the subscriptions and restarting replication?

I suspect that changing the published database compatibility level may change how the replication stored procedures function slightly, but I'm not 100% sure.

Is this the case?

share|improve this question
Interesting question, but is there a reason these databases need to have their compatibility level changed? If things are working fine, I'd probably just leave it alone... – Jon Seigel Sep 28 '12 at 17:14
The main reason I'd like to change them is that the DB and the servers they sit on have just been upgraded from a single-node 2005 box to a multi-node 2008R2 cluster. Additionally, there are a few other bits of functionality (such as MERGE etc.) that I'd like to be able to start making use of. – Bob Oct 1 '12 at 9:03
1  
You may want to read this question regarding what the compatibility level does: dba.stackexchange.com/questions/5166/… – Jon Seigel Oct 1 '12 at 14:41

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.