Hi,

At February-03-11, 7:54 PM, Si Carter wrote:

> 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.

Take a look at Database Comparer(if you are running on Windows).
http://www.clevercomponents.com/products/dbcomparer/index.asp



--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)