SSMS Tools and Add-ins for SQL Database Development

SQL Tools is a development tool pack that provides many essential features for any Microsoft SQL Server and Azure SQL developer. It is designed not only to increase your productivity, but also to reduce expenses while performing routine tasks and automate database development and deployment with dbForge DevOps Automation.

  • Reinvent your familiar IDE with 15 versatile tools
  • Put accurate and concise scripts of database changes into version control
  • Get a full record of database changes and find out who committed them
  • Generate lifelike meaningful test data for load testing and integration
  • Run T-SQL unit tests as a part of continuous integration with DevOps
  • Cut the time spent on manual development and deployment tasks
  • Increase SQL coding productivity and efficiency up to two times
  • Speed up database development with continuous integration

How dbForge SQL Tools help you work with SQL Server and Azure SQL

SQL Autocompletion, Code Formatting, Refactoring

Easily write, beautify, and refactor your code and dramatically boost your productivity with the help of smart IntelliSense-style SQL code completion, great collection of code snippets, SSMS tab coloring & document sessions, intelligent renaming of aliases and variables, advanced customizable code formatting profiles, fatal execution warning reminder, result grid aggregates and data visualizer, and many other powerful features.

Create and Manage SQL Queries Visually

dbForge Query Builder for SQL Server allows users to quickly and easily build complex SQL queries via an intuitive visual interface without the need to write code manually. Our visual SQL query tool is designed to simplify development of queries for SQL Server. This graphical SQL query designer and all of its interactive query building features will be most appreciated by users who often need to create various queries for databases.

Quick Search for SQL Objects and Table Data

dbForge Search is a free tool for SQL Server database developers that allows searching for SQL objects, data, and text in your databases. It can often be very difficult to find a required table or remember the names of your stored routines when a database contains lots of objects. With dbForge Search, you no longer need to manually go through the entire database schema to find a required column name or specific text in a stored procedure.

Easily Generate Documentation for SQL Server

Why waste time documenting databases by hand? dbForge Documenter for SQL Server is a big time saver when it comes to documentation of SQL Server databases. This database documentation tool can automatically generate documentation for an entire SQL Server database in a few clicks. The tool includes a wide range of options to customize the generated documentation so that the final result meets your specific requirements.

Decrypt SQL Server Database Objects

View and decrypt the encrypted SQL Server stored procedures, views, functions, and triggers in an SSMS-like Object Explorer and without the need to connect to DAC. Save your time while decrypting database objects by taking advantage of syntax highlighting to view DDL scripts of stored routines, using Unicode support, a batch mode, decryption caching, output options, and other features.

Compare and Sync SQL Server Databases

dbForge Data Compare for SQL Server is a powerful SQL comparison tool capable of working with big data and using native SQL Server backups as metadata source. Data Compare provides functionality to detect all changes in databases and analyze data differences in a fast and effortless fashion. You can configure your SQL database comparison through a variety of options and effortlessly synchronize data using a convenient wizard.

Compare and Sync SQL Server Schemas

dbForge Schema Compare for SQL Server is a reliable tool that saves your time and effort when comparing and synchronizing databases on SQL Server. The tool allows working with live SQL Server databases, snapshots, and backups as data sources. You can quickly compare your SQL Server databases, analyze the differences between them, and perform error-free schema synchronization using flawlessly generated SQL scripts.

Link your SQL Database to Version Control

dbForge Source Control is a powerful tool for managing SQL Server database changes in source control. The tool can link your databases to all popular source control systems, including SVN, TFS, Git (including GitHub), Perforce, Mercurical, and SourceGear Vault. dbForge Source Control delivers smooth and clear workflow in a familiar interface by allowing you to commit changes from the development branch to a remote repository and explore the revision history.

Accelerate Data Migration Between Databases

Data Pump is a SQL Server Management Studio add-in for filling SQL databases with external source data and migrating data between systems. The tool supports import and export from 10+ widely-used data formats (Excel, CSV, XML, JSON, Text, MS Access, etc.) and includes a number of advanced options and templates for recurring scenarios. It's a highly customizable solution aiming to facilitate data import and export and boost your productivity.

Analyze and Fix SQL Index Fragmentation

