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 ______________________________________________________________________