hi folks,
given the scenario below, i'm facing a big headache.
the company that i work for is in stationary business and we now supply
stationary items over the web. we have 1 client who is very keen to have
their own intranet procurement system for their stationary needs which we
will develop and host it on our site. of course, the system will be built
using mysql,perl,apahce and linux.
this is where i foresee a problem. once a week this company would like to
update their own rdbms with their purchase history. the purchase history
contains items they bought, qty, price , date...etc. all these records
reside with us on our server. now, how can i port these records to my
client's database server ? my client is using peoplesoft. at this stage, i'm
not quite sure what rdbms they're using.
one of the solutions that i have in mind is to generate csv file every week
and email it to their dba and ask him/her to upload to their server.
just in case they do not need any manual intervention in updating their dbms
server, how do i go about doing this ? looks like i need access to their
server, get purchase history records from my server, insert them into their
server. sounds simple but how can this be done ? 2 different networks and
miles apart. has anyone got any ideas ?
the worst thing is that i came to know about this last night and i have to
present the solution to the management on friday. aaaaaaaarrrrr.
any pointers, suggestions very much appreciated.
cheers,
santosh.
