|
Conflict handling
Hello,
I am writing my own conflict resolver.
I case of errors during merge-phase (for example Foreign Key errors), I want
that the changes are retried in the following merge-phase. To achieve this, I
set the 'compensate_for_errors' property of articles on false. This works
fine.
In some cases I want ...
Thu, 2 Dec 2004 01:39:05 -0800
|
Merge replication with foreign key constraints
Let's say I have a database with three tables. One for customers, and two
for the invoices. Customers have cust_id field, wich is 'surogate' key, it
contains the org_id where the customer was created. That table should be in
merge replication because I need to be able to add data and make changes on
all locatio ...
Thu, 2 Dec 2004 08:54:48 +0000 (UTC)
|
Transactional vs Merge Replication: 2 Publishers and 1 Subscriber
Hi everyone,
I have 2 publishers and 1 Subscriber. I'd like to implement a one-way
replication. Each table has a primary key but most of the new records
inserted in the publisher DBs are identical (only a few records are "unique"
to each DB).
1) Should I use Transactional or Merge Replication?
2) How ca ...
Wed, 1 Dec 2004 21:43:01 -0800
|
Transactional Replication
Hi All,
I have tested transactional replication on test server .It's working fine.On
my live server , huge data is getting inserted every day , around 2000
records per day .
update happens around 200 per day . I have a doubt about the transaction log
getting increased . I have tested the same on test server ...
Thu, 2 Dec 2004 10:31:44 +0530
|
Dealing with conflict tables
I'm starting to develop quite a list of conflict tables in my Publisher
database (merge repl). I've not been down this road before, but all I need
is pointed in the right direction on how to resolve these.
...
Wed, 1 Dec 2004 23:41:22 -0500
|
Just push to one subscriber
We have one publisher push the same set of data to 3 subscribers. Problem is
one subscriber went down today . How can I enable replication for just this
subscriber without pushing the data all over again for the other 2 that are
running fine now ? Thanks
...
Wed, 1 Dec 2004 16:28:00 -0800
|
can you drop an article from a pulication without re-initializing?
I have a publication with 5 tables in it. I need
to drop one of them without affecting the other
4. Is this possible?
thanks,
-comb ...
Wed, 1 Dec 2004 13:32:34 -0600
|
more than 1 distribution job
I have Transaction, non Immediate Updating replication set up between two
boxes on one databas each. For whatever reason, I have more than 1
distribution agent job? Of course only one is runnning. However, I'm trying
to write an sp that will stop the replication jobs and it's causing problems
to have more than ...
Wed, 1 Dec 2004 09:38:40 -0800
|
merge replication error
JFB,
on SQL Server 2005 you can specify the article processing
order, but not on SQL Server 2000. To avoid this type of
issue, you could put the views into a separate
publication or use sp_addscriptexec to send over
separately (not forgetting the permissions though).
Rgds,
Paul Ibison
...
Wed, 1 Dec 2004 09:08:22 -0800
|
merge replication error
Hi All,
I,m trying to pull a suscription for the first time so I create the database
when I create the suscription but I'm getting this error.
could not be propagated to the subscriber.
(Source: Merge Replication Provider (Agent); Error number: -2147201001)
-------------------------------------------------- ...
Wed, 1 Dec 2004 11:53:41 -0500
|
Help after the server was renamed before replication was taken dow
I would script out the replication settings then disable
replication on the server. Make sure that SQL Server has
been reconfigured:
Use Master
go
Select @@Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Ma ...
Wed, 1 Dec 2004 08:10:39 -0800
|
Help after the server was renamed before replication was taken dow
Is there an easy way to take apart replication when a server has been
renamed. The sever in question was a subscriber to one publication and the
publisher of another. Is there an easy way to drop the relvant subscriptions
publications now that this server has been renamed. As I presume sql does not
just ada ...
Wed, 1 Dec 2004 07:53:08 -0800
|
How to replicate data from Oracle to SQL Server 2000
From the SQL Server point of view, this is possible to
set up in SQL Server 2005. For the current versions, I
think you'd be better off posting in the Oracle
newsgroups.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/09749736 ...
Wed, 1 Dec 2004 07:44:42 -0800
|
Merge replication very very slow
You could enable logging as per this article:
http://support.microsoft.com/?id=312292 in order to try
to get more info.
To troubleshoot connectivity issues:
(a) run a ping -t for a day and then look at the
statistics to see if a hicup occured.
(b) You could run this keep alive script which will tell
yo ...
Wed, 1 Dec 2004 07:22:42 -0800
|
Not All Data Being Replicated
Tommy,
are you using filters at all - dynamic or static?
Do you have a definite case where a row inserted on the
publisher goes to one subscriber and not the other? Cna
you script out the replication subscriptions and compare
the 2 scripts to look for differences.
HTH,
Paul Ibison SQL Server MVP, www.repl ...
Wed, 1 Dec 2004 07:09:05 -0800
|