Page 1 of 1

update local db with information from a remote db

Posted: Sat Nov 06, 2004 11:40 pm
by vampira
hi guys!

i have some problems updating my loca db..
i should update my local db with my provider's remote db.. but they just give me a txt file with information about his db, like product quantity, etc.. his db and mine is not identical but many key fields are..
i want to use that txt file to update my local db..
and i want to do it automatically..

how can i do this??

please help!!!

Posted: Sun Nov 07, 2004 11:02 pm
by kettle_drum
Well if the database table fields are set up to hold only unique data, then you can simply import the data and it will only add new rows. If not then you will need to find or write a script that checks to see if the data in the txt file is in your database and is identical, and if its not update it etc. Without knowing how much and what fields are changed in these two databases its hard to say how complex that script will need to be.

Posted: Wed Nov 10, 2004 4:09 pm
by vampira
and how can i make that script automatic? it is possible to add a php script to the windows task programmer??