Navicat vs. Oracle Autonomous Database

I was tasked with migrating data from our local PostgreSQL DB to an Amazon RDS instance. I expected this to be a difficult job, but Navicat's migration wizard made it fairly straightforward. I think that it's more geared towards professional users, although not necessarily database practitioners. Non pros might do better with the new Navicat Lite edition.

Scenarios where this is best suited are like where there are not large set of data which has to be analyzed and extracted.It helps in the efficiency of data .It is also well suited for medium size companies where you have to create a common data for everyone. As for large set of data, there can be network latency issues and thus there are some limitations of this software.

Incentivized

• Easy to understand
• Simple UI/UX
• Easy to connect data

• 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

• Filter table
• Save to external file

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

Autonomous is the way of the future and this is one system which is crucial to any system and is also autonomous. It is self-tuning and self-maintaining which are major advantages.

Incentivized

There is quite a lot to learn because Navicat Premium is a very comprehensive database management and development tool, but it's User Interface is intuitive enough to pick up fairly quickly. I have also referred to the documentation on occasion, and can attest that it is quite good. I feel that it works best on a large monitor, but that's fairly common for this sort of software.

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

Very robust online community and well as excellent support staff. Easy to follow video tutorials. Detailed sample configurations are provided with guided walk-throughs via remote classroom instruction. Very fast response from support staff. No internal hires were necessary for support as vendor support staff fully met all technical expertise. 24/7 incident reporting and tracking is great.

Incentivized

While Sequel Pro is a great shareware tool, it's limited to MySQL databases; while our department does use MySQL databases, we also use Oracle databases, so Navicat Premium's multi-product support is an absolute requirement. Navicat Premium also provides data browser support, including filtering, to empower less technically-minded users to query and manipulate databases, an option not available in Sequel Pro. And the job scheduling and batching features of Navicat Premium further distinguish it above the admirable, if limited, Sequel Pro.

Incentivized

Hands down it's the best. It's secure and extremely fast. It also doesn't need a lot of babysitting. It's running itself. It does its job as advertised. This is why I feel everyone should if they haven't already taken a hard look OAD. I feel it's the future of technology at its best. Everyone should be taking notice of how far technology has come and where it's going.

Incentivized

• Similar features to OEM provided very easy to use, out-of-the-box functionality.
• No large infrastructure changes were needed to deploy and install.

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