Do not need Schema changes to subscriber after replication

• panvalkar

  Grasshopper

  Points: 11

  More actions

  June 24, 2010 at 1:55 pm

  #226073

  I need help with a replication scenario which might come up soon as we plan to implement replication at my organization shortly.

  We have two servers A and B. A is prod and B is reporting server.

  A has highly denormalized tables but Tables in B are normalized as well as well indexed.

  We would like to initiate replication between A and B but not loose the normalization or table structure of B. Also A is SQL 2000 and B is SQL2005.

  Is there any way we can replicate only data from A and fill it up in tables in B without loosing schema or normalization ?

  Can someone guide me with a feasible solution.

  Thanks for your help in advance.

• noeld

  SSC Guru

  Points: 96590

  More actions

  June 25, 2010 at 11:53 am

  #1185175

  How is it possible that the production server is "denormalized" and the reporting is "normalized"... I have seen it the other way around though.

  
  * Noel