Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE Replication
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00948503
Message ID:
00948706
Views:
15
>>We want to set up 3 different servers with MSDE and sync them using replication. Using merge replication, is it possible to have changes distributed from all 3 servers. I guess what we are asking is if it is possible for MSDE to be both a subscriber and a publisher.
>
>Don't know if you can do that with MSDE or not, but you can with SQL Server. Even then, it didn't work very well, and if you get out of sync, it's a royal mess to try to get synched back up. We gave up on letting SQL do it, it was just too fragile.

I have merge replication working between two servers over a WAN without too many problems. As Fred pointed out, the initial snapshot is a problem and the built-in tools are insufficient. I think depending on your requirements and with enough 3rd-party tools, you can get it to work well enough for many situations. red-gate.com has some tools to validate and "fix" replication when SQL Server messes it up. The major complaint I have is that SQL Server doesn't seem very good at detecting when things get out of sync.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform