question

Bugmesh avatar image
Bugmesh asked

Pervasive SQL v11 to SQL Server 2008 R2

I have three questions regarding integrating Pervasive SQL v11 into SQL Server 2008R2. 1) I am trying to locate a driver (32bit) for SQL Server 2008R2, so I can do a linked server to a Pervasive SQL database. Has anyone had any luck with locating one? 2) Has anyone had the opportunity to SUCCESSFULLY create an SSIS package to transfer data from Pervasive SQL to SQL Server 2008R2? 3) We have a new version of an accounting application that uses Pervasive SQL as the backend. The clients are running on 64 bit Windows 7 and the Backend is sitting on a Windows Server 2008R2 64bit Standard, but the Pervasive SQL DB is 32 bit and the File Server used to serve spreadsheet data is a 32 bit Windows Server 2003 Standard edition. The application is now experiencing slowness in report generation. Could the differences between the bit versions be part of that issue? I appreciate any assistance you could provide.
linked-serverwindows-server-2008-r2sql 2008r2
10 |1200

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

1 Answer

·
Fatherjack avatar image
Fatherjack answered
1) If you want to create a Linked Server object in your SQL Server that is a connection to your Pervasive server then you wont need a 32bit SQL Server driver, you need the 32bit Pervasive SQL driver. I would simply try it as an ODBC connection though. We upgraded* from Pervasive SQL to SQL Server many years ago for our CRM system and the data connectivity wasnt particularly obscure. ![alt text][1] *Seriously, it was a massive improvement. The SQL Server databsae performed better than the Pervasive SQL database even before we created **any** indexes in the SQL Server version. Things may have changed since then in the later version of Pervasive SQL of course. 2) Again, I'd try connecting to the Pervasive SQL simply as an ODBC source, it should be fine. 3) Its is 'now' having performance problems - It has been fast historically? Has the load on the server changed? More users? This could be tricky to diagnose, what do your Pervasive SQL support people say? [1]: /storage/temp/1567-odbclinkedserver.png

1 comment
10 |1200

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

Thank You sir, we will give it a go!
0 Likes 0 ·

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.