dbForge Edge

Vorteile

It's a one stop tool for my database tasks

Nachteile

Sometimes it crashes when I accidentally press F10

Vorteile

I love being able to completely copy a database from one server to another with a few clicks, which makes it super quick to keep my dev environment in sync with the live database. The code completion feature is so much quicker than SSMS, I love that you can set the delay, and it saves me a lot of typing in addition to keeping the case consistent within my SQL. The Visual Studio Blue makes it feel like I'm working with my old friend SSMS. The ability to mark different databases with shapes and colors is a thoughtful feature and reduces the chances of accidentally making a change in live instead of dev. The data generation feature is nice as well, as you can generate a lot of test data quickly. Also, one of the best features is the automated code formatting command (CTRL-K, D), which takes my sloppy, ill-formated SQL and turns it into beautifully formatted SQL. You can also easily output data to all kinds of formats including Excel, Sheets, csv, xml, etc., and save templates so that you can quickly generate the same reports.

Nachteile

The "Edit View" feature is a little clunky--you cannot edit SQL directly in the SQL tab, and when you try to do it in the Query Text tab, it constantly throws errors as you type. Sometimes you just need to do a quick edit to a view and it's a bit frustrating to deal with. I found myself opening up a new SQL window, copying my code, pasting into the new tab, modifying and copying back to the Query Text tab. There has to be an easier way.

Vorteile

it has syncing and backup built in and it looked to be a better product.

Nachteile

it only ran on windows, alot of our devs use macOS.

Vorteile

The platform works great, replacing the admin interface provided by MySql. DbForge provides the tools and familiar interface features need to perform all the admin and development we need.

Nachteile

There is some instability in the product, experienced infrequently, which causes it to hang for 20 seconds or so occasionally. Typically it recovers fine. When the platform does crash, it generally starts right back up where I left off without any loss.

In Betracht gezogene Alternativen

Warum dbForge Edge gewählt wurde

Gründe für den Wechsel zu dbForge Edge

Vorteile

Intellisense is fantastic. You considerably reduce the amount of words typed

Nachteile

For large and complex queries, hardware consumption is something that needs to be improved.

Vorteile

Easy to use.
Stable
Feature full
Showing the foreign key table when clicking the foreign key is awesome.

Nachteile

The database diagram tool could be improved. More like the “cat” competitor would be great.
This one is for the postgresql one only, but in its current state it is not for daily use because it is only 50% complete. I really hope that changes soon.

Vorteile

The DATA and SCHEMA Compare-Synchronization feature is an absolute game-changer. The T-SQL Debugger really saves us a great deal of development time in building our server-side data processing logic.

Nachteile

Nothing I should say as the least, other than releasing a MAC version.

Vorteile

schema compare
data compare
refactoring/intellisense
database diagramming

Nachteile

occasional instability, crashes (but no worse than any other comparable tool SSMS etc)

Vorteile

It is easy to get started with minimal database skills.
Provides a point-and-click interface and you get to see the actual SQL being generated.
Excellent for running queries on tables with lots of records.

Nachteile

I am only an occasional user and it is a bit expensive.
I used to like the version that integrated with Visual Studio but that seems to be no longer available.

Vorteile

User friendly, fast. Has features not available, at least not available at your fingertips, in other tools. The compare schema feature is invaluable.

Nachteile

Maybe do not like that is another product, I would love SSMS to do all these and to do them as good. But good that someone did a product that does all these.

Vorteile

The database schema comparison and synchronization tool was the big draw for us. We needed an efficient way to migrate schema changes from DEV to QA to PROD environments. dbForge met this need and made doing so a breeze. It even generates the SQL code necessary to accomplish the sync and lets you preview/edit the code if you disagree with the way that it intends to sync.

Nachteile

