Hi,

I want to update/insert data from a master db to a slave db, I am
looking for a tool/utility that compares rows and creates a script, or
directly updates the slave based on the master db.

Although I have access to and can update the slave db, to do so is
very slow at the moment as there are over 106k records which can
change on a daily basis, to update the entire slave is slow as its
over the internet and takes in excess of 2 hours. To update a master
db locally is about 3 - 4 minutes.

Can anybody suggest a tool that will fit the above? Just for info the
slave db is required 24/7 as its the backend for a website which can
not be taken off line whilst the update is applied.

regards

Si

p.s. Helen, sorry for my previous post, its been several years and I
forgot which list to post to :-(