Introducing G2.ai, the future of software buying.Try now
dbForge Studio for SQL Server
Save to My Lists
Claimed
Claimed

Top Rated dbForge Studio for SQL Server Alternatives

dbForge Studio for SQL Server Reviews & Product Details - Page 5

dbForge Studio for SQL Server Overview

What is dbForge Studio for SQL Server?

dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting, analysis, and a lot more. dbForge Studio for SQL Server is a Windows application, but it can function in the Linux and macOS environments via CrossOver. SQL developers and DBAs performing complex database tasks can use the GUI tool to speed up almost any database experience, such as designing databases, writing SQL code, comparing databases, synchronizing schemas and data, generating meaningful test data, and much more. Features: - SQL Coding Assistance - Source Control - Index Manager - Unit Test - Table Designer - Database Designer - T-SQL Debugger - Query Profiler - Schema Compare - Data Compare - Data Generator - Documenter - Query Builder - Data Export and Data Import - Database Administration - Server Event Profiler - Data Editor - SQL Server Reporting - Master-Detail Browser - Pivot Table - Copy Database - Monitor - Find Invalid Objects - DevOps Automation There is no need to waste time to search for and purchase SSMS plugins across the Internet to get your work done – dbForge Studio for SQL Server has it all. Check out the great advantages of our GUI tool over SSMS!

dbForge Studio for SQL Server Details
Languages Supported
English
Show LessShow More
Product Description
dbForge Studio is a for SQL Server is an IDE for SQL Server management, administration, development, data reporting and analysis that help SQL developers to manage databases, version-control database changes in popular source control systems, speed up routine tasks, as well, as to make complex database changes.

Seller
Description

Since its founding in 1997, Devart has been working on simplifying and enhancing data workflows for both individual professionals and teams, including enterprise-level organizations from the Fortune 100 list. Currently, Devart is one of the leading developers of data integration, backup, management, and connectivity solutions, as well as database tools for major database management systems and cloud platforms.

Overview Provided by:
PR Manager at Devart

dbForge Studio for SQL Server Media

dbForge Studio for SQL Server Demo - Database Management
Database Management
dbForge Studio for SQL Server Demo - Data Reports and Analisys
Data Reports and Analysis
dbForge Studio for SQL Server Demo - SQL Coding Assistant
SQL Coding Assistant
dbForge Studio for SQL Server Demo - Source Control
Source Control
dbForge Studio for SQL Server Demo - Index Manager
Index Manager
dbForge Studio for SQL Server Demo - Unit Test
Unit Test
Product Avatar Image

Have you used dbForge Studio for SQL Server before?

Answer a few questions to help the dbForge Studio for SQL Server community

54 dbForge Studio for SQL Server Reviews

4.7 out of 5
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
54 dbForge Studio for SQL Server Reviews
4.7 out of 5
54 dbForge Studio for SQL Server Reviews
4.7 out of 5
G2 reviews are authentic and verified.
Verified User in Health, Wellness and Fitness
AH
Small-Business (50 or fewer emp.)
"dbForge Studio for SQL Server evaluation review"
What do you like best about dbForge Studio for SQL Server?

Good IDE. Good formattingoptions. Explain Plan is much more cleaner than SSMS and very user friendly. Table And View definition viewer is ver y user friendly. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

I am surprised that I cannot see SQL agent (SQL Jobs/ Job monitor) Review collected by and hosted on G2.com.

Sergey V.
SV
Founder
Small-Business (50 or fewer emp.)
"A Swiss knife for database management"
What do you like best about dbForge Studio for SQL Server?

I have been using the tool for about a year and, in general, am very pleased with how it works. Firstly, I like its code completion and navigation features. Very handy. Initially, you took them for granted, but all the difference is felt only when you return to SSMS. Secondly, the solution has almost everything I need, like a Swiss knife - schema and data synchronization, database comparison, backup and restoration. And thirdly, the tool supports many data formats, for example, you can format cell content as JSON, XML, HTML, and if it contains an image, you can see the image in the data viewer window. Again, very handy. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

