Hi All,

I am trying to evaluate my options on writing a custom replication program that will do real-time replication of data from Pervasive v2000i (but will soon be upgraded to v9.x) to SQL Server 2005.

Basically, I want to be able to cover all the updates (INSERT, UPDATE, DELETE) events that occur on the front-end application and the ones done through the 'back door' (e.g. Pervasive Control Center).

I was told to unable and read BLOG.

- Is this a viable and the best option?
- If so, is there an available API manual to easilly use this using for example C++ or C#?

I am still on the early days of the project but your input/guidance will be greatly welcomed and appreciated.

Many thanks in advance.

_msd_