Re: ** mv versus advanced replication
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: ajoshi977@xxxxxxxxx
- Date: Wed, 6 Sep 2006 17:43:11 +0200
If you are doing one-way propagation dont even consider advanced
replication. If you are doing two way then your only choice is advanced
replication, I dont think your choice is based on "How easy is to setup X",
rather is what is your requirements.
MV Replication is very easy to setup but bear in mind the limitations and
the volume of data you have to replicate. Consider also the interval,
hourly, daily?
Regards
On 9/5/06, A Joshi <ajoshi977@xxxxxxxxx> wrote:
Hi,
I have a 250 GB database and need to replicate it with almost all the
tables. I am thinking of doing MV replication. Other options are advanced
replication and logical standby. What are pros and cons of using MV as
opposed to advanced replication. I think some of the maintenance to be done
is less in case of MVs and it is simpler to understand and setup. Any
advantages for advanced replication? What about data integrity on target. I
think advanced replication checks before applying changes so any loss of
transaction is detected. Is there any check in case of MV? Any tools to
check the data on target? I think the performance impact degradation on
source for both is almost same.
Thanks for your help.
------------------------------
Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small
Business<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/>.
Other related posts:
