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