Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I was wondering if it is possible to sync a Pervasive SQL database to a PostgreSQL database.

If I set this up I would need the ability to sync both ways either on command or via a schedule.

Does anyone know if this is even remotely possible?

share|improve this question
    
Yes, it's possible. However, since you've provided no actual detail, it's impossible to answer in the current form. –  user1240 Apr 27 '12 at 21:25

1 Answer 1

Possible, yes.

We can't really give you guidance without more info, but you can generally build in logic regarding synchronization and use external apps to synchronize as you need to as a last resort. PostreSQL also has,a bunch of other tools you might be able to use on that side including untrusted stored procedure languages.

It might not be easy, and it may take a lot of work, but it is possible.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.