SQL Server Performance

Replicate tables

Discussion in 'General DBA Questions' started by reethu, Mar 23, 2007.

  1. reethu New Member

    Hi everyone,I am new to Replication
    I need to replicate data from the staging tables into new SQL/Server tables. Approximately 25 tables will be replicated from staging area
    situation that in existingly we have SqlServer from that we need to keep 30 tableS available for webapplication or some other purposes.so we need to create seperatly that 30 tables on same database.Situation is that OLD Tables and NEW Tables should be in consistant state(must be replicated).when we do some modification on old tables the new tables should automatically updated.(ALL THIS ON SAME SERVER AND SAME DATABASE ONLY SEPERATER GROUP OF TABLES/ONLY THING IS TABLES SHOULD CONSISTANTLY UPDATED.)
    so please give me suggestion which method is good.if it should be done by triggers or some other coding process please provide some guidlines or example code.

    Thanks in advance


    SRJ2005
  2. MohammedU New Member

    It can be done by triggers and replication also be used but depends on the new table modifications......


    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page