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!!!
update local db with information from a remote db
Moderator: General Moderators
-
kettle_drum
- DevNet Resident
- Posts: 1150
- Joined: Sun Jul 20, 2003 9:25 pm
- Location: West Yorkshire, England
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.