PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

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 
______________________________________________________________________