This discussion is archived
2 Replies Latest reply: Nov 17, 2012 7:48 AM by user12020072 RSS

Replication of recent data only

user12020072 Newbie
Currently Being Moderated
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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points