Refreshingly easy to use tool!
Updated January 30, 2019
Refreshingly easy to use tool!
Score 8 out of 10
Vetted Review
Verified User
Software Version
dbForge Studio for PostgreSQL
Overall Satisfaction with dbForge Studio for MySQL
We've been migrating our applications over to PostgreSQL from Microsoft's SQL Server. We've been on a mission to find a good replacement for SQL Management Studio that everyone uses, not only for development, but also just generalized querying/editing of data. We've tried quite a few tools and when it comes to data querying and editing, we landed on dbForge Studio for PostgreSQL. We started out using just the free version, which at this point in time only has a few drawbacks compared to the paid version. Eventually, Devart plans to have more available in the paid version, but what they have now was enough for us to make the decision to purchase it.
They do not currently have the ability to graphically design or edit table/database schemas, which makes this tool a no-go for most development tasks (unless you are just writing functions/stored procs, and then the intellisense is very handy). However, the grouping and sorting of data right through the data grids is extremely useful. Grouping is also a snap by a simple right-click on any column. You can even edit data from a query instead of having to edit all the data in the table!
They do not currently have the ability to graphically design or edit table/database schemas, which makes this tool a no-go for most development tasks (unless you are just writing functions/stored procs, and then the intellisense is very handy). However, the grouping and sorting of data right through the data grids is extremely useful. Grouping is also a snap by a simple right-click on any column. You can even edit data from a query instead of having to edit all the data in the table!
- Intellisense is rock solid.
- Sorting, filtering, and grouping are super easy by just using the grid columns. No having to write queries!
- UI is super intuitive.
- There is a master-child detail designer where you drop tables into the designer, link up their relationships (whether there are foreign keys or not), and then you can view the linked data.
- No table/database designers (yet). They have said it's coming.
- No way to create scripts to create the database/tables that other tools have. This makes it difficult for developers to use to generate DDL scripts.
- Data export does an individual insert per row of data, which is a little inefficient. Other tools will do a single insert for a configurable amount of rows per insert statement.
- 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!
While DBeaver ended up being the goto for our development team, everyone else is going to be using dbForge Studio. The UI was hands down much easier to get used to, and the sorting/filtering options make it super easy for anyone to view the data the way they needed it. You don't need SQL query knowledge to use this product. DBeaver DOES have a master detail type data view buried into some right click menus, however, you can't just link up a bunch of tables and see/scroll through master records and have all the child tables update. It's useful, but not as useful as dbForge Studio.
Valentina was just way too hard for people to navigate and use on a daily basis.
Valentina was just way too hard for people to navigate and use on a daily basis.