dbForge Studio (Edge) vs. ApexSQL by Quest

This tool is useful for small and large IT departments and associated data analysts that perform direct database functions such as DBA tasks or extracting/importing data. Non-technical staff members would not benefit from this tool as much as the functions are detailed and technical. However, automation engineers will find this tool very open for automation, and can generate the scripting code for any of its functions.

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

• Connection manager (we use it through ssh tunnels) works effortlessly.
• Great sync tools for both database schemas and data.
• Storing code snippets to be used when needed.
• Nice code suggestions while typing queries.
• Usually does very well with storing your session and opening all of your sql tabs when opening the apps next time.
• Does very well when executing large sql files (without opening the files into the application that is).
• Pretty good debugging help when a problem occurs in executing a query or a files with multiple queries.

Incentivized

• Templates
• Code editing
• Code Review

Incentivized

• The ability to parameterize searches more would be advantageous. For example, being able to specify to only look for certain columns, certain data type changes, etc.
• The output reports from dbForge are very plain and could contain more detail, and perhaps be structured more like a pivot table form Excel

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

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

Before choosing dbForge Studio I evaluated at least a dozen tools, especially on the Visual Query Builder function. For now, I have identified only one product that has a better Visual Query Builder than dbForge Studio. This other product also manages UNIONs, while dbStudio still doesn't do it visually. However, the better alternative product is enormously slower in operations and less feature-rich than DbForge Studio

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

• Saved a TON of time when looking at massive amounts of parent/child data by allowing us to just use the master-detail browser.
• Very little training time needed for employees that are already used to using SQL Management Studio. This is a proper Windows UI application.
• Very cost effective to purchase the standard edition for every employee that needs it, but the free edition does most of what they need too!

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