Link to home
Start Free TrialLog in
Avatar of arkalex
arkalex

asked on

MS-SQL vs. Oracle

I need reasons to convert from Sequel Server to Oracle.  Current application is in Sequel Server and needs to support over 300 Web users?  Can Sequel Server be scaled to handle full web/browser support or should I convert to Oracle?  Application is written in SQL.  Mostly text based data.
Avatar of arkalex
arkalex

ASKER

Edited text of question
We have had pretty good luck porting our Oracle Form application to the WEB.  Pretty much as written, our Oracle Forms will work either in a client-server architecture or over the WEB.

Oracle Forms can be written to communicate with any database, but they are optimized to work with Oracle.

Oracle has lots of great features you get for free that other databases don't such as primary keys, foreign keys, triggers, stored procedures, sequences, tablespaces, redo logs, secure configurations, multi-database operations, parallel processing, etc.

Unfortunately we have been told that our application must be made to be database independent, or at least work on SQL*Server as well.  Thus, we will no longer be able to take advantage of all of the great Oracle-specific stuff unless we want to write two completely different API's to interact with the two different databases.
ASKER CERTIFIED SOLUTION
Avatar of altena
altena

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of arkalex

ASKER

Good answer.
Avatar of arkalex

ASKER

Good answer.