If there were one thing that I find a tiny bit lacking in dbForge, it is the way in which you define data sources. You have to redefine the server name, username, password for each database even if those databases exist on the same SQL server. This differs from SSMS where you connect to a single server and it attempts to use the same credentials to access every database on that server. It would be nice if the system had a copy/clone data source button to make adding new data sources from the same server a little more efficient.

Vorteile

dbForge Studio is essential for my team as it saves time and money for all of our developers no matter how much experience they have with SQL, Database maintenance and development (DDL), function & view creation/modification, etc.

For my novice developers, dbForge has great tools to allow the developers to visually create a query using an intuitive UI. Once they create the query, they can examine the SQL dbForge creates to better understand how to write SQL using industry Best Practices.

For experts, dbForge saves time (and typos) by giving us the ability to type a few characters instead of fully typing out the entire fiend name (for example typing 'usqd' instead of UserSurveyQueryData). It also has great tools for exporting so I can write and reuse an export query to dump data to pretty much any format (usually Excel 2007+) with consistent formatting. I also perform complex options like comparing the development and test databases to see not only structural differences (DDL) but even data differences upon demand.

Once I've gone through and set the rules for SQL formatting, I can share them with the team and all of our SQL is consistently named and formatted.

Nachteile

We are restricted to installing on one machine. All of my developers use more than one computer. I myself have three. It's just the nature of the business and it's a real hassle not to be able to install on as many machines as I, as a single developer, use daily.

Vorteile

This tool became a part of daily used product for members of our company. Few team members really complemented me for showing them such a powerful and amazing tool.
The easy of usage of this tool is making our team save anywhere between 2 to 3 Hours every day.
Some of our Developers now can't live without this tool.
The Express Edition is very helpful for small companies QA Team. As they just need to see the data and don't really need to write any complex Queries.

Nachteile

When we have one product such as SQL Server and we want to buy MySQL Database tool. It would be nice if we can get some discount.
If we need to buy all the Four Database tool, we need to buy them separately. If they can be bundled, that would be great.

Vorteile

Have been using different DB managers over years and tried all existing major ones for Windows, and stuck with dbForge. It's versatile enough and most importantly, has great UI and works with minimal errors, unlike some other products.
It has also great tools for data export/import.

Nachteile

Glitches can be still found here and there, especially in error handling.
Some more tools for copying, restoring databases would be good to see in the Standard version.

Vorteile

User Interface:
- Similar to Visual Studio 2017+ with multiple themes
- Nice uncluttered interface even the start page

Database Creation:
- Similar to SQL Management Studio by Microsoft but the user interface is organized more neatly. Related functions such as Indexes, Constraints, Statistics, Triggers, Data, and Columns can be accessed directly from tabs in the design view.

Best Features:
- Excellent Data Generation Tool! Generates tons of samples of data in a matter of seconds. Automatically links foreign keys to their corresponding primary table.
- Backup and Restore database capabilities accessible through an easy to use process wizard.
- Report Wizard: Create reports with a few mouse clicks through a process wizard. Can also design reports with its built-in report designer.
- Schema Compare. Amazing tool! Compares schema of databases and allows you to create, drop, update fields that are different from two databases.

Nachteile

Limited functionality to access/update database properties compared to SQL Management Studio. This is not a deal breaker since setting/viewing specific database properties is uncommon during database design.

Vorteile

Ease of use in making various DB changes, creating new objects, and developing/testing stored procedures, including a powerful DB object search facility.

Nachteile

Editing and rebuilding tables with foreign key constraints had some limitations, but that has been fixed in recent versions.

Vorteile

dbForge brings all the tools needed to administer and develop for not only Microsoft SQL Server, but many other dbs. It's nice having them all in one consistent interface and the software is very easy to use.

Nachteile

My only gripe about dbForge is that it's only available for Microsoft Windows.

Vorteile

dbForge Studio is like SSMS on steroids! Tons of features, and I especially like the tabbed interface that allows me to see multiple views very easily. The Table Build feature is much more intuitive than the SSMS interface, and the ability to easily add indexes and constraints is nice. The data export is more advanced than SSMS and allows me to tailor exactly the data I want to dump from my database.

