It’s coming…
48 hours from now something big is coming!
Category: RepAgents
MyDatabases Volume 1 Issue 1 (July 2008)
Geek Spotlight: Michael Peppler
Sybase ASE on Ubuntu 8.04
Multicore Processors
VMware Virtualization
Logical Process Manager
Remember my Sybase Replication Server: custom built RepAgents with Perl! post back last year? Well, not only am I the new maintainer, but I finally have it working in a test environment. It isn’t ready for a new release for Sybase::TdsServer and Sybase::RepAgent, yet, but expect one soon.
My main development environment for these two modules is:
- Windows XP SP2
- ActiveState Perl 5.8.8
- Sybase Workspace 1.7 (Eclipse based)
- EPIC Perl plugin
- Subclipse (subversion client)
I’m hoping to get out my first CPAN release to the perl testers within the next month or so. Why the delay? My wife and I are expecting family and friends to stay with us for the next few weeks. That’s a very good thing 
This is just one way to resync the replicated database in Sybase
View full article »
Data is entered into the primary database and the replication server were send it to all of the replicate databases. The process that gathers the data (encapsulated in transactions) and sends it to the Replication Server is called a RepAgent (Replication Agent).
Bernd Dulfer a few years ago wrote the perl module Sybase::RepAgent in order to replicate data from arbitrary DBMS’s. For example, if your legacy application is built on dBase III+, you could with little effort make a RepAgent to send any changes to the dBase files to Replication Server and then off to some other DBMS that you will eventually migrate to.
In the Sybase::RepAgent Cookbook, Bernd Dulfer describes the setup of a simple RepAgent in order to replicate from a Postgres database to a Sybase ASE database.
Even though Sybase::RepAgent uses Sybase’s Openclient, the parser and SQL converter is written in Perl, we can not expect it to keep up with a high load of transactions. Rewriting the parser and converter in C or some other compiled language may provide a sufficient boost in performance allowing it to be used in high load situations.
I have not been able to contact Bernd Dulfer so the Sybase::RepAgent module may indeed be abandoned. I’ve contacted the CPAN admins regarding this.
