question

Bugmesh avatar image
Bugmesh asked

Pervasive SQL maintenance question

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
backupcheckintegrity
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Tom Staab avatar image
Tom Staab answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.