Synchronising dbs from several servers

[Ruslan Zasukhin]

On 10/28/04 5:30 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

>> You can read about replication.
>> One server publish some tables, other servers subscribe to them.
>> Only publisher can write to that tables, rest read.
>> 
>> You can think about usage in these 2 tables the COLUMN 'datetime'.
>> And use its for synchronization.
> 
> Each outlet can be a publisher, eg customer goes to outlet 10, buys
> something, then 15 minutes later he goes to outlet 15 and there must be the
> changes already downloaded...

So you need 2-ways replication...
Even more harder.

> I know that the common way is to store the relevant data on the card, but
> this is no option here.

> So I upload the data to a server, adding to more fields FROM_OUTLET and
> FROM_ADRESS_ID. This is actually no big problem. A script is running
> constantly to synchronize non-stop.

> But having to rewrite all parts that change is a hard way since I have to
> filter out 2 tables from 50, only changes in these tables are to be
> synchronized.

> I need something like "Hey, table 1 is changed, we must synchronize..."
> 
> No idea?

In Lingo ?

I think in Lingo you have procedural way of programming.
So you do not have polymorphism,
And therefore you have only one way:

    to use if() or switch()



-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------