Top Rated dbForge Studio for SQL Server Alternatives

DbVisualizer

(231)

4.6 out of 5

Visit Website

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

admin

dbForge Studio for SQL Server Overview

edit

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

Discussions

dbForge Studio for SQL Server Community

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

Devart

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:

Jordan Sanders

PR Manager at Devart

dbForge Studio for SQL Server Media

Database Management

dbForge Studio for SQL Server Demo - Data Reports and Analisys

Data Reports and Analysis

SQL Coding Assistant

Source Control

Index Manager

Unit Test

G2 reviews are authentic and verified.

Here's how.

John S.

Technical Team Lead, VP, Equity Trading Team

Small-Business (50 or fewer emp.)

12/15/2021

"dbForge Studio makes comparing and syncing databases relatively easy."

5/5

What do you like best about dbForge Studio for SQL Server?

I don't use all the features of dbForge today. I'm sure there are other gems to find. I primarily need dbForge Studio to help migrate data between environments and it is fantastic for this purpose.

I have tried other tools and this is by far the best that I've found for this. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

I occasionally sync tables, then re-compare them and dbForge shows that they are still different.

When this happens, it has been difficult for me to figure out why.

When I then, manually compare, they look identical to me.

I'm not sure what improvement to advise but it confuses me when I update a column to the same value as the original table, yet the compare still flags them as different. Review collected by and hosted on G2.com.

Recommendations to others considering dbForge Studio for SQL Server:

Try it. You'll like it. Review collected by and hosted on G2.com.

What problems is dbForge Studio for SQL Server solving and how is that benefiting you?

I primarily need dbForge Studio to help migrate data between environments and it is fantastic for this purpose.

I have tried other tools and this is by far the best that I've found for this. Review collected by and hosted on G2.com.

Response from Jordan Sanders of dbForge Studio for SQL Server

edit

Thanks for the awesome review, John! We work hard to meet expectations like yours, and we’re happy to hear we hit the mark for you.

We'd like to resolve the comparison issue you've described. Could you contact us at support@devart.com, please?

Bhavana G.

Cloud Engineer

Enterprise (> 1000 emp.)

12/15/2021

"Dynamic Management Views helps me to troubleshoot issues better in my SQL Server"

3.5/5

What do you like best about dbForge Studio for SQL Server?

dbForge Studio for SQL Server is an SQL management platform used to process and perform various operations in our DB servers such as data replication, transaction logs, record merge, backup snapshot, etc. It implements mirroring in which we can maintain our SQL Server copy in another server. Also, it provides high-availability recovery solutions to overcome application ramp-down shortcomings. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

It provides a superb recovery model in which my database properties are logged adequately in its transactional log whether I perform simple load, bulk load, or full load. Nothing to dislike about dbForge Studio for our SQL servers. Review collected by and hosted on G2.com.

What problems is dbForge Studio for SQL Server solving and how is that benefiting you?

We require insights to understand better on what's happening in our SQL Server, and dbForge studio provides those feasibilites. It is a great platform that can effectively track and troubleshoot performance issues and help with our database administration. Its Dynamic Management Views has 2 capabilities in which one is DMF that is a function-based utility, and DMO is an object-based utility. It also gives me comfort by enabling the issue of queries in its utility against my enterprise server to manage objects within my application. Review collected by and hosted on G2.com.

Stanislav R.

Senior .NET Developer

Mid-Market (51-1000 emp.)

6/26/2021

"Great MS SQL tool for every day use"

5/5

What do you like best about dbForge Studio for SQL Server?

All in one tool for MS SQL. Use it every day. Schema compare works very well, data generator another great feature, diagrams are a very useful thing (much better than in a standard MS Studio tool). Last updates this year have many nice small improvements. Work with Azure improved. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

Very sad that it is limited to Windows OS only. Would be great to have something similar for Mac or Linux. Review collected by and hosted on G2.com.

David I.

Software Engineer

Computer Software

Small-Business (50 or fewer emp.)

6/30/2021

"Feature rich dbForge Studio for SQL Server development"

