Re: Db synch - need advice

On 1/8/2011 1:26 AM, Didier Gasser-Morlay wrote:
> Now the sales manager wants each sales each sales person to have a
> netbook with a copy of the /subset/ of the client database he deals
> with, (in total around 20 tables) along with his agenda etc ... during
> the week, whilst travelling from client sites to client sites, the
> sales person can write reports about his visits (these are indexed in
> the database), amend the client/prospect database (add contacts, amend
> contacts, add notes ....) upon his return to the head office, the
> sales person 'plugs' his netbook to the network, press the 'synch'
> button and pooof all by magic all changes made locally are merged with
> the central database, taking into account any changes made to the
> central database. Once this merge process is finished, the sales
> person netbook is refreshed with a copy of the new database fragment
> he deals with.

Your sales manager should get acquainted with something called "the
Internet". The sales people should only log into the website providing
service, instead of carrying the database around. Also, they shouldn't
be carrying "notepads", "laptops" or any such contraption, they should
be carrying iPads. Make sure to spell it right, "iPad" is not the same
as "iPod". Your sales manager has a lot to learn.

--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com