RE: Using Perl to repliace tables between databeses.

"Ed Avis" <[email protected]> Mon, 16 Jul 2007 16:57:10 +0100
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <[email protected]>
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 <[email protected]>

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