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.
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
15 People are following this question.