dbForge Index Manager is a handy tool for analyzing the status of SQL indexes and fixing issues with index fragmentation. It allows you to quickly collect index fragmentation statistics and detect databases that require maintenance. You can instantly rebuild and reorganize SQL indexes in visual mode or generate SQL script for future use. dbForge Index Manager for SQL Server will significantly boost SQL Server performance without much effort!

Monitor and Analyze SQL Server Performance

dbForge Monitor is a free tool that allows you to track and analyze SQL Server performance. It provides robust functionality for SQL Server diagnostics, including a wide range of SQL performance metrics that allow to see the comprehensive and clear picture of all processes taking place on the server, detect most expensive queries, waiting tasks, and performance bottlenecks. With dbForge Monitor, you will save hours on SQL Server performance analysis.

Collect and Analyze SQL Server Trace Data

dbForge Event Profiler for SQL Server is a FREE tool that allows you to capture and analyze SQL Server events. The events and data columns are stored in a physical trace file for later examination. You can use this information to identify and troubleshoot many SQL Server-related problems on the spot and without undue efforts, view how SQL Server works when interacting with a client, audit user activity, perform stress testing, and more.

Generate Realistic Test Data for Databases

dbForge Data Generator for SQL Server is a powerful GUI tool that provides the ability to generate test data for databases. The tool allows generating demo data for databases that are already filled with data and create your own custom test data generators. dbForge Data Generator for SQL Server can save your time and effort spent on demo data generation by populating SQL Server tables with millions of rows of sample data that looks just like real data.

Write SQL Unit Tests Directly in SSMS

An intuitive and convenient GUI for implementing automated unit testing in SQL Server databases. This dbForge SQL unit testing tool is based on the open-source tSQLt framework, so SQL developers can now write unit tests in regular T-SQL. The tool's functionality allows you to develop stable and reliable code that can be properly regression-tested at the unit level. All tests are executed in isolation mode, so the integrity of the underlying databases is preserved.

Reduce Overall Database Release Costs

A cutting-edge solution that takes conventional database development and deployment to a whole new level. By embracing the DevOps database automation and database management approaches and implementing such DevOps practices as Continuous Integration and Continuous Delivery, this database DevOps tool embodies all our knowledge and expertise in SQL Server to deliver the most innovative approach to the database lifecycle management.

Why choose SQL Tools for SQL Server and Azure SQL

Increase developer's productivity

SQL Tools provides robust functionality that will help increase your coding speed and consistency, automate many database-related processes, and generally facilitate a steady and productive workflow.

Enjoy favorable pricing

Save costs with SQL Tools developer pack as it provides a significant discount on all solutions it contains and start improving your database development and maintenance processes with more bang for your buck!

Apply database DevOps approach

With our Tools pack for SQL developers, you can easily add any database to your CI/CD pipeline which helps to manage the database lifecycle, minimize deployment risks, and keep the workflow safe and streamlined.

Extend development possibilities

dbForge SQL development Tools pack provides a wide array of solutions for database development and management that notably increase the range of tasks and challenges you can tackle quickly and effectively.

Leading companies choose dbForge SQL Tools

SYNNEX Corporation
Get started with dbForge SQL Tools at no cost

Download a FREE 30-day trial that provides full functionality and start saving time with your database tasks right away.

Download free
Buy multiple licenses with a substantial discount

The total discount for your purchase increases with each additional user that you get a license for.

Purchase now
Need a hand?

If you need any help or have questions about our tools or purchasing options, just get in touch with our team.

SQL Tools as part of DevOps Automation

Use SQL Tools along with dbForge DevOps Automation for SQL Server to extend DevOps practices to SQL Server and Azure SQL databases. The solution helps optimizing productivity, reducing database release costs, and making the overall workflow consistent and safe.

Explore

How to get a discount on dbForge products

Step 1
Fill in the form
Step 2
Wait for a reply
Step 3
Get a discount

Grow with Devart

Learn more about a lightweight and handy software-buying process with an array of benefits for enterprise companies!
  • Expertise

    We have been operating since 1997. IT professionals in more than 120 countries have been already using our products.
  • Fast support

    Our well-trained experts are always ready to provide you with timely and professional assistance.