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 a SQL Server 2008 and I should install Service Pack 3 for it.

On my server there are several databases replicated, and mobile devices sync data via merge replication.

Can problems occur, if I install SP3, especially with my mobile devices (where SQL CE 3.5 is running).

I can't update all of the mobile devices.

share|improve this question
add comment

2 Answers 2

up vote 3 down vote accepted

You should be able to apply the SP3 without dropping any merge replication publications. The order of upgrade should be to upgrade (1) distributor, then (2) publisher, then (3) subscribers.

The SP3 is for SQL Server 2008, not the SQL CE 3.5 mobile tools. Since you are running merge replication then I assume that you have SQL CE 3.5 SP2. So all should be well.

However: Do you have a test system and test mobile devices? If so, test your upgrade in the test system first. I always like to deal with suprises in a test system before applying changes to Production.

share|improve this answer
    
it worked fine ;) –  Karl Sep 19 '13 at 6:00
add comment

From BOL

For merge replication, a Subscriber to a merge publication can be any version no later than the Publisher version.

This means, you have to patch Publisher first and then Subscriber to be 100% sure that you wont be encountering any issues.

share|improve this answer
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.