Abhijit Arun GujareSr. Oracle DBA at a comms service provider
Bryan WrenchSoftware Developer at a tech services company
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The core features of the solution we like are the reliability of the data transfer and the accuracy of data read and write. The stability of the solution is also excellent."
"There are some capabilities within SharePlex where you can see how the data is migrating and if it still maintains good data integrity. For example, if there are some tables that get out of sync, there are ways to find them and fix the problem on the spot. Since these are very common issues, we can easily fix these types of problems using utilities, like compare and repair. So, if you find something is out of sync, then you can just repair that table. It basically syncs that table from source to target to see if there are any differences. It will then replicate those differences to the target."
"Because of the volume of the transactions, we heavily use a feature that allows SharePlex to replicate thousands of transactions. It's called PEP, Post Enhancement Performance, and that has helped us scale tremendously."
"The most valuable feature is the navigation within the UI, where you can right-click on an object in an SQL query and go right to it, versus going through all of the menus to find what you are looking for."
"Toad has a lot of features that are very useful, fast, and well developed."
"I find Toad easy to use and I love the Workspace feature, which allows me to set up projects so that I can open SQL files applicable to what I am working on at any particular time."
"A quite simple feature that I have not encountered elsewhere is the "Make Code" feature. I can easily export a complex SQL statement to a programming language. This is a great timesaver as I do not have to type in all of the escape/concatenation characters just to create a SQL statement in C# or C++."
"The reporting features need improvement. It would be very good for users to have a clear understanding of the status of replication."
"I don't know how easy it would be to change the architecture in an already implemented replication. For example, if we have a certain way of architecting for a particular database migration and want to change that during a period of time, is that an easy or difficult change? There was a need for us to change the architecture in-between the migration, but we didn't do it. We thought, "This is possibly complicated. Let's not change it in the middle because we were approaching our cutover date." That was one thing that we should have checked with support about for training."
"I would like the solution to have some kind of machine learning and AI capabilities. Often, if we want to improve the performance of posting, we have to bump up a parameter. That means we need to stop the process, come up with a figure that we want to bump the parameter up to, and then start SharePlex. Machine learning and AI capabilities for these kinds of improvement would tremendously help boost productivity for us."
"The way the dialog boxes appear can be improved."
"I would like to see an improvement in the performance because opening the browser and the editor should be faster."
"There should also be a better "cancel query" option as sometimes one cancels a query, but then it still might run for a long time, and then one has to crash Toad in order to cancel the query."
"Once in a while, I may encounter a memory exception and have to abort the application. On a few occasions, the file that stores the saved connections for the New Connection window will become corrupt and I will lose all of my saved connections. I am not sure if that is a Windows or TOAD issue, but it has happened to all of my developers at some point or another."
"It is not as expensive as Oracle GoldenGate and has worked really well within our budgets."
"It's really good value for the money. There are some things they could improve on, but in terms of the pricing, features, and support, as a holistic package, we are not thinking of anything else at this point in time."
"The professional edition is about $1,000 AUD ($700 USD) and the developer version is about twice that much."
"In my opinion, this solution is a little expensive, but I understand that good programs cost more money."
"My advice is to try to use the three-year maintenance agreement if possible."
SharePlex database replication empowers your organization to achieve its database goals now and into the future. Make use of built-in monitoring, conflict resolution, data comparison and synchronization capabilities backed by award-winning support.
With Toad for Oracle, you'll reduce costs and risks by easily ensuring the health and performance of your Oracle Cloud Platform and on-premises databases. ... On the operations side, you can automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation.
Quest SharePlex is ranked 4th in Database Development and Management with 3 reviews while Toad for Oracle is ranked 12th in Database Development and Management with 4 reviews. Quest SharePlex is rated 9.4, while Toad for Oracle is rated 9.6. The top reviewer of Quest SharePlex writes "Real-time replication means our data is available almost instantaneously if an issue occurs in one of our data centers". On the other hand, the top reviewer of Toad for Oracle writes "Great PL/SQL debugger and "Make Code" feature with technical support that goes above and beyond". Quest SharePlex is most compared with Oracle GoldenGate, HVR Software, Qlik Replicate, AWS Database Migration Service and SSIS, whereas Toad for Oracle is most compared with Oracle Enterprise Manager and Aqua Data Studio. See our Quest SharePlex vs. Toad for Oracle report.
See our list of best Database Development and Management vendors.
We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.