replication model

• sqlserverdba76

  Newbie

  Points: 7

  More actions

  January 13, 2009 at 10:39 am

  #198217

  Hi all,

  i have one question for replication model.

  i have two server...server-1 use for production and another is use for data warehousing

  (reporting purpose)

  we have 6 month archive policy on production server-1.so keep only six month data.

  but i need all history data on server-2 for reporting purpose.

  so how can i scyn both servers?? one with only six month data and another with

  all hisotry data as well as current data.

  so can anyone tell me which replication model is perfect for my sceanario.

  Thanks in advance

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 13, 2009 at 11:03 am

  #926100

  You can set up transactional replication and then ensure two things:

  - Don't replicate "deletes"

  - Prevent updates to unique columns from being replicated as "delete+insert" instead of "updates"

  As long as you don't reuse PKs that were deleted on the source you are all set!

  
  * Noel

• sqlserverdba76

  Newbie

  Points: 7

  More actions

  January 13, 2009 at 11:52 am

  #926144

  Thanks for reply..

  well i already tried replication without delete...just wondering if there any other solution.

  anyway still thanks...

• noeld

  SSC Guru

  Points: 96590

  More actions

  January 13, 2009 at 2:50 pm

  #926256

  sqlserverdba76 (1/13/2009)

  ---

  Thanks for reply..

  well i already tried replication without delete...just wondering if there any other solution.

  anyway still thanks...

  And what is the problem with that ?

  
  * Noel