merge-replication
Merge Replication: Are multiple publications better than one big one?
We have merge replication set up in SQL Server 2000.One of our publications has 65 articles in it.This works fine but it is a hassle to modify anything (beyond adding a column via sp_repladdcolumn) be[详细]
2023-02-22 20:29 分类:问答SqlCeReplication: using ReinitializeSubscription before each Synchronize?
I\'m working on a bug in a legacy Windows Mobile 5 app, which uses SQL CE Replication to sync a SQL CE database with a SQL Server 2005 or 2008 database (using Merge replication).[详细]
2023-02-11 12:51 分类:问答drop a foreign key constraint for replicated table
Can I drop a foreign key contraint from a table participating in merge replication? If so, can i just drop it from the p开发者_运维问答ublished and will this chnage be replicated to all subscribes?The[详细]
2023-02-05 04:40 分类:问答Replication - User defined table type not propagating to subscriber
I created a User defined table type named tvp_Shipment with two columns (id and name) . generated a snapshot and the User defined table type was properly propagated to all the subscribers.[详细]
2023-02-01 10:06 分类:问答Web Sync Replication: (0x80004005): The schema script 'xxx' could not be propagated to the subscriber
Ive been having great trouble setting up replication (web sync via HTTPS). If I only publish the tables, they replicate fine with the data.[详细]
2023-01-27 19:36 分类:问答How to: Configure IIS7 for Web Synchronization
I have followed the instructions here. To cut a long story short, I just cannot connect to: https:开发者_如何学Python//machine/site/virtual directory/replisapi.dll?diag[详细]
2023-01-27 03:47 分类:问答SQL Exception on immediate reconnect
I have a winform app that uses LinqToSql as it\'s DAL.There is a Central SQL DB and each laptop has a local SQLExpress DB.A seperate module, using Merge Replication, keeps the two in sync.When connect[详细]
2023-01-17 08:46 分类:问答Adding FK Index to existing table in Merge Replication Topology
I have a table that has grown quite large that we are replicating to about 120 subscribers.A FK on that table does not have an index and when I ran an Execution Plan on a query that was causing issues[详细]
2023-01-01 21:38 分类:问答SQL Server 2005 Merge Replication: Under what circumstances would the base snapshot expire?
Obviously changing schema, adding / removing published articles etc expires the snapshot, but is there anything else that would ca开发者_C百科use the publication to expire?[详细]
2023-01-01 09:31 分类:问答Merge two xml schemas using XSLT
I\'m transforming an XML Schema using XSLT 2.0. The first schema (s1.xsd) imports a second schema (s2.xsd) as follows:[详细]
2022-12-31 23:05 分类:问答