Keeping my databases in sync?

Databases
1

I’m updating my database with a set of data from another database. When there is an item deleted from the source db, how would I make sure it’s deleted from the db copy given that I have to run the update in a batch and can’t run it when the item is deleted? Would I truncate the db at the beginning of each update, then pull all the of data over?

*The reason this is posted in PHP is because I have a followup on how to accomplish the answer in PHP. I am having trouble executing two queries for some reason.

[EDIT]I like your optimism, but I think this has a better chance of getting past the first step in the database forum, seeing as this is a relatively “advanced” topic - well, at least it is to me. If you don’t want to start a separate thread later and it doesn’t get moved, please Report it or let me know.

  • Mittineague[/EDIT]
2

What kind of database you are using? can you set up a triggers?

3

if there’s nothing that needs to be saved in the target database, this is the most efficient way

4

Thanks for the replies, just wanted to check.