If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > Compare Pervasive and MSSQL

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-05-11, 12:16
rks32 rks32 is offline
Registered User
 
Join Date: Jan 2011
Posts: 2
Compare Pervasive and MSSQL

Is there any document available which compares Pervasive PSQLv11 and Microsoft MSSQL2005 or MSSQL 2008?

The links posted for older versions is no longer working.

Also what are the specifications for PSQLv11 for max database size, memory and numberof CPU's.

I found that Pervasive added support for multicore but does it support multiple processors??
Reply With Quote
  #2 (permalink)  
Old 01-05-11, 12:59
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
I don't know of any papers. What kind of comparisons are you looking for?
As far as specifications, PSQL v11 has a maximum file size of up to 256 GB. Each file can represent one table in the database with a maximum of up to 65,355 tables in a database. As far as Memory, the 32 bit version of PSQL is limited to 2GB of memory. PSQL 64 bit is limited by the memory available. PSQL doesn't distinguish between cores and CPUs. I know of customers using the 64 bit version of PSQL with 128 GB of RAM and 16 cores/CPUs.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #3 (permalink)  
Old 01-06-11, 16:47
rks32 rks32 is offline
Registered User
 
Join Date: Jan 2011
Posts: 2
Thanks Mirtheil. This helps.

We are considering purchasing an app which uses Pervasive and are trying to understand server requirements and also see if we can move the data to our existing SQL Servers.
Reply With Quote
  #4 (permalink)  
Old 01-06-11, 18:41
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
Usually the app vendor will give server requirements for their applications.
Moving the data may be more of an issue. PSQL and MSSQL store data very differently so the data isn't directly compatible. You might be able to use SSIS or the Pervasive Data Integrator tool to copy data from one database to another. If you want to run PSQL and MSSQL on the same server, it is possible but usually resource limitations (RAM, CPU, Disk, etc) cause performance issues. There is nothing specific that prevents both from running. I actually have PSQL, MSSQL, MySQL, and at one time PostgreSQL all installed on my test server. I never did significant performance testing on that server but never had any problems either.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On