I think it’s a bit overpriced for a small team Review collected by and hosted on G2.com.

SR
Small-Business (50 or fewer emp.)
"SQL Server Management"
What do you like best about dbForge Studio for SQL Server?

It gives you all the differences between schemas and synchronize them along with analysis and customized reports. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

I am disappointed not to have a mac version. Although everything works well for windows. Review collected by and hosted on G2.com.

Iulian C.
IC
Product Management and Architecture Team Lead
Information Technology and Services
Enterprise (> 1000 emp.)
"SQL Server power at your fingertips"
What do you like best about dbForge Studio for SQL Server?

It's a complete solution. I don't need anything else.

Data comparison feature is excellent. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

There could be some improvements on high DPI outputs, like TVs in conference rooms. Review collected by and hosted on G2.com.

SC
VP of Technical Operations
Small-Business (50 or fewer emp.)
"Solid SFTP, SSH, FTP Client"
What do you like best about dbForge Studio for SQL Server?

dbForge provides an easy to use interface for managing SQL Database connections. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

Forced upgrades. My version of Dbforge is not compatible with the current version of SQL on our database. Review collected by and hosted on G2.com.

Matthew G.
MG
Software Engineer
Computer Software
Enterprise (> 1000 emp.)
"Great SSMS replacement"
What do you like best about dbForge Studio for SQL Server?

I started getting frustrated with SSMS and its wonky IntelliSense/Server connections, so I started searching for alternatives to it. There were other sql editors to choose from, but I ended up ranking this one the best of the group. I’ll list what features I liked the most below.

Starting with opening up dbForge Studio for Sql Server (I’ll call it DBFS from now on), you are presented with an intuitive interface that has recently accessed files and a tabbed gui menu near the top of the start page that will help you to get to what you need to work on immediately.

As soon as you start typing a new query you will notice that the code completion works on sql keywords as well tables and columns. I found that most of the time the “suggestions” were exactly what I was looking for and near the top of the list. There are even checkboxes that you can click instead of manually typing out the columns needed if there are many. It also offer suggested columns to join if you are attempting to do that. DBFS also highlights query blocks which makes it easier to see where a query starts and ends.

Instead of creating queries manually, there is an option to use the graphical query builder. This feature allows you to build a query graphically by dragging tables onto it and performing joins, where conditions, group by, having, and order by with the gui, which may be helpful to newbies or for creating complex queries.

The output windows has additional functionality being able to sort columns by clicking on their name, filtering by a condition to show only those rows within the output results, show only certain columns, generate scripts from the results, export data, and even modify the table data right within the cell without having to write t-sql.

The export data feature is especially good as it allows you to export to every major file type (XML, JSON, CSV, Excel, HTML, PDF and more) right out of the box. You can also change what column to export along with changing the format of the data such as specific date time, float, and currency requirements. You can also specify what rows to export such as 5 to 50.

The output window will also show what data type the column is using (E.g. the DepartmentID is a smallint) which is handy when you are trying to work with it in a query and you don’t need to look it up in the Object Explorer.

Another feature I found very helpful was the ability to format the sql document. It moves around your code and code blocks to standardize things such as tabs, spaces, indents, case, and overall structure. I know as I start coding my queries can get kinda messy, but this feature solves that and makes the code look professional and uniform across the document. You can even setup a custom profile if your org has a different, but standard in-house of wanting it to look.

Perhaps the icing on the cake is the fact that DBFS has a dark theme. I don’t know why SSMS dosnt have this yet as users have been asking for it for years, but it is here and it is great. The dark theme allows your eyes to focus on the code you are writing (or debugging) rather than the background and saves you from having eye strain and a headache from the glaring white of the background.

All in all I could probably make this review go on forever with all the additional and improved features that this product offers, but it would be easier for you to just visit the dbForge website to see a complete list.

