8

We have used SQL Server Replication for a long time and had some issues with it that sometimes we needed to reinitialize subscriptions to fix some issues & other times we needed to destroy the whole replication structure & rebuild it again!

Our main concern is that once we have a replication issue, almost all the time the easy solution will be to reinitialize the replication which is not accepted for our business requirements.

Now we are preparing to release a new big project & we are trying to look for 3rd party software for doing SQL Server replication.

Our setup includes Servers distributed in branches ( Different countries ) + mobile clients ( laptops with local SQL Server databases ) and we need to replicate data between all of these with the ability to offer article filtering.

Would somebody please suggest some alternate solutions for us?

Adel Khayata
  • 663
  • 2
  • 6
  • 23

2 Answers2

8

It's highly unlikely you'll find a better merge replication solution than what's built-in.

Merge replication in particular is hard to implement.

I would suggest that if you're having issues with the current setup breaking, take it up with Microsoft. They should be very motivated to help you find the root cause of the problem so their customers are happy, and not looking for other solutions like you're asking for here.

Jon Seigel
  • 16,922
  • 6
  • 45
  • 85
4

This is the sort of thing that Microsoft Consulting Services can help you with. They know replication really well, and setting up large merge replication farms needs to be done just right or the whole thing will come crashing down.

If there are specific errors that need troubleshooting you can post those here so that they can be figured out, but if it's that sensitive and subscribers need to be initialized that often the entire platform might need some looking into.

mrdenny
  • 27,106
  • 2
  • 44
  • 81