Pragmatic Workbench (discontinued) vs. ApexSQL by Quest vs. SAP Replication Server

Workbench Enterprise is consistent across devices and users so far. It works the same, and access is easy. I have a problem with its security. If you use an enterprise password to access databases, it's very easy to click the show password on the connection page and expose the enterprise password. You shouldn't allow users to use the same accounts to access the database because that means all users are sharing the same password.

Incentivized

ApexSQL streamslines and automate DBMS in no time, helps in implementing the auditing and compliance requirements and data migration and it also help in building scalable application and secure application like when we develop application using Apex SQL, it will become very secure automatically due to its build in features and also building small application and deployment of code is very easy When you have very large data size sometimes it run a bit slow.

Incentivized

I asked questions about a warm standby and multicast replication. We ended up using bi-directional replication and a warm standby db. Having 3 or more live OLTP DB's where each was read-write was going to be difficult to manage for contention if the same table was being updated. We stuck with an easier solution to have only two OLTP's, and then used additional DB's as read-only DW's.

Incentivized

• Querying is easy and quick.
• Updating tables is very easy.
• It gives us very accurate error messages.

Incentivized

• Templates
• Code editing
• Code Review

Incentivized

• guaranteed delivery
• high availability
• scalable
• low latency
• data transformation

Incentivized

• It has autocompleted, but I find it difficult to use or get to use.
• It doesn't automatically complete table names or field names.

Incentivized

• Source control can be a bit difficult with large database tables
• Many tools so can be complex for new developers to onboard and use efficiently

Incentivized

• Data Reconciliation Functionality.

Incentivized

Our team does the support for us. Sometimes we see download related issues that can easily be fixed by our team. Most issues you will see with one user in your org will probably happen to others, so keep a log and track those issues. Then have a fix for them somewhere that everyone has access to. This will save you a lot of time troubleshooting.

Incentivized

SAP support has been outstanding. They have quick response times and always meet their SLAs. Any time we have an issue that needs to be researched they are able to get back to us quickly with resolution.

Incentivized

ApexSQL by Quest provides many toolkits for sql server that stacks up against its alternatives such as Operation toolkit which includes capabilities like disaster recovery, backup and restore etc, DevOps toolkit which include automation, compare and sync toolkit which include comparison between source and target schemas. ApexSQL by Quest also ensures the privacy and security of data. For this mentioned reason, our organization select ApexSQL by Quest

Incentivized

Hands down Sybase has the best replication

Incentivized

• I personally like Workbench Enterprise, and I can do everything I need to do using it.

Incentivized

• Free to use so easily affordable
• Very easy to use of any new employee can easily learn
• It provides all encompassing tool for our developers and ApexSQL solves that

Incentivized

• A positive is that it allow quick business decision making on the basis of real time data. Huge time saving for business.

Incentivized