Nachteile

Several features that I consider essential aren't included in the Standard version, with the most glaring being the inability to create scripts for multiple objects, as you can with the Tasks - Generate Scripts feature of SSMS, and the lack of a Profiler. You can get these if you pay for the Professional version, but as those were really the ONLY thing in the Pro version I needed, I chose instead to just use the Standard and use SSMS when I needed to create scripts or use the profiler

Vorteile

This DB Forge for SQL Server has many of the features of the Red Gate suite for SQL server but at a drastically lower price. This makes it a fantastic alternative for smaller companies and individuals.

Nachteile

During my first week of using it, we found a fairly critical bug that made integration/use with SSIS impossible. That was frustrating, but their support logged the bug and it is expected to be fast-tracked to getting fixed.

Vorteile

Easy to setup and use. The ability to easily export and import to and from different data sources is vital.

Nachteile

Would like a better performance tuner, perhaps index and temporary table suggestions. Lack of monitoring or performance analytics.

Vorteile

I particularly like the data view and in table editing. Also the line by line stored proc debugger, and havent seen any other like this and has saved me many days finding problems in procedures / related data.

Nachteile

Can be a bit slow to start up. Some of my collegues hav found it a bit slow generally

Vorteile

- Good user interface
- Complete set of features

Nachteile

- Really not any cons using this software

Vorteile

there is a debugger for mysql functions

Nachteile

generate a backup-batch with all the needed informations to schedule a backup. (credentials, ports, etc).

Vorteile

