2 Replies Latest reply: Nov 17, 2012 9:48 AM by user12020072 RSS

    Replication of recent data only

    user12020072
      Here is the situation:

      Two different databases DB1, and DB2.

      Application that use DB2 need to access one table in DB1 with SELECT only access. This table has over 100 million rows partitioned by week. Application only need data that came in last 5 days.

      For 5 days of data I do NOT want to replicate the entire table in DB2.

      What are my options?

      Thanks in advance!