Re: on-line and near-line databases

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Mar 8, 4:04 pm, "Paul Ibison" <Paul.Ibi...@xxxxxxxxxxxxx> wrote:
One way to achieve this is to use transactional replication and select to
not replicate deletes (NONE for the command).
Cheers,
Paul Ibison SQL Server MVP,www.replicationanswers.com


Thanks, that's helpful! I can see how that would work for the A->B,
fairly straightforward.

For the B->A, i.e. re-importing a deleted returning user by selecting
a set of rows from many tables filtered by a 'partyid' primary key,
would replication be able to help us or would we just use SQL to grab/
insert them?


.

Relevant Pages

  • Re: Replicating everything but deletes
    ... on Commands, and for the delete command enter NONE. ... what you will find is that you will probably want to replicate ... subscribers or replicate it to your subscribers using the post snapshot ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: 2 way replication.
    ... updatable transactional replication might be more relevant. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: 2 way replication.
    ... updatable transactional replication might be more relevant. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Centralized Subscriber - MSIns and MSUpd stored procedures shared access
    ... avoid the complete initialization process and dropping of procedures. ... the update and delete command, in which case the stored procedures won't be ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • RE: What about a table "re-creation" ?
    ... I would get a request to add a ... column to a replicated table and populate the column based on a percentage of ... > transactional and merge would both replicate the changes. ... > Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)