Replicate Table A to a table with a different name
Here's the situation:
Database 1 contains Table A.
Database 2 contains Table A. (which is different than the first Table A)
Databases 1 and 2 are on different servers
I want to replicate certain tables from certain databases into a single database on a single server, while simultaneously renaming the tables to prevent naming conflicts. So, something like the following needs to happen:
database1.tablea replicates to replica.db1_tablea
database2.tablea replicates to replica.db2_tablea
Is it possible to set this up using MySql replication? If so, how would I go about it? If not, what can I do to accomplish the same goal?
Thanks in advance for any help anyone can provide!
Subject
Views
Written By
Posted
Replicate Table A to a table with a different name
4354
March 06, 2007 05:51PM
1635
April 18, 2007 10:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.