File Size: 404 MB

Description:

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

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.

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.

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.

Features:

-Put accurate and concise scripts of database changes into version control

-Get a full record of database changes and find out who commited 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

Why choose SQL Tools for SQL Server

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 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 SQL Tools, 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

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

Tools included in bundle:

-dbForge Data Compare for SQL Server v5.0.52

-dbForge Data Generator for SQL Server v4.2.76

-dbForge Data Pump for SQL Server v1.5.89

-dbForge DevOps Automation PowerShell for SQL Server v1.0.129

-dbForge Documenter for SQL Server v1.4.75

-dbForge Event Profiler for SQL Server v1.5.73

-dbForge Index Manager for SQL Server v1.10.71

-dbForge Monitor for SQL Server v1.2.73

-dbForge Query Builder for SQL Server v3.15.78

-dbForge Schema Compare for SQL Server v5.0.57

-dbForge Search for SQL Server v2.4.72

-dbForge Source Control for SQL Server v2.0.196

-dbForge SQL Complete v6.3.16

-dbForge SQL Decryptor v3.1.24

-dbForge Unit Test for SQL Server v1.5.81

System Requirements:

OS:Microsoft Windows 7/8/8.1/10/Windows Server 2008/2012/2016/2019

Microsoft SQL Server compatibility

-SQL Server 2017 CTP2.0, 2016 SP1, 2016, 2014, 2012, LocalDB

-SQL Server 2008, 2008R2 (including Express edition)

-SQL Server 2005 (including Express edition)

-SQL Server 2000

-SQL Azure

Microsoft SQL Server Management Studio compatibility:

-SSMS v18

-SSMS v17

-SSMS 2016 (including Express editions)

-SSMS 2014 (including Express editions)

-SSMS 2012 (including Express editions)