Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MSDE Replication
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00948503
Message ID:
00948706
Vues:
16
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform