Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Down

Replication Find similar branches


Victor Tsay   (2001-11-29 10:02) [0]

Good day to all!

Please advise how best to write the transfer processing and data updates.
There are two computers that connect once a day via modem. Modify and add data can on any of the computers. Maybe someone will advise how to make replication and updating data more elegant. Now I am inclined to the fact that for each table I make a copy of it where, during the "Post" event, I write the modified or added record and in the future I transmit all the changes (copies of the tables) by modem. Upon receipt, I process the resulting tables and, accordingly, add or change the working base.
But I do not like this method at all. It is too bulky, too many tables. Can anyone come across this?
Thank you in advance for your reply.



p@s   (2001-11-29 10:22) [1]

We used a table in which there was only an instance key, an instance version number and signs - created / modified / deleted. During replication, records were selected for which the s / m / y flag was set, the version number increased by one. The data retrieved was transferred to another office. There was a version analysis. The number of the incoming version of the instance should be one more than the current one. If more than one - it means they lost the package. If less than or equal, then the instance was adjusted in both places and it was necessary to ascertain in which place the data is relevant. This was usually done over the phone. After that, the replica was either accepted or rejected.
In short, something like this.



Dick Gonsales   (2001-12-04 05:33) [2]

You can when analyzing POST
immediately draw a line on
corresponding operation (APPEND FROM / DELETE FROM /)
and write as ddhhmmss.PRG
and send it by modem to another machine
let's say every 30 minutes, on the other hand, similarly
received files with cyclic bat
which, upon finding the * .prg file, executes it and then
move drive: / arc / yymmdd /

In this case, as I understand it, you will love
a lot of questions if your employees changed
one and the same line in these half an hour, which of them is right ???
You can of course add to each table by field
last_update (DATE) and look at it later who and parv,
but this is purely your specific sharpening and decide
only you can do it. Track such records for the same
last_update (date)



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Top





Memory: 0.55 MB
Time: 0.023 c
1-22087
Serg5
2001-12-19 15:14
2002.01.08
People, quite an easy question! Link to the procedure in one word.


1-22063
Type
2001-12-18 15:12
2002.01.08
And you can block access to the folder, something like fmShareExclusive, but for the folder ???


4-22464
Dimich
2001-11-01 14:50
2002.01.08
Books on API in Russian


1-22099
Yulyashka
2001-12-19 17:43
2002.01.08
Question about DBGrid !!


3-21977
Amelin Vadim
2001-12-03 20:42
2002.01.08
Creating a database in InterBase





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic indonesian Irish italian Japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Spanish swahili Swedish thai turkish Ukrainian urdu vietnamese welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada Khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish