DbVisualizer vs. SQL Server Management Studio (SSMS)

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
DbVisualizer
Score 8.9 out of 10
N/A
DbVisualizer is a multi-database tool for developers, analysts and database administrators, providing a single interface across a wide variety of operating systems. Boasting an easy-to-use and clean interface, DbVisualizer runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.
$0
SQL Server Management Studio (SSMS)
Score 8.2 out of 10
N/A
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.
$0
Pricing
DbVisualizerSQL Server Management Studio (SSMS)
Editions & Modules
DbVisualizer Free
$0
DbVisualizer Pro with Basic support - Renewal
$89
per year per user
DbVisualizer Pro with Premium support - Renewal
$119
per year per user
DbVisualizer Pro with Basic support
$199
per year per user
DbVisualizer Pro with Premium support
$229
per year per user
No answers on this topic
Offerings
Pricing Offerings
DbVisualizerSQL Server Management Studio (SSMS)
Free Trial
YesNo
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeOptionalNo setup fee
Additional DetailsNew license cost includes a perpetual license, software upgrades and support for the length of the term. 1, 2 & 3 year terms are offered. Once license expires the user may access all Pro versions released before the license expiry indefinitely. To gain access to Pro versions released after the license expired, license renewal is offered. Volume discounts apply to both new and renewal licenses.
More Pricing Information
Community Pulse
DbVisualizerSQL Server Management Studio (SSMS)
Considered Both Products
DbVisualizer
Chose DbVisualizer
A bit less MSSQL-specific functionality than SSMS (obviously), but DbVisualizer has a far better data view and query editor, and is much less clunky.
Chose DbVisualizer
SSMS is fabulous for databases with an on-prem SQL Server driver, but not very helpful with anything else. I loathe DBeaver. It runs your query once for a "sample"... and even if that sample took 45 minutes to pull, it'll run the query AGAIN for 45 minutes to show you your full …
Chose DbVisualizer
has easier functionality for basic db admin than SSMS; can see data immediately w/o running a SELECT statement
Chose DbVisualizer
DbVisualizer supports multiple databases eleminate the need to install a specific tool for each DB type.
Chose DbVisualizer
Better intactions with the data inside the database
SQL Server Management Studio (SSMS)

No answer on this topic

Features
DbVisualizerSQL Server Management Studio (SSMS)
Database Development
Comparison of Database Development features of Product A and Product B
DbVisualizer
7.8
47 Ratings
8% below category average
SQL Server Management Studio (SSMS)
-
Ratings
Performance optimization tools7.542 Ratings00 Ratings
Schema maintenance8.144 Ratings00 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
DbVisualizer
7.4
34 Ratings
8% below category average
SQL Server Management Studio (SSMS)
-
Ratings
User management7.931 Ratings00 Ratings
Database security7.325 Ratings00 Ratings
Database status reporting7.125 Ratings00 Ratings
Best Alternatives
DbVisualizerSQL Server Management Studio (SSMS)
Small Businesses
DBeaver
DBeaver
Score 8.4 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
Medium-sized Companies
DBeaver
DBeaver
Score 8.4 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
Enterprises
DBeaver
DBeaver
Score 8.4 out of 10
PyCharm
PyCharm
Score 9.2 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
DbVisualizerSQL Server Management Studio (SSMS)
Likelihood to Recommend
8.8
(53 ratings)
7.0
(1 ratings)
Likelihood to Renew
9.1
(3 ratings)
-
(0 ratings)
Usability
8.3
(23 ratings)
-
(0 ratings)
Support Rating
9.1
(2 ratings)
-
(0 ratings)
Implementation Rating
8.6
(2 ratings)
-
(0 ratings)
User Testimonials
DbVisualizerSQL Server Management Studio (SSMS)
Likelihood to Recommend
DbVis Software AB
Whenever you have to access data sources from more than one database engine provider, you should consider using DbVisualizer for the task. Switching between multiples IDE consumes time and resources (memory), and you also need to learn menus, shortcuts, etc., for each IDE, while using DbVisualizer allows you to work consistently no matter which database engine you are connecting. You can use it to simply navigate through data structures, write SQL sentences or even create new tables and views, develop stored procedures, etc.
Read full review
Microsoft
It's well suited for database management, backups, data import/export. It's not as strong for handling multiple queries at the same time, as a developer, we sometimes have multiple queries opened on the development database. In SSMS if you close the software, you'll lose the opened tabs and history
Read full review
Pros
DbVis Software AB
  • Out-of-the-box support for many different databases.
  • Intuitive UI for interacting with data.
  • Flexibility of SQL Commander for writing scripts.
  • Great support for working with JSON data in recent updates.
  • Database connections over SSH.
  • Table relationship visualization is very helpful.
  • The tree view is well organized in how it splits out schemas.
Read full review
Microsoft
  • Easy and clean IU that enables quick analysis
  • Reliable and with known stability
  • Folder like managment of Databases/Tables
Read full review
Cons
DbVis Software AB
  • Small, but noticeable: it would be nice to be able to highlight just one column of a data output for copy/paste by clicking on the column header (a feature some of us are accustomed to from SQL Server Management Studio)
  • Is there an ability to bulk import an excel file to a table in a connected SQL Server in DbVis? If so, I haven't figured that out yet. I still largely use Microsoft SSMS to import data to our team's personal SQL Server, but can easily query that server via DbVis)
  • (I really don't have any major complaints - our company has tried to steer users toward DBeaver for YEARS, which I cannot stand. DbVis knocks the beaver out of the water)
Read full review
Microsoft
  • it can still be made easier for connecting perspective
  • some bugs on versions of SQL can be avoided.
  • can be more user friendly
Read full review
Likelihood to Renew
DbVis Software AB
We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.
Read full review
Microsoft
No answers on this topic
Usability
DbVis Software AB
I use this tool for several hours each day, spanning many years in various projects. It's wide support for various database types while keeping consistency within the UI for each is important when working with various databases day in and day out.
Read full review
Microsoft
It's very user friendly. If you know T-SQL then you can use this. Really even if you don't it's not that hard to figure out. You can create things visually as well.
Read full review
Support Rating
DbVis Software AB
Never used
Read full review
Microsoft
No answers on this topic
Alternatives Considered
DbVis Software AB
[DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.
Read full review
Microsoft
It still lacks some features that make DataGrip great for developers like tab history, persists the last session, detailed customization for query formatting, more data export options and the table edit dialog is more comfortable to use since it can be resized
Read full review
Return on Investment
DbVis Software AB
  • Positive: Real time saver when working across multiple databases. At least 30-40 mins a day are saved
  • Positive: Helpful for the 'quick DBA' tasks without switching to the native tools: approx 1-2 hours saved weekly
  • Positive: Easy switch between environments / schemas / etc without hassle: saved at least an hour daily
Read full review
Microsoft
  • Not expensive
  • Easy to install and distribute from Windows
  • Not complex (Low trainning)
Read full review
ScreenShots

DbVisualizer Screenshots

Screenshot of Screenshot of SQL formattingScreenshot of ERD diagramScreenshot of Auto completeScreenshot of Database connectionScreenshot of Database connection