On a Publication (secondarily, a Subscription), is there a script or command I can run that verifies that the articles currently in place match what is expected and/or correct? If changes were manually made to a replication database (i.e. a table's "MSMerge_ins_..." trigger is modified or deleted, causing replication of that table to fu...
Howdy all, We are faced with the following problem that involves keeping the following in sync: 1 Centralised Server (IIS / MSSQL 2005) Many Desktop WPF clients distributed by ClickOnce Many Mobile clients - (Windows CE) With these thorny constraints: all sync relationships are bi-directional the desktop & mobile nodes require o...
We have an C# application which posts to a database which is replicated to another database (using merge-replication) and has one custom resolver which is a stored procedure. This was working fine under SQL Server 2000 , but when testing under SQL Server 2005 the custom resolver is attempting to change any empty varchar columns to be n...
We have decided to put our servers in data centers on east and west coast of US, to keep high level redundancy. We like to replicate our SQL Server 2008 databases using merge replication, but going through configuration headaches. Our SQL Server are running on web front end boxes. Can Merge replication be set up over the internet. MSDN ...
Using sp_repladdcolumn I can either: 1) add a column that allows nulls; or 2) add a column with a default value that does not allow nulls. Without dropping and recreating the whole subscription I would like to: 3) add a column with no default value that does not allow nulls. Is this possible? I realize I would need to populate the co...
I have Merge replication setup on a CRM system. Sales reps data merges when they connect to the network (I think when SQL detects the notebooks are connected), and then they take the laptops away and merge again when they come back (there are about 6 laptops in total merging via 1 server). This system seems fine when initially setup, bu...
I have a database running under Sql server 2005 with merge replication. I want to change some of the FK columns to be 'not null' as they should always have a value. SQL server won't let me do that though, this is what it says: Unable to modify table. It is invalid to drop the default constraint on the rowguid column that is us...
We currently have merge replication set up to merge certain tables between two databases. I need to programmatically start one of the publications to make sure data has been synchronized prior to starting a certain job. SQL Server Books Online has not been too helpful. So far, the only thing I have come up with is to use sp_start_job ...
I have an in house app that has both a Web Interface and a Desktop Interface(is an OCA using Merge Replication). We are still using SQL 2005 and have many 'Archive' tables set up. These are filled by Triggers on there relating Table. tblPersonArchive for tblPerson, etc. To keep the Replication Sets as small as possible I would like t...
Possible Duplicate: How to do Merge Replication? I've followed the instructions to setup merge replication. Finally, when I viewed the "Launch Replication Monitor", it is showing the warning as "Uninitialized subscription" Doesn anyone know the cause of this warning? Also, the table is not getting update,,,,, ...
When I'm doing synchronization between database in different system, I'm getting the "long running merge" warning in the replication monitor. As my database consists of lakhs of records, so it is taking some time to execute which causes the warning as "long running merge". Will it affect the records to transfer or Shall I just ignore the...
I'm getting the following error while disabling publishing and distribution. Plz, tell me how to do disable publishing and distribution? SQL Server could not disable publishing and distribution on 'server'. An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ...
I'm doing merge replication in sql server 2008 to synchronize the database between two systems. I added only tables to replicate initially. Successfully it is synchronizing. Now the problem is whenever I'm adding new article say adding stored procedure, the snapshot is starting from scratch. Meaning, it is creating article from the ta...
I'm trying to use RMO to programmatically perform merge synchronization. I've basically copied the SQL Server example code, as follows: // Create a connection to the Subscriber. ServerConnection conn = new ServerConnection(subscriberName); MergePullSubscription subscription; try { // Connect to the Subscriber. conn.Connect(); ...
I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I can run this --> ALTER TABLE tblPlanDomain ADD ReportWageES VARCHAR (100) NULL and NOT force all my clients to reinitialize but I was hopin...
Hi, i am driving since some years a sql-server2000 merge-replication over three locations. Triggers do a lot of work in this database. i got no troubles. Now migrating these database to a brand new sql2008, i got some issues about the triggers. They are firing even if the merge-agent does his work. Is there anybody who has some experi...
I have set up a pull subscription to a merge publication in SQL Server. I use parameterized row filters on some tables. This works fine with the initial synchronization - just the rows using the filter arrive in the replicated (client) database. However, at some later point I'd like to be able to synchronize the replicated database agai...
I have a Win Form, Data Entry application that uses 4 separate databases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. The next hurdle I am trying to tackle is adding Filters to my Publications. Right now we are replicating 70mbs, compressed, to each of our 150 ...
We are using SQL Server 2005 Merge Replication with SQL CE 3.5 clients. We are using partitions with filtering for the separate subscriptions, and nHibernate for the ORM mapping. There is automatic ID range management from SQL Server for the subscriptions. We have a table, Item, and a table with a foreign key to Item - ItemHistory. Bot...
I'm transforming an XML Schema using XSLT 2.0. The first schema (s1.xsd) imports a second schema (s2.xsd) as follows: Content of s1.xsd <schema xmlns="http://www.w3.org/2001/XMLSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema.xsd" xmlns:ns1="URI1" targetNamespace="URI2" elementFormDefault="qualified" attributeFormDefau...