Pervasive.SQL Hosting : Real-Time Replication Pervasive To SQL 2005

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by msd 0n 16 October 2006

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.

Learn more about Pervasive.SQL databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting