Azure SQL Managed Instance vs. Oracle Autonomous Database

Data management scenarios where there is a strong need to provide dynamic context for web based applications. Also can work as an infrastructure piece for ticketing systems without relying on another set of database software. The ease of importing data from Microsoft Excel &/or .csv files makes this really easy to use when importing data into the managed instance.

Incentivized

Pro - Stability. Does everything anyone could need. If it's not there it will be on the next update. There is plenty of support for it. It's been around for a long time and it's reliable. The support is well documented and has a great reputation. Cons - Errors have been found in the documentation provided by Oracle with guidelines, etc. Oracles salespeople have a reputation of being obnoxious and condescending.

Incentivized

• executes the queries efficiently
• has tools/dashboards to show where the query problems lie
• alerting for problems

Incentivized

• Robust - this product doesn't have a lot of downtime. It's less prone to errors than some other tools I've worked with.
• Scalable - we can keep adding more things to it. We haven't hit any roadblocks when we've tried to do more with our database.

Incentivized

• hard to use without Microsoft knowledge
• Intimidating CLI
• Commands are not intuitive

Incentivized

• There is no access to the physical host of the DB. This is expected from a managed DB. Everything must be done through the console or via API calls. This is a new learning curve for the DBAs.
• Due to the lack of physical host access, certain features are not supported, such as Transportable tablespaces and Oracle LogMiner.
• Certain special data types, (such as XMLType) are not allowed; be sure the app vendor certifies their product on this platform.

Incentivized

Because it does exactly what we need: it enables us to manage our development and testing database environments in a quick and simple way without requiring support from a database administrators team.

Incentivized

it runs the workload very well without causing any issues to the business. there are many applications running on Azure SQL Managed Instances in my organization. Most users are happy with its performance. Is able to provide good dashboard for the visibility of the workload. Can add cpu without a downtime to deal with high workload.

Incentivized

The product is continuously evolving and new features are added frequently. Management options through the OCI (Oracle Cloud Infrastructure) console and through the command line and API are being enhanced frequently.

Incentivized

Azure to our enviironment where we have everything integrated stacks up far better than MySQL where we would have to reinvent and use everything to fit a MySQL environment including the data and the commands within that data. Furthermore, doesn't work really well on SQL Management Studio which makes it completely useless for what we are trying to do.

Incentivized

I found Oracle Autonomous Database very secure to store data and private information.I always feel secure with Oracle Autonomous Databases disaster recovery features.It is very effective to build applications for mobile and desktop devices lesser code using a low code development framework namely Oracle Application Express (ApEx).

Incentivized

• it had a positive impact to my business and allowed me to be able to move my workload from on-premise to cloud.

Incentivized

• Oracle Autonomous Database has a wide range of warehouses, which is competent and of high performance.
• The transactional processing power that Oracle Autonomous Database outlines are completely important and digital.
• The efficiency of Oracle Autonomous Database data encryption fosters security measures, a form that demands more threat detectors.

Incentivized