2 Replies Latest reply on Nov 17, 2012 3:48 PM by user12020072

    Replication of recent data only

      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!