I need to send data from an MS SQL database to a Pervasive SQL database. Can this be done? It's for a 3rd year varsity project. The client we're developing the system for uses Pastel Partner 2009 accounting software, which makes use of a Pervasive SQL database, and the system we're developing must use MS SQL.

Unfortunately my knowledge is limited to theory with not much practical experience, so any input would be much appreciated.