TLDR: This is a much better SQL editor that SSMS and I would recommend it to anyone who has to write T-SQL daily and is looking for a better tool. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

Currently I am working with XML data and I do miss the collapsible code tags with XML data where SSMS has this built in.

While not being the most expensive Sql Server editor I did find it was on the expensive side at full price, but it does offer better stability, ease of use, and more features than similar products. Review collected by and hosted on G2.com.

AW
Starszy projektant
Mid-Market (51-1000 emp.)
"Good tool for developers"
What do you like best about dbForge Studio for SQL Server?

AS a developer dbForge studio is really helpful for quickly check date in our SQL databases. My favorite feature is code completion that works much better than in ssms. really helpful are ability to sort and filter results. In edit mode for columns containing foreign key you can select value from referenced table that is shown as popup in query result. Many data formats are also supported, you can format cell content as json, xml, html if it contains image you can watch this image in data viewer window.

In professional and enterprise versions is included really helpful schema compare tool that can compare not only two database but also backups and snapshots created by dbforge studio.

Table editor is also very good, it's much easier to modify table than in ssms. In editor you can find such feature as sql script that generate table and all related objects and tab with data that contains table.

Connections can be categorized by by color and shape of mark.

One of my favorite feature is also schema diagram witch is much more readable than that builtin to ssms.

For developers nice feature is also data generator that can generate good data for test environments. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

DbForge studio is not so good for most of administration tasks, it contains only basic administration tools. One of biggest issue for me is lack support for AD groups in security manager.

Graph database is also not supported for now, and it will be really helpful to see this feature.

When you have many connections it will be easier to find something if it will be ability to organize everything in tree view instead of flat view with categories. Review collected by and hosted on G2.com.

Kelvin S.
KS
Data Analyst - ETL Data Migration
Information Technology and Services
Small-Business (50 or fewer emp.)
"dB Forge for SQL Server "
What do you like best about dbForge Studio for SQL Server?

it assists with query prediction, making queries and scripting more faster and efficiently reducing chances of returned queries Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

it only works where there is already an installed MS SQL server, it is very difficult to have it working as a standalone database Review collected by and hosted on G2.com.

Martin H.
MH
Senior Developer
Computer Software
Small-Business (50 or fewer emp.)
"The only choice for serious developers"
What do you like best about dbForge Studio for SQL Server?

The best features? There are so many, so where do I start?

Robust - that's probably the the number one feature, it's rock solid and very, very flexible.

The exportation options are second to none, any one of multiple formats all respecting the data and formatting options (where applicable).

Data editing is so easy and you are able to filter, sort and customise the visible columns.

Changing the schema is as easy as editing data, quick and easy.

For the analysts there's the Pivot Tables (Excels Dynamic Tables) that make analysing data very easy and very fast.

Data Pump is much easier to use than others I seen, and synchronizing both data and schemas are available.

There art also many more options I have yet to discover, as the product has many, many options.

It's fully configurable and the LookAndFeel is configurable to meet the needs of the most demanding user.

Finally, you can connect to multiple servers on just one screen - try that with other products!

Basically, everything a serious developer would need! Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

There really aren't many features I don't like.

I tend to find myself using Management Studio to restore databases as it just seems easier to me, maybe there is room for improvement here, but that's it! Review collected by and hosted on G2.com.

Verified User in Computer & Network Security
UC
Small-Business (50 or fewer emp.)
"DbForge for SQL server"
What do you like best about dbForge Studio for SQL Server?

Database compare tool is the best one in dbForge. I usually used to compare the 2 different database and move the tables ,functions,Stored procedures structures.

Data compare tool is also good tool to use it for moving large date from one table to another

Search tool is also used to find the procedure easily Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

I like all the features they have. I don't dislike anything in dbforge.It gives the script to moving the data it would be great to have the auto schedule to data transfer or Structure transfer from one db to another. Review collected by and hosted on G2.com.

dbForge Studio fo...