Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Using Perl to repliace tables between databeses.
Date: Jul 16 2007 6:24PM

Lenga, Yair wrote:
> Hi,
> I'm working on a project where I have to create a "Warm backup" - system
> that has MOST of the data ready (1-2 hours delay data is OK). The
> important part is that it will ALWAYS be available. Rate of changes to
> the data is low (1% of data changes every day, 50MB data).
> Given that I do not have experience with replication, I ruled out trying
> to configure replication server for this project. 

I think you should reconsider this (assuming that you have a rep server 
license available). Setting up repserver (12.6 or later) using MSA 
replication (database replication definitions) is quite simple, works 
well, will handle most DDL changes, and will all in all be much simpler 
than writing custom scripts to copy the data across.

Michael Peppler           -                 Peppler Consulting SaRL      -        
Sybase DBA/Developer      -   TeamSybase:
Sybase on Linux FAQ       -