Replicating Pervasive DB To Sql Server

[JohnEfford]

An any body suggest the best way of replicating a pervasive (version 8) DB to MS SQL Server.

The Method I am toying with is to create trigers on each of the tables that records the table updates to another table, then periodically (every ten seconds) have a program scan through this table (or tables) and replicated the changes to SQL Server.

One of the tables changes quite frequantly and I need these changes to be replicated with a reasonably short time lag. The system writing to the database is using the transactional API (not under my control). Because the databases need to be resonably in sync I can not simply exoort the whole of the pervasive tables or use the DTO to import the table into SQL server.

Any suggestions appreciated.

 

[TomKane]

I have heard of a Btrieve "Trapper" - there was an organisation that used this Btrieve trapper to update a sybase database at the same time as their pervasive database was being updated by their application - I don't have any detail beyond that, except that the appication didn't update both db's itself - this trapper somehow knew to "piggy back" the pervasive updates that were being sent from the client.