Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pherkad
Starting Member
23 Posts |
 Posted - 2007-04-10 : 05:52:58
|
| i'm struggling with merge replication and foreign key constraints.i have four tables:- owners(id, name, firstname, address, phone)- cars(id, licenceplate, ownerid) (thus with ownerid FK to the owners table)- busses(id, licenceplate, ownerid) (thus with ownerid FK to the owners table)- ships(id, licenceplate, ownerid) (thus with ownerid FK to the owners table)now, i want to merge only the OWNERS table (article) between my 5 client pc's and 1 server.I don't manage to reach this.Using the merge replication upon all 4 tables works, but replicating only the owners table seems to be impossible.Is it really impossible to replicate only the owners table, or do I forget something?these are my create table scrips:create table Owners ( id int identity, name varchar(20), firstname varchar(20), address varchar(20), phone varchar(20), CONSTRAINT PK_owners PRIMARY KEY(id));create table cars ( id int identity, licenceplate varchar(20), ownerid int, CONSTRAINT PK_cars PRIMARY KEY(id), CONSTRAINT FK_cars_ownerid FOREIGN KEY(ownerid) REFERENCES owners(id) ON DELETE CASCADE );create table busses ( id int identity, licenceplate varchar(20), ownerid int, CONSTRAINT PK_busses PRIMARY KEY(id), CONSTRAINT FK_busses_ownerid FOREIGN KEY(ownerid) REFERENCES owners(id) ON DELETE CASCADE );create table ships ( id int identity, licenceplate varchar(20), ownerid int, CONSTRAINT PK_ships PRIMARY KEY(id), CONSTRAINT FK_ships_ownerid FOREIGN KEY(ownerid) REFERENCES owners(id) ON DELETE CASCADE ); |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-04-17 : 16:34:04
|
| You should be able to do that. I doing that at my prod. What error you are getting?------------------------I think, therefore I am - Rene Descartes |
 |
|
|
sami273
Starting Member
9 Posts |
Posted - 2007-05-03 : 06:24:48
|
| There's no problem publishing only one table of four. What are the symptoms? Error messages? |
|
|
|
|
|
|
|
|
merge replication and foreign keys