I would like anyones opinion on this

We currently have Accpac ERP 5.4 Corporate running in a mixed 20+ user environment. Windows XP workstations running the program locally and Pervasive 9.5 on Netware 6 and Citrix Metaframe XP for 6 + users. We are moving forward onto 5.5 but have to move off of Novell to do this as it is no longer supported. Does anyone have any experiences with Nitex that they can tell me about? How does it compare to Microsoft Server 2003 performance. This will undoubtably be a stand alone Accounting system but if it is Microsoft it will also have AD. From the reading I've done and the conversations I've had with Jay, it seems Pervasive 9.6 is still faster than Microsft SQL or DB2. But I have also heard the sales pitch that security wise SQL is much better than Pervasive, but is that a major concern? Any and all thoughts will be appreciated as we want to move forward and improve performance ...not take a step backward or sidewase.

OK, first off, let me say I am an SQL fan. It is, IMHO, more robust and easier to handle that PSV. With well written statements and queries, SQL will beat the pants off PVS. Herein lies the problem though - Accpac is historically (and to some extent still is) transactionally oriented (as said in another thread here) mand that has to be fixed. BUT, that can't "just be fixed" as long as Accpac want's to support multiple databases. So, you end up writing common code to the weakest point of the supported databases which, as it turns out, is the stronger function of PVS and weaker area of SQL.

Another factor - I just have to giggle when I see endless debate on which PVS version to use (it's got to be the latest or "special" Accpac version) but when it comes to SQL then 2000 is commonly used and complained about. If you want to use SQL then use a 64 bit version and give it the RAM it wants - it will perform just fine, thank you.