4.5/5

What do you like best about dbForge Studio for SQL Server?

Full-featured IDE for SQL Server development Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

T-SQL formatting compacts the code, but I prefer readability over size. I couldn't find how to modify that behavior.

It is not possible to design diagrams using tables from several databases.

When committing changes it is not possible to attach a description. Review collected by and hosted on G2.com.

What problems is dbForge Studio for SQL Server solving and how is that benefiting you?

I have an existing database with multiple design issues. I created another database as a front-end to the original database to avoid inconsistencies and referential integrity issues which were totally possible with the original design.

So, there is a new design with many tables, views, stored procedures, functions (both scalar and tables).

All this job is the back-end for a University Management System. Review collected by and hosted on G2.com.

Matt E.

Instructor

Small-Business (50 or fewer emp.)

10/19/2020

"dbForge Actually Makes SQL "Fun""

5/5

What do you like best about dbForge Studio for SQL Server?

First of all, dbForge ships with a dark theme. That's huge already, but the features I absolutely love are:

Powerful and intuitive SQL formatting and code completion - I don't need to go searching for column names as dbForge suggests and can even insert them automatically.

The table designer and database diagrams are nice, though not necessarily unique among products. They still help me visualize and understand the database.

The killer feature for me is the ability to compare my database with another database and generate a highly customizable change script to get the other database's schema to match my own. This lets me just make changes to one database, then script them out and have the tool worry about the differences. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

Honestly, the main thing I dislike right now is my own lack of knowledge of all of dbForge's features. I don't have time to go through all the tutorials and documentation devart offers, so it's just a time limitation on my part in exploring all the ways that dbForge can help me. Review collected by and hosted on G2.com.

Recommendations to others considering dbForge Studio for SQL Server:

There's a tendency to try to stay inside of SSMS as a SQL Server developer. This is acceptable, and if you're really set on that, devart offers a dedicated add-in to SQL Server that will help you out, but it's okay to go outside of the normal set of tools and dbForge really can do what you need it to do. Review collected by and hosted on G2.com.

What problems is dbForge Studio for SQL Server solving and how is that benefiting you?

I'm not amazing with SQL, and I view a lot of database development as repetitive and tedious. The formatting, code insertion, code completion, and script generation fix ALL of these problems and let me focus on actually building out my new database. Review collected by and hosted on G2.com.

Hailin S.

Senior Software Engineer

Mid-Market (51-1000 emp.)

7/25/2021

"It is fast, relative small, has better code completion than SSMS, it's a great tool for SQL Server"

5/5

What do you like best about dbForge Studio for SQL Server?

Code completion and code formating upon paste Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

Limit result size to 1000 by default, if I want more results, have to do a bit more work Review collected by and hosted on G2.com.

James R.

Product Manager II

Mid-Market (51-1000 emp.)

9/8/2020

"Excellent product and a good alternative to Red Gate."

4/5

What do you like best about dbForge Studio for SQL Server?

Ability to perform DIFFS/compare scripts, databases, or individual database objects (views, tables, stored procs, functions) against different versions. Easy to use and exceptionally valuable if you frequently manage multiple versions of databases. Review collected by and hosted on G2.com.

What do you dislike about dbForge Studio for SQL Server?

Some features that would work fine in SQL Svr Mgt Studio may have bugs in dbForge after updates. Although infrequent, it can be quite vexing to encounter. Review collected by and hosted on G2.com.

Recommendations to others considering dbForge Studio for SQL Server:

They have a trial, get it and give it a go. If you decide to buy the product, I'd recommend the 3 year license since it is substantially less overall in cost. Review collected by and hosted on G2.com.

What problems is dbForge Studio for SQL Server solving and how is that benefiting you?

Needed additional tools to perform LINTING on SQL scripts and perform DIFF checks for code reviews.

A faster way to generate test data was also needed and the Enterprise edition of this product does that surprisingly well.

It was a nice bonus that this product also allowed export of query data to file in more formats than SSMS allowed. Review collected by and hosted on G2.com.