On Thu, Feb 17, 2000 at 11:21:54AM +0800, Santosh Shotemba wrote:
>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.
Santosh, I can sympathize with you in your position. This is more of
a general systems administration problem than a MySQL problem - yes,
the solution will probably start with a "SELECT INTO OUTFILE" command
in MySQL, but that's the easy, obvious part. The rest of it depends
entirely on what tools you have available to you.
I would take this approach: first, catalog all of the tools at your
disposal - what suite of software / database are they using? What
programs do they have for manipulating data? Can you set up scripts
on their machine? Or can scripts on your machine connect to theirs
via [FTP,uucp,rsh,any other method]? Maybe you can install the MySQL
client on their machine and simply use that!
Perhaps you can install Perl on their machine and use its Net::*
libraries to connect to your machine and fetch the data needed. I
don't know - you have to find out what is available.
Once you know that, you will be able to accomplish the needed tasks.
Break the whole problem down into logical components: get data out
of database; transfer data to local machine; import data into whatever
software they're going to use it with.
Good luck!
Tim
--
Tim Smith < tim@stripped > :MySQL Development Team: Boone, NC USA.
