MICROSOFT SQL SERVER
The SQL Server client with the highest user satisfaction.
A TOP-PERFORMING SQL Server EDITOR
A SQL Server client you can trust.
DbVisualizer has been a top-performing SQL Server database client for a long time.
It includes all you need to connect, develop and manage your SQL Server database. It has support for SQL Server specific object types and everything else that makes MSSQL Server great.
OBJECT TYPES AND ACTIONS
Supports object types specific to SQL Server.
DbVisualizer gives you full control of your SQL Server database. It even offers support for object types and actions specific to Microsoft SQL Server. Here are some examples.
Triggers
Automated actions responding to database events in SQL Server tables.
Procedures
Stored code blocks in SQL Server for repetitive tasks and logic.
Constraints
Rules enforcing data integrity and relationships in SQL Server tables.
PROPERTIES
Configurable for how you want to work.
You can set up custom properties for your MSSQL databases directly in DbVisualizer, so that you can make it the best Microsoft SQL client matching your preferences. Make sure the user is prompted to enter User ID and password. Enable preprocessing of scripts. You can even set up auto-commit and much more.
The properties below and many more can be configured in the MSSQL manager to match how you want to work.
SQL CLIENT
The universal
database tool.
DbVisualizer is meticulously engineered to handle objects and properties specific to SQL Server - but our out-of-the-box features work across almost any data source.
VISUALIZATION
Automatic visualizations.
Relations are crucial in SQL Server, and DbVisualizer will help you automatically generate visual Entity Relationship Diagrams so that you can understand dependencies and opportunities directly in the client.
EDITOR
A powerful editor for SQL Server.
Writing SQL for SQL Server is similar, but not exactly the same as for other databases. DbVisualizer understands these nuances and helps you write SQL queries more efficiently.
SCHEDULING
Scheduling with SQL Server Agent.
DbVisualizer supports the use of SQL server agent for scheduling of tasks.
Jobs can also be automatically scheduled outside of the MSSQL client, using the command-line interface and the pre-built scheduling tools of your OS.
MAVEN
JDBC driver management via Maven.
DbVisualizer always has the latest JDBC driver for Microsoft SQL Server, and historical versions. With the JDBC driver manager you’ll easily connect to your databases using JDBC drivers hosted on Maven, with multiple versions to choose from.
reviews
Our users love our product.
Users love using DbVisualizer with Microsoft SQL Server.
Tim S
Teamlead of Back-end Golang command
I love the fact that DbVisualizer works with all the database systems that I have databases in. It makes life VERY easy for me to go back and forth from MS SQL Server to MariaDB to PostgreSQL to MySQL. AND, I also have options if I have to work with others too!
I love the fact that DbVisualizer works with all the database systems that I have databases in. It makes life VERY easy for me to go back and forth from MS SQL Server to MariaDB to PostgreSQL to MySQL. AND, I also have options if I have to work with others too! show less
Verified user.
Review from G2.com
Michael L
Owner, Director of Managed Services
If you dig into Oracle, Postgres, SQL Server, DB2, MySQL and other databases regurarly, this tool is for you!
If you dig into Oracle, Postgres, SQL Server, DB2, MySQL and other databases regurarly, this tool is for you! show less
Verified user.
Review from G2.com
James T
Senior Consultant
Spanning many years as a consultant at many different client sites, I have been able to connect to all different database types (DB2, Oracle, MySQL, SqlServer, etc) using DbVisualizer.
Spanning many years as a consultant at many different client sites, I have been able to connect to all different database types (DB2, Oracle, MySQL, SqlServer, etc) using DbVisualizer. show less
Verified user.
Review from G2.com
Education Management
Administrator
I use it for MSSQL, MySQL, Pg and sometime sqlite. Its great to have the same tool for all those different database engines. I really like that i can ssh tunnel into my servers and then connect to the database. Its cross-platform support is very nice, my co worker uses windows and i use linux so being able to use the same software helps us.
I use it for MSSQL, MySQL, Pg and sometime sqlite. Its great to have the same tool for all those different database engines. I really like that i can ssh tunnel into my servers and then connect to the database. Its cross-platform support is very nice, my co worker uses windows and i use linux so being able to use the same software helps us. show less
Verified user.
Review from G2.com
Elisabeth J
Business Analyst
I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it. Connections are easy to set up and I really like being abl...
I use DBVisualizer frequently - practically daily - over several SQL Server databases. As a business analyst, I use it for doing production support, testing software modifications, etc. DB Visualizer is easy to use, does everything I ask of it. Connections are easy to set up and I really like being able to set the color for different connections - to provide a visual cue as to which environment I am working in (production vs test). DB Visualizer has lots of features that I haven't used but would like to explore. I like that DBVis is continually making improvements to the software. show less
Verified user.
Review from G2.com
Dan H
I am administering MySQL and SQL Server databases in multiple environments (development, staging, and production).The ability to connect to multiple database types, multiple database connections per database, it's flexibility and ease of use, and access to all database components in an intuitive m...
I am administering MySQL and SQL Server databases in multiple environments (development, staging, and production).The ability to connect to multiple database types, multiple database connections per database, it's flexibility and ease of use, and access to all database components in an intuitive manner. When support is required, which is seldom, quick and meaningful responses are received. show less
Verified user.
Review from G2.com
Raymond J
Small-Business(50 or fewer emp.)
What I like best is the easy way to explore data and see the links between data sets. I have used it against sql server, Oracle, Postgresql.
What I like best is the easy way to explore data and see the links between data sets. I have used it against sql server, Oracle, Postgresql. show less
Verified user.
Review from G2.com
Robert Y
Engineer / Developer
One of the best things about DbVis (apart from the fact that it just works) is that the tech support team is always super responsive.
One of the best things about DbVis (apart from the fact that it just works) is that the tech support team is always super responsive. show less
Verified user.
Review from SOURCEFORGE
Clark G
Director, Research Technology Services
One of the best software products I've ever used. I have especially appreciated that there is a cli tool as well as an excellent IDE experience.
One of the best software products I've ever used. I have especially appreciated that there is a cli tool as well as an excellent IDE experience. show less
Verified user.
Review from SOURCEFORGE
Michael B
Senior Backend Engineer
Provides a common interface to many different databases. Easy to use.
Provides a common interface to many different databases. Easy to use. show less
Verified user.
Review from CAPTERRA
G2 REVIEWS
Used and rated
by the best.
DbVisualizer is a G2 Leader among database management software.
FAQs
Microsoft SQL Server is a relational database management system.
You use the MSSQL client to connect to your MSSQL database once connected you can manage your data.
The client is used to navigate and manage data in your Microsoft SQL Server database.
It is very easy to connect to your Microsoft Server database via the built-in driver manager in DbVisualizer. The driver manager is hosted on Maven and gives you multiple versions of JDBC drivers to choose from.
You write your SQL queries in DbVisualizer that cleverly highlights operations and autocomplete suggestions. The tool also has a visual query builder, that automatically generates SQL code as you drag and drop tables and select what values you want to include.
Download DbVisualizer and connect to your MSSQL database. You can download the free version with limited functionality, try the Pro version for 21 days or buy the Pro version to get the full function set of the database client.
Microsoft SQL Server is known for being a very secure and high performing database used worldwide by corporations.
Yes. You can connect to many different data sources to view and manage data with DbVisualizer. You get one tool to manage all (on this list) data sources that are used in your business.
You can easily connect to Microsoft SQL Server by selecting MSSQL from the list of available databases in the built-in driver manager, enter your credentials, and DbVisualizer sets up the connection automatically.
This is the list of supported object types for MSSQL in DbVisualizer, we offer extended support for these MSSQL object types and functions.
You can do a lot using DbViusualizer such as create powerful scripts using client side commands to automate import/ export of data, save scripts, let the auto-complete feature assist you in writing SQL, use the reference graphs to see how tables are related and much more.
Different environmental labels mean more or less the same thing. A client indicates that you have a server elsewhere, a GUI refers to the graphical interface of the app. While IDE refers to the larger "integrated development environment" and editor refers to an actual part of the client where you write your code. A workbench concentrates more on the process of development. All of these have come to be synonyms in how people refer to the application in which you do the actual coding.
Yes, you can browse your database with DbVisualizer! You can see the tables, relations, and custom objects that have been created for each database. The automatic visualization tools give you a view of the servers explain plans and you can generate Entity Relationship Diagrams (ERDs).