Oracle - Paradox Comparison/Questions

Greetings,
I work for a company and up to now we have done lots of in house development of our main sales application. We have now decided to start look elsewhere for a product off the shelf that we can customise.

Our current system is written in VB and we write lots of reports using Crystal reports and some Excel. The current application is a true Client/Server application and we use Microsoft SQL server as our DBMS.

We have found 2 systems, one runs using ODBC connection to Paradox files and is written in Delphi. The other is written in Java and uses Oracle as a DBMS. I have come concerns about using Paradox in a user base of that size (and it is growing), but before I go to the business I want to get some feedback as to what peoples real world experiences are with a File server database product such as Paradox when compared to a Sybase/Oracle solution. There are obviously some business considerations that need to be taken into account when deciding what product to use, but I want to cover the technical aspects. These include;

• Ease of support (DBA - are there any quirky things with paradox a standard DBA couldn't handle)
• Ease of development - Reports
• Ease of development - Other apps that might use/augment the new systems data
• Robustness of the data in that database (backups, transaction logs etc).
• expandability etc
• Features - Does paradox have triggers, stored procedures, views etc ??

Our current network is a MS Windows 2000 network, TCP/IP based with Windows 95,98,2000 and XP clients. Full 100Mbit backbone with 10MBit to desktops.

If anybody has some real experience using paradox or has some details or information to its suitability I would appreciate you emailing it to me bens_at_harrythehirer.com.au.

Thanks
Ben. Received on Sun Feb 24 2002 - 01:28:16 CST