This is a discussion on ER NotionS - PrimaryTarget & Tables Differents within the Informix forums, part of the Database Server Software category; --> Hello, Thanks again for your help. We'll investigate this method but as you said, maybe, the banwidth will be ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hello, Thanks again for your help. We'll investigate this method but as you said, maybe, the banwidth will be the problem. I'll give you the results when it is done. I have another question if you still have a little time. We have a Server on which we want to consolidate datas from Others Servers If, Serv_Centr is the Central Server with DataBase Serv_Centr And, Serv_A and Serv_B are Server linked to manufactories I have Two Tables to Replicate for instance. TableEq and TableNotEq On The command "cdr define repl" I have the choice to put the R and the P to say that it is Read-Only and Primary. But what does it mean ? Personnaly, I put the ReadOnly for the Serv_A and Serv_B, so, I'm sure that the Production DB will never be synchronised. But what I'm afraid is that it mean that I had to put the Primary on the Serv_Centr. Am I wrong with my philosophy ? In my case, what will be the direction of the replication ? From Serv_A and Serv_B TO Serv_Centr ( That what I'm looking for ) OR From Serv_Centr TO Serv_A and Serv_B ( That is NOT what I'm looking for ) Other Question : For the table TableEq, it is easy, it is the same that all databases. So, I can define a repl with "select * from TableEq" For the table TableNotEq, how can I do to make understand that the tables are different. For instance, Serv_A has his table with only a Primary Key called "manr" Serv_B has the same table I need that those tables have to be replicated on one table called TableNotEqBIS that will have one column more that will be called "siteno" and that will contain the name of the Serv_A from which the datas are coming? So, If the table on serv_A has for example manr 59 date 05102004 name Bj And on the table on serv_B manr 59 date 05102004 name Bj I should have on serv_Centr the table with the column "siteno" added 1rst Row siteno ServA manr 59 date 05102004 name Bj 2nd Row siteno ServB manr 59 date 05102004 name Bj Regards, Bj |