keep relationships
- From: "Ben" <null@xxxxxxxx>
- Date: Thu, 12 May 2005 15:14:51 -0400
Hi,
Which type(s) of publications keep the relationships and constraints when
the schema and data is pushed over to the subscriber ?
.
Relevant Pages
- Re: Two tables and count
... Please post DDL, so that people do not have to guess what the keys, ... constraints, Declarative Referential Integrity, datatypes, etc. in your ... approach and schema are an attempt to imitate a punch or paper form in ...
(microsoft.public.sqlserver.programming) - RE: Indexes and keys are not synced w/ snapshot publication
... constraints should be copied to the subscriber even though the ... destination object name is different than source object name. ... >> I am having trouble getting the indexes and primary keys copied to the ...
(microsoft.public.sqlserver.replication) - RE: Indexes and keys are not synced w/ snapshot publication
... all indexes, primary keys, etc. were successfully transferred. ... > destination object name is different than source object name. ... > same constraints at the subscriber. ...
(microsoft.public.sqlserver.replication) - Re: Merge replication with foreign key constraints
... > constraints is that you might add an row to a child table which you are ... > replicating on the publisher where the row exists on the parent table. ... > on the subscriber and publisher. ... REPLICATION, so if replication job first inserts child table - it will work. ...
(microsoft.public.sqlserver.replication) - Re: Production error: "The schema script [...] could not be propagated to the subscriber"
... it first makes sure that the schema [any ... I believe the Merge Agent is trying to drop the column at the subscriber, ... but unable to do it because it is the primary key column. ... are unable to replicate their database and they'll turn nasty shortly. ...
(microsoft.public.sqlserver.replication) |
|
