i want to prevent some referential integrity scripts to be deployed at the
subscriber *before* the snapshot is applied , is there a way to interfere
with initial snapshot programmatically?
thanks in advance
There are a couple of ways. You can use the Pre- and Post snapshot commands
to run extra scripts eitehr before or after (or both). You can stop the
distribution task and hand-edit the snapshot after it is created. Note that
the second method will have to be redone on every new snapshot.
As for Referential Integrity, they are not automatically applied since you
may choose to replicate child tables without the parent tables. You can add
them on, but it is not recommended since they tend to interfere with
snapshot application.
Geoff N. Hiten
Microsoft SQL Server MVP
"uykusuz" <yb> wrote in message
news:ewKbjm9gFHA.3568@.TK2MSFTNGP10.phx.gbl...
>i want to prevent some referential integrity scripts to be deployed at the
> subscriber *before* the snapshot is applied , is there a way to
> interfere
> with initial snapshot programmatically?
>
> thanks in advance
>
No comments:
Post a Comment