Hi

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
others.
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.

Regards

Michael

--- 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
replicants.
> 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
compressed)
> link through the net.
>
> setting up the networking aspect was not too difficult, the more
difficult
> part was writing the synchonization part of the
application/database. i used
> GUIDs to ensure unique keys were created at each site, added
modification
> timestamps to each record (which had to be done by the application
rather
> 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
this
> > way, but wants to have two seperated systems, which could
replicate
> > 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
http://docs.yahoo.com/info/terms/
> >
> >
> >