Advanced features for the price. The ability to easily deploy schema, data and comparisons feature alone is worth the money. You would pay 5x or more to get that same feature from RedGate (I don't believe RedGate even has a MYSQL product). Also full featured environment very easily with back up restore, diagrams and more. Blows away MYSQL Workbench.

Nachteile

The font is very small and in some places almost unreadable.
Doesn't behave on high res monitors.
I do get some crashes and have to restart the application about 1x week or so.

Vorteile

dbForge Studio is full of features to help us to manage our databases, to analyze data and create report.

Nachteile

They must implement a "server node" into the connections tree

Vorteile

This product is easy to use to connect to Oracle dbs which we have running. The trial versions are complete enough to be able to complete coding tasks and monitoring. The intelliisense built in makes working with oracle a bit more easy with less resource intensive operations. You can also use the built in 'unit testing' modules to create and run tests efficiently. All settings and previous worked on files are automatically saved.

Nachteile

Not many cons a bout using the software. Integration with current software suite is fast. Hoping to get the full suite of dbForge through company.

Vorteile

Very fast data adjustment and very good administration tools

Nachteile

Unfortunately no direct function for renaming tables (or I haven't discovered the function yet)

Vorteile

Simplify my developpment, almost as easy as Microsoft Access.

Nachteile

Not totaly compatible with a HD screen. (but the support told me it's coming in the next version).

Vorteile

This software give you total control over the MySql and MariaDB environment.
It is extremely easy to create a database, export and import data.

Nachteile

It would be nice if the software supported more database platforms. Now you have to buy dbForge for every platform.

Vorteile

The ability to compare schemas is a lifesaver for migrating from dev to test to prod. Data comparisons work great. DB Diagrams are key since SSMS seems to have broken that functionality.

Nachteile

Once is a while there is an error...but it is handled without impact and reported.

Vorteile

Very easy to use, has all the features I needed.
Data and schema comparison and data synchronisation are perfect and no other software can compete with it

Nachteile

It does not work on Linux based systems like Ubuntu.

Vorteile

Completely up to date, fast and good support, easy to use

Nachteile

Referring to all products, Really nothing. The only negative thing is the customer portal. It could be a little bit user friendly.

Vorteile

It is very easy to use and the search feature is one of the best I have used.

Nachteile

Makes SSMS unstable and locks it up frequently, forcing me to force quit through the task manager. I can open only one search tab in SSMS. I have installed this on the two new replacement computers since I purchased dbForge and experienced the same problem.

Vorteile

This software has a whole bunch of features, but what I first started using it for and find most useful is it's schema comparison functionality.

Nachteile

The software is semi-modular, in that there is the overall studio package and you can also buy discrete parts of it as standalone products (e.g. Schema Comparison). My only real gripe is that interface for Schema Comparison feels more intuitive and accessible r in the standalone version than when integrated into main studio.

Vorteile

The application offers many tools in one.

Nachteile

The application is not developing, I bought a license for 3 years and I am disappointed.
I use various programs, pay for subscriptions, and during this time I receive many updates and new features, e.g. devexpress.

Vorteile

The overall functionality and ease of use

Nachteile

just some missing features that are available from other software

Vorteile

This application just works. We purchased it a couple years ago and we have no problems with it. It just works.

Nachteile

We wish it could be a little cheaper, but other than that, we are very happy with the product.

Vorteile

Las facilidades que brinda para crear consultas y conexiones, exportar resultados, crear consultas desde un resultado exportando a SQL.

Nachteile

Hasta la versión actual, no he tenido ninguna queja del producto

Vorteile

Easy to connect to online data sources including MySQL on the AWS cloud. Visual query builder is the main feature that I was looking for and is using the most. I would have preferred something like what is available in SQL Server Management Studio, but the DbForge tool which provides a wizard-like interface for building queries also is good enough to do get the job done.

Nachteile

I could not find the option to visually edit queries in the standard edition that I purchased. This feature was available in the Enterprise edition that I had tried.

Vorteile

Many features in one GUI interface. I use 3 different products before to do the same.

Nachteile

Do not support other data sources in the same interface.

Vorteile

Exporting/Importing data with absolutely no effort, the code completition feat is also a time saver and an excellent thing, source control a feat we also use a lot when developing scripts, and the schema comparer have come on handy several times, all the other feats we have been used less but it take trust that we have them in case we need them

Nachteile

If I have to forcibly say something, Id' say is kind of expensive though

Vorteile

speed up almost any database experience, like designing, writing code, comparing databases, synchronizing schemas and data, generating test data.

Nachteile

the vendor offers separate toolkits for different databases, so you will have to choose the one you need. Initially, I tried the free Express version, and it wasn’t nearly as full-featured as a Professional one.

Vorteile

Data Comparison
SQL Editor
Stored Procedure Editor

Nachteile

That it often forgets my registration and license key and I have to set the license key again in order to work with as it stops working because it "thinks" I am using a trial version which expired. This is really annoying

Vorteile

Easy insight into indexhealth and database KPI's
Easy tooling for query creation, both in text and graphical

Nachteile

It would be nice to access the sql maintenance plans that are created on the sql server for quick edit or for a quick start of a certain job (out of schedule)

Vorteile

Data generation one of the most killer feature

Nachteile

Some bugs happened during using some features.

Vorteile

Ability to edit the data so easily - especially fields with XML data. My main motivation for the purchase was for the ER diagramming tool, which is mostly very good but I realise now that what I should have bought was the ORM tool to do what I wanted.

Nachteile

I still need to use SSMS for exporting and importing databases (bacpac) - this is something I do a lot

Vorteile

Easy configuration and storing the sync files

Nachteile

Difficult to find the errors. Anoying potential threat messages. Single user license.
Does it provides automatic updates ?

Vorteile

The sheer power it provides in a quality package. There appears to be some skilled coders behind the product and I suspect they enjoy their challenges.

Nachteile

Nothing comes to mind. If I don't use it often I find myself having to relearn some of the cooler functions.

Vorteile

Good resemblances with MS Sql management studio

Nachteile

Basically nothing, except that couldn't find all administrative options.