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 SharePlex really shines when set alongside GoldenGate. The licensing costs of the two products would appear to place them in entirely different ballparks yet they perform nearly identically in practice. SharePlex is suitable for heterogenous replication of one database to another. The list of targets is ever increasing, with support for all major RDBMS vendors as well as support for popular NoSQL and JSON replication. SharePlex is effective when replicating from on-premise to cloud. Whether that's migrating data, creating a high-availability presence in a public or private cloud, or populating a data mart, it does the job quite well.
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 SharePlex is highly configurable and versatile. It can handle virtually any kind of data replication needs. SharePlex is very robust. Its message queuing mechanism provides fast data transfer from the source to the target. SharePlex software is very stable and mature, and it is highly scalable and reliable. SharePlex support is exceptionally good. We are very satisfied with its support engineers. 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 When first introduced the Change Data Capture process was awkward. Each subsequent release has improved the process. Sometimes the Shareplex monitoring service in Foglight gets overly aggressive in sending out error notifications and can end up spamming the admins with email alerts for one problem. We have had to tone that down. Read full review Likelihood to Renew We depend on it to supply data to our various OLTP and Data Warehouse environments
Read full review Usability It is very usable once you get over the initial setup.
Read full review Support Rating Support is very responsive. They take ownership of the problems and see them through to the finish. When a bug is found they work towards developing testing and making the fix available to us to solve the problem.
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 SharePlex support is an award-winning team, which is available for 24 hours, and any time they have solutions with perfect expertise. Besides, SharePlex has supported data migration, with multiple reporting features that ensure there are comprehensive database evaluations. The simplicity of SharePlex installation also gives it a higher mark, is very efficient, and allows companies to understand it easily.
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 Postive: easy to replicate data for non-prod use Negative: we spent a lot time due to data out of sync Read full review ScreenShots dbForge SQL Tools Screenshots