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
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).
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
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.
Ive been having great trouble setting up replication (web sync via HTTPS). If I only publish the tables, they replicate fine with the data.
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
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
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
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?
I\'m transforming an XML Schema using XSLT 2.0. The first schema (s1.xsd) imports a second schema (s2.xsd) as follows:
加载中,请稍侯......