Merge Replication with Foreign Keys

I have a database with related tables by foreign keys (Not for Replication),
and I want to use Merge replication, is there any problem to keep the foreign
keys on both sides (publisher and subscriber) or I have to remove them?
Saeed,
you can keep them - as long as they have the NFR attribute.
If you are replicating a huge amount of data, there are issues, and this
article will help explain them:
http://support.microsoft.com/kb/308266/EN-US/
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql

Merge Replication Replicate Master and related tables

hi all,

Could we configure a merge replication such as replicate the master table and its all related tables (relation deep could be 1.)

We dont want to manually find master table relations and configure replication for the related tables.

please help for that configuration

kinds

No but why would you want to?|||No, replication wizard will not find and define all the FK dependencies for you, you have to do this yourself.|||Thanks StatisticsIO.com and Greg Y for your valuable help. |||In repl UI, there is capability to create a dynamic filter on the parent table and then automatically generate the join filters based on PK-FK, do try it out in the publication wizard.sql

Merge Replication Error

I have a table called Table1 at both pulisher and subcriber which is related
to
many other tables. If i modify a row at the subcriber then instead of
updating the row at pulisher..merge agent detects conflict and overwrites the
row at the subcriber with the row that publisher has and newly inserted row
at subscriber is added to conflict table with the errortype =9 and text
The row was updated at subcriberX but could not be updated at PublisherX.
Unable to synchronize the row because the row was updated by a different
process outside of replication.
I am using SQL Server 2000 with SP4
ThanksI believe this error is cause by a non-logged operation - like DTS. Did you
DTS some data into one of the tables you are merge replicating?
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:2C08C5E7-EC46-4110-8027-51AB8EF2C290@.microsoft.com...
>I have a table called Table1 at both pulisher and subcriber which is
>related
> to
> many other tables. If i modify a row at the subcriber then instead of
> updating the row at pulisher..merge agent detects conflict and overwrites
> the
> row at the subcriber with the row that publisher has and newly inserted
> row
> at subscriber is added to conflict table with the errortype =9 and text
> The row was updated at subcriberX but could not be updated at PublisherX.
> Unable to synchronize the row because the row was updated by a different
> process outside of replication.
> I am using SQL Server 2000 with SP4
> Thanks|||Hello Hilary,
I am not using DTS or other non logged operations..but still i get this error
"Hilary Cotter" wrote:
> I believe this error is cause by a non-logged operation - like DTS. Did you
> DTS some data into one of the tables you are merge replicating?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "kailux4" <kailux4@.discussions.microsoft.com> wrote in message
> news:2C08C5E7-EC46-4110-8027-51AB8EF2C290@.microsoft.com...
> >I have a table called Table1 at both pulisher and subcriber which is
> >related
> > to
> > many other tables. If i modify a row at the subcriber then instead of
> > updating the row at pulisher..merge agent detects conflict and overwrites
> > the
> > row at the subcriber with the row that publisher has and newly inserted
> > row
> > at subscriber is added to conflict table with the errortype =9 and text
> >
> > The row was updated at subcriberX but could not be updated at PublisherX.
> > Unable to synchronize the row because the row was updated by a different
> > process outside of replication.
> > I am using SQL Server 2000 with SP4
> >
> > Thanks
>
>

Merge Replication and FK constraints

This question is also posted in public.sqlserver.ce, Sorry!
Scenario:
SQL 2000 with 3 tables A, B ans C related to each other with FK constraints.
B has a relation to A and C has a relation to B
In the FK columns the option 'Enforec relationship for replication' is
unchecked
Merge replication to SQL CE
I would like to take some rows from A set up a filter to include related
rows from B and ALL rows from C
In my mind this should work. Despite the fact that there will be some rows i
C with no parent row i B the replication should execute whitout errors.
I got the following confusing error message:
@."Exception 1: Error Code: 80004005 Message : Run Minor Err.: 28557 Source
: Microsoft SQL Server 2000 Windows CE Edition Err. Par. : data
source=\Program Files\VPJ\VPJ.sdf;Exception 2: Error Code: 80040E14 Message
: The OLE DB Execute method failed. The SQL statement is not valid. [,,,SQL
statement,,] Minor Err.: 28560 Source : Microsoft SQL Server 2000 Windows
CE EditionException 3: Error Code: 80040E14 Message : There was an error
parsing the query. [Token line number,Token line offset,,Token in error,,]
Minor Err.: 25501 Source : Microsoft SQL Server 2000 Windows CE Edition
Num. Par. : 1 Num. Par. : 145 Err. Par. : NOT"
Anyone who have succeeded to replicate between SQL 2000 and SQL CE in a
similar scenario
/Thomas B
We do not support the NOT FOR REPLICATION option with SQL Server CE. Make
sure that the box is checked
thanks
gopal