Showing posts with label merge. Show all posts
Showing posts with label merge. Show all posts

Wednesday, March 28, 2012

Problem with job

Hi there,

Actually I'm trying to replicate a production database to a development server using merge publication. (I'm using Microsoft SQL Server 2005 - 9.00.2047.00).

When I created the publication job (automatically when creating the publication) I specified to get executed every 15 minutes, and later I created a subscription (push subscription) I specified it to execute continously. So I made some chenges on the data on the production server, and they get replicated every minute aprox. , and not in 15 min intervals as I defined before.... When I go to the server agent I can see the job for publication and It is supposed to be executing the publication every 15 min as I defined but this doesn't happen !!!

Is this a Bug ? Is there any fix ?

Thanks !

The subscription job, which you set to run continuously, is what's moving changes between publisher and subscriber. This runs/polls every 60 sec, which is why you're seeing changes replicated every minute. THis behavior you're seeing is by design and expected. If you want it to replicate every 15 minutes, then change the schedule for this subscription job.

I'm not sure what a "publication" job is, maybe you're referring to the snapshot agent job? For merge replication, its typical to schedule the snapshot agent to run maybe once a day, but not every 15 minutes. You may want to change it.

So no it's not a bug

|||

I've got my problem solved !!! Thank you so much !

Greg Y wrote:

The subscription job, which you set to run continuously, is what's moving changes between publisher and subscriber. This runs/polls every 60 sec, which is why you're seeing changes replicated every minute. THis behavior you're seeing is by design and expected. If you want it to replicate every 15 minutes, then change the schedule for this subscription job.

I'm not sure what a "publication" job is, maybe you're referring to the snapshot agent job? For merge replication, its typical to schedule the snapshot agent to run maybe once a day, but not every 15 minutes. You may want to change it.

So no it's not a bug

sql

Monday, March 26, 2012

Problem with Interactive Resolver

This is my question,
I already have the whole model for a Merge publication; I have tables
intended to perform resolve interactive conflicts. This configuration is
done in the publisher in sql servr 2005 and in the clients working with sql
Express. To perform data synchronizations I use Windows synchronization.
However, when synchronizing and one of the clients reaches conflict, the
following error prompt appears:
The merge process failed to get correct information about the Interactive
Resolver component from the registry. Verify that the registry exists and
that the path is correct.
Can anybody please help me' Any help wil be welcomeHi Hector
Did you check out http://tinyurl.com/qcw6p?
John
"Hector" wrote:

> This is my question,
> I already have the whole model for a Merge publication; I have tables
> intended to perform resolve interactive conflicts. This configuration is
> done in the publisher in sql servr 2005 and in the clients working with s
ql
> Express. To perform data synchronizations I use Windows synchronization.
> However, when synchronizing and one of the clients reaches conflict, the
> following error prompt appears:
> The merge process failed to get correct information about the Interactive
> Resolver component from the registry. Verify that the registry exists and
> that the path is correct.
> Can anybody please help me' Any help wil be welcome
>

Problem with Interactive Resolver

This is my question,
I already have the whole model for a Merge publication; I have tables
intended to perform resolve interactive conflicts. This configuration is
done in the publisher in sql servr 2005 and in the clients working with sql
Express. To perform data synchronizations I use Windows synchronization.
However, when synchronizing and one of the clients reaches conflict, the
following error prompt appears:
The merge process failed to get correct information about the Interactive
Resolver component from the registry. Verify that the registry exists and
that the path is correct.
Can anybody please help me' Any help wil be welcomeHi Hector
Did you check out http://tinyurl.com/qcw6p?
John
"Hector" wrote:
> This is my question,
> I already have the whole model for a Merge publication; I have tables
> intended to perform resolve interactive conflicts. This configuration is
> done in the publisher in sql servr 2005 and in the clients working with sql
> Express. To perform data synchronizations I use Windows synchronization.
> However, when synchronizing and one of the clients reaches conflict, the
> following error prompt appears:
> The merge process failed to get correct information about the Interactive
> Resolver component from the registry. Verify that the registry exists and
> that the path is correct.
> Can anybody please help me' Any help wil be welcome
>|||I'm having the same problem now!
Chris
18-Jul-06 09:08:01
This is my question,
I already have the whole model for a Merge publication; I have tables
intended to perform resolve interactive conflicts. This configuration is
done in the publisher in sql servr 2005 and in the clients working with sql
Express. To perform data synchronizations I use Windows synchronization.
However, when synchronizing and one of the clients reaches conflict, the
following error prompt appears:
The merge process failed to get correct information about the Interactive
Resolver component from the registry. Verify that the registry exists and
that the path is correct.
Can anybody please help me' Any help wil be welcome
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Monday, February 20, 2012

Problem with Dataset.Merge

Hello guyz,
I am using SQL server and I want to merge two datasets. I have two tables which are similar in structure-(same number of columns). I want to display these two tables in one datagrid. I have 5 rows in the first table and 3 on the other. So in the datagrid it should have 8 rows. Part of my code is below…

ConnectToDatabaseServer()
Dim querystr As String = ("Select username, password from PublicAccounts")
Dim da As SqlDataAdapter = new SqlDataAdapter(querystr, myConnection)
Dim ds1 As DataSet = new DataSet()
da.Fill(ds1, "firsttable")

querystr = ("Select username, password from EmployeeAccounts")
Dim da2 As SqlDataAdapter = new SqlDataAdapter(querystr, myConnection)
Dim ds2 As DataSet = new DataSet()
da2.Fill(ds2, "secondtable")

ds1.Merge(ds2,False, System.Data.MissingSchemaAction.Add)
MergeGrid.DataSource = ds1
MergeGrid.DataBind()
myConnection.Close()

This code only displays the contents of ds1 (5 rows).
My table structure are as follows:
PublicAccounts (username Char(50), password char(50), pid integer primary key)
EmployeeAccounts (username Char(50), password char(50), eid integer primary key)

I really would appreciate any help.
Thank you..couple of ideas. nothing jumps out at me immediately. try setting preservechanges to true (the second parameter of the ds1.Merge) just for grins.

also, try wrapping the merge in a try-catch block and see if any errors are being thrown. that might help narrow it down.

cs