Likelihood to Recommend dbForge SQL Complete is well suited for professionals that have to write code all day. In my role in the business intelligence department we are writing SQL pretty much all day. Having a tool that helps us do that faster, in a cleaner way is pretty awesome and something that pays for itself quickly.
Read full review Database Migrations on Java-based solutions. It has one of the best integrations with it as a database migration tool, you can do it with the community edition (no pricing involved) and it works flawlessly with Maven and Gradle. It's not an expensive tool in order to use the next level of features and is worth the money. I would recommend reaching that edition level as the object mapping feature gets really handy. I would not recommend it for any Microsoft-based solution (.Net) as is not compatible at all based on my experience, this is a tool only worth it with Java applications.
Read full review Pros SQL complete allows you to create custom snippets that allow you to store frequently ran queries in shortcuts. The code can be populated within seconds! Another great benefit is custom aliases. If you frequently reference the same tables over and over again it gets tiresome to retype the aliases. Storing these can make your code more consistent and save time. SQL complete will also highlight the metadata within your database. For example, if you start typing an insert statement you populate code for all the field names by pressing the tab. This is a real-time saver for wide tables! Read full review Supports many databases Community version uses Apache license Widely used, good community support Read full review Cons Sometimes it can be slow to retrieve the database metadata. Updating the software with the activation/deactivation of licenses could be further streamlined. Read full review GUI could be more user friendly Applying patch scripts on a blank DB differs from on a DB with data, so the migration could still fail when all tests passed Configurations options could be more flexible / powerful Read full review Alternatives Considered I am very satisfied after using this tool. It is a full-stack tool that includes rich features that can be customized set of functionality as per your need. by using this tool:-
Increased our productivity rate. Provides speed up your development work so you can focus on other stuff. Read full review The problem with a cloud-based tool for migration services is the cloud dependency. You are restricted to use the tool along the Cloud provider. Flyway gives you the freedom to use it in any scenario as long as you are working with a compatible database engine. Even if you are working on-premise and you don't have plans to move to a cloud architecture. Or even for sandbox development scenarios where you are a developer playing around with some project ideas. And you don't have to pay anything as long as you need advanced features, and not less importantly, you are using an open-source tool.
Read full review Return on Investment Spending less time trying to figure out how tables are related thanks to the navigational help in dbForge SQL Complete, which means fixing issues takes less time. Read full review Reduced our effort for release processes. Easy to setup - less than 5 minutes. Improve reliability of our databases. Easy backup and version control. Read full review ScreenShots dbForge SQL Tools Screenshots