Subject | Re: [firebird-tools] Copy Data |
---|---|
Author | Paul Beach |
Post date | 2011-02-04T13:33:39Z |
> Hi,IBReplicator?
> 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.
http://www.ibphoenix.com/products/software/ibreplicator
Paul