sybperl-l Archive

From: "Ed Avis" <eda at waniasset dot com>
Subject: RE: Using Perl to repliace tables between databeses.
Date: Jul 16 2007 3:57PM

I'm not familiar with rs_subcmp, but have you investigated just bcping out all the data every hour and loading it into the standby database?  50 megabytes doesn't sound like much.  A more sophisticated approach is to set up replication server, which does exactly what you want.  Both these approaches have difficulties when the schema changes (unless newer replication server releases deal with this sensibly).

-- 
Ed Avis 

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________