If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > How to synchronize tables between two database.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-02-05, 06:04
meiwen meiwen is offline
Registered User
 
Join Date: Oct 2005
Posts: 30
Question How to synchronize tables between two database.

How to synchronize tables between several (at least two) database ?
I have DB1, DB2, DB3.... which contains table A, table B ...
As long as I Modify table A in any of the DB, then the table A in all the rest DB should be syncronized. same for table B, (but not whole database)...
There is no master and slave database, all DB (could be in different server)should be running.
Is there any mechenism for informix to do synchronize only on table level?
Or i am obliged to use trigger statetments on each table on update, delete, and insert ,then launch the trigger action in other DBs to do the same update, delete, insert? Is there simple solution?

Last edited by meiwen; 11-02-05 at 09:20.
Reply With Quote
  #2 (permalink)  
Old 11-02-05, 15:06
blackguard blackguard is offline
Registered User
 
Join Date: Sep 2002
Posts: 102
Yes there is a way. Its called Enterprise Replication (update anywhere).
Reply With Quote
  #3 (permalink)  
Old 11-02-05, 16:05
meiwen meiwen is offline
Registered User
 
Join Date: Oct 2005
Posts: 30
but as i understand enterprice replicate is for database in two server? (how about database in one server?), and it is for whole database (more for migration), could take a a lot of storage, even slow down the process...
Reply With Quote
  #4 (permalink)  
Old 11-03-05, 08:41
blackguard blackguard is offline
Registered User
 
Join Date: Sep 2002
Posts: 102
As long as the databases are located in different instances, you can set-up enterprise replication. Even they are located in the same server. You can even set-up HDR on the same server and different instances.
Reply With Quote
  #5 (permalink)  
Old 11-03-05, 10:14
meiwen meiwen is offline
Registered User
 
Join Date: Oct 2005
Posts: 30
Then could I set up the entreprise replication server only for certain tables in the database, but not for the whole database?
Reply With Quote
  #6 (permalink)  
Old 11-03-05, 10:16
meiwen meiwen is offline
Registered User
 
Join Date: Oct 2005
Posts: 30
Well, seems it can work on a group of tables. But another question,
if in DataBaseA, it is updating the same records as on DataBase B, how could I detect the conflict immediately?
Reply With Quote
  #7 (permalink)  
Old 11-03-05, 10:45
blackguard blackguard is offline
Registered User
 
Join Date: Sep 2002
Posts: 102
Quote:
Originally Posted by meiwen
Then could I set up the entreprise replication server only for certain tables in the database, but not for the whole database?
Yes. You add tables to replicate.
Reply With Quote
  #8 (permalink)  
Old 11-03-05, 10:47
blackguard blackguard is offline
Registered User
 
Join Date: Sep 2002
Posts: 102
Quote:
Originally Posted by meiwen
Well, seems it can work on a group of tables. But another question,
if in DataBaseA, it is updating the same records as on DataBase B, how could I detect the conflict immediately?
You define your conflict resolution in you Enterprise Replication.

Last edited by blackguard; 11-03-05 at 12:17.
Reply With Quote
  #9 (permalink)  
Old 11-04-05, 03:59
meiwen meiwen is offline
Registered User
 
Join Date: Oct 2005
Posts: 30
Unfortunately the enterprise replication solution is nearly refused, the reason is it cause a lot of problem. Well, i have never worked on update anywhere replication. Does it really has a lot of hidden problem? performance, space ? for only 6 tables which doent have a lot of transactions without big volumn of data?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On