Subject Re: Replication ATT PETE B.
Author Michael Vilhelmsen

I would like to know a little more.
To start with, I could tell you a little more about our situation.

I have a client which have a main site and 2 remote locations.
They have (at first) denied to establich a connecting to the internet
like ADSL.
Therefore I have started looking for alternatives.

And here I thought about replication.

I would like to have a DB running at the main site, where clients
connects via LAN.

And on my remote sites, I would like to have a "copy" of my DB.

Then at some either scheduled time, randomly, at data change etc. I
would like the replications to go on.

Would this be good with a 56K modem line ?
Would this be good with an ISDN Line ?
Or would this be good with an ADSL line ?

I would have to do replication both ways on some data, and 1 way on
Is this posible ?

At your particullar site, what specific product do you use (DB,
Programs (your own or bought ones), replication programs, etc).

Hope you can give me more information on this subject.



--- In ib-support@y..., "Pete Bray" <pete@s...> wrote:
> we run a system which has a head office with 20 or so clients
working on the
> w2k 'master' database and 4 outstations which work with local
> the application program performs the synchronization by attaching
to both
> databases and pumping the data both ways. various methods of
connection are
> used from isdn and v.90 dial-up direct connection to the server.
we've just
> added a linux server running SSH at the head office, and use
freeware ssh
> windows client software (called Putty) to provide a secure (and
> link through the net.
> setting up the networking aspect was not too difficult, the more
> part was writing the synchonization part of the
application/database. i used
> GUIDs to ensure unique keys were created at each site, added
> timestamps to each record (which had to be done by the application
> than a trigger because we needed universal time to cope with
offices in
> different time zones). I added a time server at the head office so
that the
> outstations all kept their clocks in sync.
> there is a commercial replication server which may be the way for
you to go,
> but if there is anything in the above which you think is of
interest to your
> application i'd be happy to supply more detail.
> Kind regards,
> Pete
> > -----Original Message-----
> > From: Michael Vilhelmsen [mailto:Michael.Vilhelmsen@M...]
> > Sent: 11 September 2002 08:11
> > To: ib-support@y...
> > Subject: [ib-support] Replication
> >
> >
> > Hi
> >
> > I have made a program which uses Firebird.
> > This program has been sold to a some customers.
> >
> > Now some of these are about to open some new shops.
> > So far we have used a Terminal Server in the head office, and then
> > letting the clients connect to this server.
> >
> > But at this point we have a customer who does not wish to do it
> > way, but wants to have two seperated systems, which could
> > against each other (via internet or something like that).
> >
> > Is this posible ?
> >
> > And can I find some information on this subject somewhere ?
> >
> > Thank you in advance.
> > Michael
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> >
> >
> >