Overall Satisfaction with Oracle Database 12c
Currently DMC is using Oracle for storing and maintaining transaction information. There are 2 departments that have access to the data in that particular database, where one part of the business does more data extraction than maintenance. Oracle DB is the current enterprise solution for DMC's booth sales and reservation records.
- The simplicity of the application.
- It seamlessly allow for large data storage.
- The pricing in some cases are better than most data storage products.
- Using the back button. Oracle responds properly to the back button in the application than the browser. Its for good reason but, annoying.
- Upgrading isn't user friendly unless you a Oracle prodigy. I'd ask them for a guide that allows unfamiliar users to upgrade with confidence
- In terms of cost, Oracle is a strong data storage tool that doesn't blow your departmental budget.
- SQL Server
Oracle has more flexibility than SQL Server in terms of data migration and data security. Oracle (for me) is also easier to use in terms of ad hoc table creation and views. With SQL Server the amount of restriction in place make it hard for me to do the kind of data migration and table creation I need to get my job done efficiently.