I know this is not necessarily the correct place to ask this question, but I know its the best place. I inherited an old Pervasive SQL v9.3 database as part of the data infrastructure, however this server/platform/database are the proverbial "red-headed-stepchild" in our SQL Server environment. We are working to replace the application so that we can migrate the data to SQL Server, but in the meantime we still must do due diligence and keep up the maintenance (which hasn't been done in quite a while. The only version of the Pervasive Back-up Agent I can find only works with v10 or higher. Does anyone know where I can get a process to back-up the Pervasive databases and also do integrity checks (at the very least) Don't throw too many thinks at me, but I could use your assistance if that is possible
I believe your best bet would be to try SSIS via the Pervasive OLE DB provider. I did some research on their website, and it looks like the provider comes with the software. I believe you can also download a trial copy to get the provider. Please let me know if that works for you. Good luck.