update local db with information from a remote db

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
vampira
Forum Newbie
Posts: 3
Joined: Fri Dec 13, 2002 12:05 am

update local db with information from a remote db

Post 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!!!
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post 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.
vampira
Forum Newbie
Posts: 3
Joined: Fri Dec 13, 2002 12:05 am

Post by vampira »

and how can i make that script automatic? it is possible to add a php script to the windows task programmer??
Post Reply