dbForge Studio (Edge) vs. Oracle Autonomous Database

Whenever a user or DBA wants to compare schematics between two environments, dbForge is extremely helpful. This is useful during version or framework upgrades, a database upgrade, patch implementations, service package implementations, or any time to environments would be different. The time it would take to write and execute queries, and then compare is exponentially longer than it takes with dbForge, where this is done and you have an application that allows you to quickly identify incongruities.

Incentivized

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

• Compare entire or subset of MySQL tables between databases
• Configure comparison rules
• Sync data between compared databases depending on differences
• Save comparison rules for reuse and sharing
• Break down differences between missing/new records, or different records
• See differences highlighted per field
• Execute sync immediately, or save as an SQL script file
• Command-line tool that can be used to add comparisons to deploy scripts

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

• [The] installation error I've already reported (ABARTN).xml [could use some improvement]. This has to do with Windows Defender (the default Windows anti-virus) not allowing the installation on the default installation directory of dbForge Studio [for SQL Server], thus the error. [With] the workaround, [I] was to disable the anti-virus for the duration of the installation, then turn it back on when the installation [was] been completed.
• [I would like to see] better defined licensing models for larger teams (seated vs. name licenses).

• 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

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

Although experience here is limited, as only one question has been asked and answered promptly, the registration and licensing process was very smooth and professional. There are forums online that discuss dbForge issues, as well as a Facts and Questions section on dbForge's website, so product support does seem to exist if needed.

Incentivized

I would say that dbForge equals or beats most of the abilities of the other tools I evaluated at the time. dbForge had better support (Devart), and regular feature updates. dbForge has better tools for data comparison and import/export. The price tag is slightly higher, but renewals rates are pretty good. It's a quality tool that still is well worth the cost.

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

• We perform better and faster syncing analysis between databases.
• We update running mysql databases faster and more efficiently.
• Especially with MySQL Workbench we had immense irritations due to all the crashes during the day. With dbForge Studio we finally had a power tool which is stable and does not crash constantly.

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