Useful free and paid Microsoft SQL Server utilities and tools - complete list of 143 SQL Server Utilities
Download page: bcp Utility
Release date: 2012-02-11
Support Version: 2008/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
The bcp utility bulk copies data between an instance of MicrosoftSQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. Except when used with the queryout option, the utility requires no knowledge of Transact-SQL. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns.
Download page: GraphView
Release date: 2016-02-23
Support Version: -
Author: Microsoft
Free version: Yes
Price: No
GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to manage graphs. It connects to a SQL database locally or in the cloud, stores graph data in tables and queries graphs through a SQL-extended language.
Download page: Baseline Security Analyze
Release date: 2015-01-09
Support Version: -
Author: Microsoft
Free version: Yes
Price: No
Instruction: http://www.sqlshack.com/how-to-install-and-use-microsoft-baseline-security-analyzer-mbsa/
The Microsoft Baseline Security Analyzer provides a streamlined method to identify missing security updates and common security misconfigurations. MBSA 2.3 release adds support for Windows 8.1, Windows 8, Windows Server 2012 R2, and Windows Server 2012. Windows 2000 will no longer be supported with this release.
Download page: tablediff Utility
Release date: -
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
Instruction: SQL Server tablediff utility by Robert Sheldon
The tablediff utility is used to compare the data in two tables for non-convergence, and is particularly useful for troubleshooting non-convergence in a replication topology. This utility can be used from the command prompt or in a batch file to perform the following tasks:
- A row by row comparison between a source table in an instance of SQL Server acting as a replication Publisher and the destination table at one or more instances
- Perform a fast comparison by only comparing row counts and schema.
- Perform column-level comparisons.
- Generate a Transact-SQL script to fix discrepancies at the destination server to bring the source and destination tables into convergence.
- Log results to an output file or into a table in the destination database.
Download page: Microsoft Log Parser
Release date: -
Support Version: -
Author: Microsoft
Free version: Yes
Price: No
Instruction: Microsoft Log Parser Utility: Swell ETL by Robert Sheldon
Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files,
XML files and CSV files, as well as key data sources on the Windows operating system such as the Event Log, the Registry, the file system, and Active Directory.
Download page: Diskspd
Release date: 2015-12-14
Support Version: -
Author: Microsoft
Free version: Yes
DISKSPD is a storage load generator / performance test tool from the Windows/Windows Server and Cloud Server Infrastructure Engineering teams. Compilation is supported with Visual Studio and Visual Studio Express. Use the Visual Studio solution file inside the diskspd_vs2013 directory.
Download page: HammerDB
Release date: 2015-05-04
Support Version: -
Author: Open Source
Free version: Yes
Price: No
HammerDB is an open source database load testing and benchmarking tool for Oracle, SQL Server, DB2, TimesTen, PostgreSQL, Greenplum, Postgres Plus Advanced Server, MySQL, Redis and Trafodion SQL on Hadoop.
Download page: Exchange Server Error Code Look-up
Release date: 2004-05-10
Support Version: -
Author: Microsoft
Free version: Yes
Useful link: http://www.sqlshack.com/how-to-install-and-use-microsoft-baseline-security-analyzer-mbsa/
Determine error values from decimal and hexadecimal error codes in Microsoft Windows operating systems.
Download page: LINQPad
Release date: 2016-02-01
Support Version: 2008/2012/2014/2016
Author: Joseph Albahari
Free version: Yes
Price: $45
Instantly test any C#/F#/VB snippet or program, Query databases in LINQ (or SQL) — SQL/CE/Azure, Oracle, SQLite & MySQL. Standard edition free, with no expiry. Enjoy rich output formatting, optional autocompletion and integrated debugging, Script and automate in your favorite .NET language, Super lightweight — single 15MB executable!
Download page: SqlDynamite
Release date: 2016-04-06
Support Version: 2008/2012/2014/2016
Author: Anatoly Sova
Free version: Yes
Price: No
Easy text search in stored procedures, functions, tables, views and triggers. Supports MSSQL, Oracle, SAP, Firebird, Mysql, PostgreSQL, DB2, Informix, SQLite, Ingres, SQL Azure, Interbase.
Download page: SQL Server Data Tools
Release date: 2016-04-14
Support Version: 2008/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
QL Server Data Tools (SSDT) is a modern development tool that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
Download page: Database Health Monitor
Release date: 2016-03-20
Support Version: 2008/2012/2014/2016
Author: Steve Stedman
Free version: Yes
Price: No
Database Health Monitor is a powerful performance monitoring and diagnostics solution that alerts administrators to server health, performance or availability problems within their SQL Server environment, all from a central console.
Download page: SchemaDrift
Release date: 2016-02-28
Support Version: 2008/2012/2014
Author: Steve Stedman
Free version: Yes
Price: No
SchemaDrift is a SQL Server database comparison tool that allows you to compare the schema, the tables, indexes, stored procedures, functions, and much more between SQL Server databases
Download page: DBeaver
Release date: 2016-06-06
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: Open Source
Free version: Yes
Price: No
Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MongoDB, Cassandra, etc
Download page: dta Utility
Release date: -
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
Capture performance and usage data about your Microsoft SQL Server 2005+ databases to inform insights and improve troubleshooting. Key real-time metrics provide an overview of your databases and detailed measurements about memory usage, connections, network I/O, and file I/O.
Download page: osql Utility
Release date: -
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
The osql utility allows you to enter Transact-SQL statements, system procedures, and script files.
This utility uses ODBC to communicate with the server.
Download page: sqldiag Utility
Release date: -
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
The SQLdiag utility is a general purpose diagnostics collection utility that can be run as a console application or as a service.
You can use SQLdiag to collect logs and data files from SQL Server and other types of servers, and use it to monitor your servers over time
or troubleshoot specific problems with your servers.
SQLdiag is intended to expedite and simplify diagnostic information gathering for Microsoft Customer Support Services.
Download page: sqldumper Utility
Release date: -
Support Version: 2005/2008/2008R2/2012
Author: Microsoft
Free version: Yes
Price: No
You can use the Sqldumper.exe utility to generate a dump file on demand for any Microsoft Windows application.
For example, you can generate a dump file for debugging an application problem when a computer that is running SQL Server 2005,
Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2012 is not responding to user requests.
A dump file can be a mini-dump file, a full dump file, or a filtered dump file.
Download page: SqlLocalDB Utility
Release date: -
Support Version: 2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
SqlLocalDB lets you create, delete, start, stop, and perform a number of other related tasks on an instance of SQL Server 2012 Express LocalDB,
an execution mode of SQL Server Express that’s targeted at developers. A LocalDB instance uses a minimal set of files to start the database engine.
Download page: sqllogship Utility
Release date: -
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
The sqllogship application performs a backup, copy, or restore operation and associated clean-up tasks for a log shipping configuration.
The operation is performed on a specific instance of Microsoft SQL Server for a specific database.
Download page: sqlservr Application
Release date: -
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
The sqlservr application starts, stops, pauses, and continues an instance of Microsoft SQL Server from a command prompt.
Download page: sqlps Utility
Release date: -
Support Version: 2008/2008R2/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
The sqlps utility starts a Windows PowerShell 2.0 session with the SQL Server PowerShell provider and cmdlets loaded and registered. You can enter PowerShell commands or scripts that use the SQL Server PowerShell components to work with instances of SQL Server and their objects. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the sqlps PowerShell module instead.
Download page: sqlmaint Utility
Release date: -
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
The sqlmaint utility performs a specified set of maintenance operations on one or more databases. Use sqlmaint to run DBCC checks, back up a database and its transaction log, update statistics, and rebuild indexes. All database maintenance activities generate a report that can be sent to a designated text file, HTML file, or e-mail account. sqlmaint executes database maintenance plans created with previous versions of SQL Server. To run SQL Server maintenance plans from the command prompt, use the dtexec Utility. This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use SQL Server maintenance plan feature instead.
Download page: Ssms Utility
Release date: -
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
The Ssms utility opens SQL Server Management Studio. If specified, Ssms also establishes a connection to a server, and opens queries, scripts, files, projects, and solutions. You can specify files that contain queries, projects, or solutions. Files that contain queries are automatically connected to a server if connection information is provided and the file type is associated with that type of server. For instance, .sql files will open a SQL Query Editor window in SQL Server Management Studio, and .mdx files will open an MDX Query Editor window in SQL Server Management Studio. SQL Server Solutions and Projects will open in SQL Server Management Studio.
Download page: dtexec Utility
Release date: -
Support Version: 2012/2014/2016
Author: Microsoft
Free version: Yes
Price: No
The dtexec command prompt utility is used to configure and execute SQL Server Integration Services packages. The dtexec utility provides access to all the package configuration and execution features, such as parameters, connections, properties, variables, logging, and progress indicators. The dtexec utility lets you load packages from these sources: the Integration Services server, an .ispac project file, a Microsoft SQL Server database, the SSIS Package Store, and the file system.
Download page: BPA 2005
Release date: 2008-08-13
Support Version: 2005
Author: Microsoft
Free version: Yes
Price: No
The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.
Download page: BPA 2000
Release date: 2010-04-26
Support Version: 2000
Author: Microsoft
Free version: Yes
Price: No
SQL Server 2000 Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices on your servers.
Download page: BPA 2008
Release date: 2010-06-18
Support Version: 2008/2008R2
Author: Microsoft
Free version: Yes
Price: No
The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions:
- Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server
- Determines if the configurations are set according to the recommended best practices
- Reports on all configurations, indicating settings that differ from recommendations
- Indicates potential problems in the installed instance of SQL Server
- Recommends solutions to potential problems
Download page: BPA 2012
Release date: 2012-04-06
Support Version: 2012
Author: Microsoft
Free version: Yes
Price: No
The Microsoft SQL Server 2012 BPA is a diagnostic tool that performs the following functions:
- Gathers information about a Server and a Microsoft SQL Server 2012 instance installed on that Server
- Determines if the configurations are set according to the recommended best practices
- Reports on all configurations, indicating settings that differ from recommendations
- Indicates potential problems in the installed instance of SQL Server
- Recommends solutions to potential problems
Download page: DLM Dashboard
Release date: 2016-04-27
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: Yes
Price: No
DLM Dashboard tracks your database schemas and alerts you when they change.
DLM Dashboard monitors up to 50 of your databases, and sends you an email alert as soon as your databases start to drift,
or change from their expected state. On the web dashboard, you can see exactly what changed, who made the changes, and when.
Download page: Red Gate SQL Compare
Release date: 2016-05-09
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $495
Compares and synchronizes SQL Server database schemas
Download page: Red Gate SQL Data Compare
Release date: 2016-05-09
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $495
SQL Data Compare is the industry-standard tool for comparing and deploying SQL Server database contents
Download page: Red Gate SQL Source Control
Release date: 2016-02-03
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $495
Connect your databases to your source control system
Download page: Red Gate SQL Prompt
Release date: 2016-04-28
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $369
Write, format and refactor SQL effortlessly
Download page: Red Gate SQL Monitor
Release date: 2015-10-15
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $1495
Real-time SQL Server performance monitoring, with alerts and diagnostics
Download page: Red Gate SQL Backup Pro
Release date: 2014-07-08
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $995
Compress, verify, and encrypt SQL Server backups
Download page: Red Gate SQL Doc
Release date: 2016-04-26
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $369
Document your databases automatically, create documents as HTML, PDF, Microsoft Word or Compiled HTML Help files
Download page: Red Gate SQL Data Generator
Release date: 2016-04-26
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $369
Generate realistic test data fast
Download page: Red Gate SQL Dependency Tracker
Release date: 2016-04-26
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $369
Visualize complex databases simply
Download page: Red Gate SQL Dependency Tracker
Release date: 2016-04-15
Support Version: 2005/2008/2012/2014
Author: Red Gate
Free version: No
Price: $245
Deploy multiple scripts to multiple servers with just one click
Download page: Red Gate SQL Index Manager
Release date: ?
Support Version: 2008/2012/2014
Author: Red Gate
Free version: No
Price: $149
Analyze, manage, and fix database index fragmentation
Download page: Red Gate SQL Comparison SDK
Release date: 2016-02-22
Support Version: 2008/2012/2014
Author: Red Gate
Free version: No
Price: $895
Compare and synchronize automatically database schemas and data
Download page: DLM Automation
Release date: ?
Support Version: 2008/2012/2014
Author: Red Gate
Free version: No
Price: ?
Automate your database changes with continuous integration and automated deployment
Download page: ReadyRoll
Release date: 2016-03-01
Support Version: 2012/2014
Author: Red Gate
Free version: No
Price: $345
It generates numerically ordered SQL migration scripts that sit inside your project and take your schema from one version to the next. You can add them to version control, use them to build and release, and automate database and application deployments, all in one process.
Download page: SQL XEvent Profiler
Release date: 2014-03-14
Support Version: 2012/2014
Author: Idera
Free version: Yes
Price: No
Idera’s SQL XEvent Profiler emulates the functionality and simplicity of SQL Server Profiler, letting you quickly view data from SQL events
and see whats happening on the server. Plus, it leverages SQL Extended Events (XEvents) as the backing technology — making it more efficient than SQL Trace.
Download page: SQL Check
Release date: 2015-09-24
Support Version: 2005/2008/2008R2/2012/2014
Author: Idera
Free version: Yes
Price: No
- Check out what happens in batches, compilations, recompilations, and transactions throughout the SQL Server environment
- Monitor some of the most important metrics in SQL Server including wait stats, reads, writes, session details, and cache hits
- See SQL operations as they occur for the latest information; consider it a heart rate monitor for your SQL Server environment
- Install easily without agents
Download page: SQL Fragmentation Analyzer
Release date: 2012-11-16
Support Version: 2005/2008/2008R2/2012/2014
Author: Idera
Free version: Yes
Price: No
- Analyze fragmentation by one table or an entire database
- Identify databases in need of defragmentation
- Set fragmentation thresholds: normal, warning, critical
Download page: SQL Heat Map
Release date: 2016-01-27
Support Version: 2005/2008/2008R2/2012/2014
Author: Idera
Free version: Yes
Price: No
- Get one visual view of storage in all tables of a database
- See storage allocation, utilization, and type of data
- Quickly locate tables and indexes that need more allocated storage
Download page: SQL Hekaton Memory Check
Release date: 2015-06-10
Support Version: 2014
Author: Idera
Free version: Yes
Price: No
- Monitor the impact of memory optimized tables on server memory
- Identify high memory utilizing tables
- Assess server memory capacity
- Simulate moving to In-Memory OLTP
Download page: SQL Page Viewer
Release date: 2014-08-25
Support Version: 2005/2008/2008R2/2012/2014
Author: Idera
Free version: Yes
Price: No
- Displays page level data summary and detail information
- Has elegant GUI design for fast access in 1 click
- Can select any SQL server and database table
- Can navigate to any page data quickly in a tree view
- Can launch directly within SSMS for optimal usability
Download page: SQL Update Statistics
Release date: 2015-12-14
Support Version: 2005/2008/2008R2/2012/2014
Author: Idera
Free version: Yes
Price: No
- Launch directly within SSMS for optimal usability
- Identify out-of-date SQL Server table and index statistics
- View and change database statistics options
- Create graphical histograms for each column’s statistics
Download page: SQL Statistics Aggregator
Release date: 2015-05-18
Support Version: 2005/2008/2008R2/2012/2014
Author: Idera
Free version: Yes
Price: No
- Aggregate IO statistics to identify problem tables
- Correlate disk activity with query plan nodes
- Compare runs of a query over time
- Export and import results for easy collaboration
Download page: SQL Backup Status Reporter
Release date: 2015-08-07
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: Yes
Price: No
- Quickly identify databases which have not had backups
- View backup history including the backup date and type
- Have simplified grid view for easy sorting and navigation
- Identify full and differential backups for many databases
Download page: SQL Integrity Check
Release date: 2013-08-26
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: Yes
Price: No
- Easily run a CHECKDB for any database on-demand
- View integrity check results to identify corruption
- Routinely verifies when last check was performed
- Receive alerts when databases are due for checks
- Do not need to write and maintain scripts
Download page: SQL Job Manager
Release date: 2012-03-19
Support Version: ?
Author: Idera
Free version: Yes
Price: No
- Have management console to easily view past and current jobs
- Can identify and correct job contention
- Can drag and drop jobs across servers to level workloads
- Can "at a glance" view to see failed or runaway jobs
- Have customizable calendar view
Download page: Azure SQL Database Backup
Release date: 2012-10-02
Support Version: ?
Author: Idera
Free version: Yes
Price: No
- Save time and storage space with up to 95% compression
- Backup on-premise or to Azure BLOB storage
- Central data storage to prevent data loss
- View historical backup and restore operations
- Restore with transaction consistency to and from the cloud
Download page: SQL Column Search
Release date: 2015-11-17
Support Version: 2005/2008/2008R2/2012/2014
Author: Idera
Free version: Yes
Price: No
- Find potentially sensitive data
- Search an entire instance or a specific table
- Export results to CSV format for easy analysis and reporting
Download page: SQL Permissions Extractor
Release date: 2015-08-07
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: Yes
Price: No
- Generate T-SQL scripts for copying of user permissions
- Edit, save, and execute permissions scripts
- Include object level permissions for selected databases
- Copy, extract, modify and apply changes in four steps
Download page: SQL BI Check
Release date: 2016-04-13
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: Yes
Price: No
- Real-time performance monitoring for SQL Server Analysis Services (SSAS)
- See physical server metrics for CPU, disk, and storage
- View analysis metrics for SSAS processing, memory, and cache
- Get up and running in minutes, no agents required
Download page: SQL Inventory Check
Release date: 2016-03-24
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: Yes
Price: No
- Discover unknown and forgotten instances posing security and performance risks
- Track SQL Servers to manage license and support costs
- Stay on top of important SQL Server updates and patches
Download page: SQL Diagnostic Manager
Release date: ?
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $1747
- Performance monitoring for physical and virtual environments
- Query plan monitoring to see the causes of blocks and deadlocks
- Integrated SQL Doctor expert recommendations
- Easy integration with Microsoft SCOM
- Predictive alerting with settings to avoid false alerts
- Web-based dashboard with at-a-glance views of top issues and alert
Download page: SQL Safe Backup
Release date: 2016-03-24
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $907
- Backup faster than native SQL and save space with dynamic compression
- Reduce failures due to network problems
- Automate full, differential, and transaction log backups
- Integrated cloud backup support for Amazon S3
- Instant Restore provides immediate access to backup data
- Web-based dashboard provides at-a-glance views of top issues and alerts
Download page: SQL Compliance Manager
Release date: 2015-09-08
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $2657
- Audit Sensitive Data - see who did what, when, where, and how
- Track and Detect - monitor and alert on suspicious activity
- Satisfy Audits - for PCI, HIPAA, FERPA and SOX requirements
- Generate Reports - 25 built-in reports to validate SQL Server audit trails
- Minimize Overhead - light data collection agent minimizes server imp
Download page: SQL Inventory Manager
Release date: 2016-04-22
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $3195
- View your SQL Server inventory - know what you have where & who owns it
- Auto-discover any new servers installed, to better manage server sprawl
- Get alerts when a server goes down, or space is running low
- Set tags to better organize servers and databases across the enterprise
- Quickly deploy and access from anywhere via web-based and agentless UI
Download page: SQL Virtual Database
Release date: 2016-03-24
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $625
- Immediate access - get data from backup files instantly
- Acts like a real database - Use 3rd party and native tools
- OLR replacement - better solution to object level recovery
- Multiple Uses - reporting, data extraction, analysis, etc.
- Read/Write support - inserts, updates, DBCC commands
Download page: SQL Secure
Release date: 2016-04-19
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $907
- Identify existing vulnerabilities in your SQL Servers
- Harden security policies across SQL Servers
- Rank security levels with the security report card
- Analyze and report user permissions across SQL Servers
- Customizable templates for PCI, HIPAA and more
Download page: SQL Doctor
Release date: 2015-12-17
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $625
- New and enhanced Expert Recommendations to help improve performance
- Dashboard exposes performance metrics in real-time
- "Quick Findings" instantly locates SQL performance issues
- Executable scripts are generated to optimize performance
- Stored history of analysis recommendations for trending
Download page: SQL Admin Toolset
Release date: 2016-01-13
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $325
- 24 essential desktop tools for your everyday SQL Server needs
- Run every day diagnostics across multiple SQL servers
- Complete administrative tasks in minutes, not hours
- Perform analysis on your SQL data
Download page: SQL Defrag Manager
Release date: 2016-03-10
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $1495
- Automate identification of index fragmentation "hot spots"
- Schedule index defragmentation jobs
- Avoid database contention with system resource pre-checks
- Reduce page splits with index fill factor settings control
- Centrally manage, report and notify instantly
Download page: DBArtisan
Release date: ?
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $3122
- Manage multiple platforms (Oracle, SQL Server, DB2, Sybase) from one UI
- Proactively manage space, data and performance with built-in analytics
- Easily find and fix performance issues using intelligent diagnostics
- Move schema and table data across different platforms with ease
- Protect data security with view, grant and revoke of permissions
Download page: SQL BI Manager
Release date: 2015-09-08
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $697
- Monitor SSAS, SSRS, & SSIS health with agentless monitoring
- View active sessions, workload, and report generation performance
- Identify issues with access to data including cube size and resource utilization
- Set up alerts with configurable thresholds
- Log in from anywhere for at-a-glance views of top issues and alerts
Download page: SQL Enterprise Job Manager
Release date: 2015-09-08
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $697
- Monitor SQL Server agent jobs across the enterprise
- Easily view job status and details with familiar calendar layout
- Chain jobs together and build automated workflows
- Configure and manage jobs that run over multiple instances
- Set alerts to be notified of potential issues
- Web-based architecture simplifies deployment
Download page: DB Optimizer
Release date: ?
Support Version: 2005/2008/2008R2/2012
Author: Idera
Free version: No
Price: $1420
- Streamline tuning of SQL code on major DBMSs from one interface
- Tune SQL like a pro with automated performance optimization suggestions
- Tackle complex SQL queries with visual SQL tuning diagrams
- Pinpoint problem SQL with database profiling of wait-time analysis
- Load test alternative SQL queries in simulated production environment
Download page: dbForge Schema Compare
Release date: 2015-12-22
Support Version: 2005/2008/2008R2/2012/2014
Author: Devart
Free version: No
Price: $150
dbForge Schema Compare for SQL Server is a reliable tool that will save you time and effort when you need to compare databases on SQL Server. The relentlessly tested compare tool allows working with live SQL Server databases, database snapshots, and backups. You can compare your SQL Server databases, analyze differences and synchronize your schemas using generated SQL script in a well-designed user interface quickly and without errors.
Download page: dbForge Schema Compare
Release date: 2015-11-30
Support Version: 2005/2008/2008R2/2012/2014
Author: Devart
Free version: No
Price: $150
dbForge Data Compare for SQL Server is a powerful, fast and easy to use SQL comparison tool, capable of using native SQL Server backups as metadata source. With dbForge Data Compare you can tune your SQL database comparison, quickly analyze differences in a well-designed user interface and effortlessly synchronize data via a convenient wizard with additional options.
Download page: dbForge Data Generator
Release date: 2015-12-30
Support Version: 2005/2008/2008R2/2012/2014
Author: Devart
Free version: No
Price: $250
dbForge Data Generator for SQL Server is a powerful GUI tool for fast generation of meaningful test data. The tool includes 190+ predefined generators with sensible configuration options, that allow emulating column-intelligent real-world data. dbForge Data Generator for SQL Server can save your time and effort by populating SQL Server tables with millions of rows of test data that looks just like real data.
Download page: dbForge Query Builder
Release date: 2015-06-03
Support Version: 2005/2008/2008R2/2012/2014
Author: Devart
Free version: No
Price: $100
dbForge Query Builder for SQL Server allows users to build complex SQL queries via an intuitive visual query building interface easily and without manual code writing. This SQL query designer will be useful to those, who often create queries to databases. Visual features to create queries, usage of graphical SQL query creator to interactively build queries, would be most appreciated by users who have no experience in writing queries manually. But even experienced users can save a lot of time on routine work.
Download page: dbForge Event Profiler
Release date: 2015-04-08
Support Version: 2008/2012/2014
Author: Devart
Free version: Yes
Price: No
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.
Download page: dbForge SQL Decryptor
Release date: 2013-11-07
Support Version: 2005/2008/2008R2/2012
Author: Devart
Free version: Yes
Price: No
Decrypt SQL Server Procedures, Functions, Triggers, and Views
Download page: dbForge Studio
Release date: 2015-12-18
Support Version: 2008/2008R2/2012/2014
Author: Devart
Free version: Yes
Price: $250
- Code completion — to create whole SQL statement in a few keystrokes
- SQL formatting — to follow common coding style (standard)
- SQL snippets — to save time storing and reusing repeated code fragments
- Quick object information — to show hints with info on database objects
- Code navigation — quick jump by F12 to variable declaration, object editor, etc.
Download page: dbForge Fusion
Release date: 2016-03-03
Support Version: 2008/2008R2/2012/2014
Author: Devart
Free version: No
Price: $150
dbForge Fusion for SQL Server is a powerful Visual Fusion plugin designed to simplify SQL database development and enhance data management capabilities. When you integrate dbForge Fusion for SQL Server into Microsoft Visual Fusion, all database development and administration tasks become available from your IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements and queries, and manipulate data in different way.
Download page: Minion Enterprise
Release date: ?
Support Version: 2008/2008R2/2012
Author: MinionWare
Free version: No
Price: $1500
Minion Enterprise was designed by database administrators (DBAs) specifically to address the issues that waste the most time and cause the most problems. Minion shrinks dozens of those one-at-a-time tasks down to a central process. And, it does this without the usual overhead of monitoring software. When you install Minion Enterprise, it automatically begins gathering data from instances across your enterprise. That single repository of data allows you to centrally audit, alert, report, and investigate your entire environment. Even better, it opens up a new world of central management: audit SQL and AD security, clone user permissions across servers, standardize and enforce SQL Server settings, automate error log searches, and so very much more.
Download page: SQL Server Compression Estimator
Release date: 2011-06-02
Support Version: 2008/2008R2/2012
Author: Bob Tavlor
Free version: Yes
Price: No
SQL Server Compression Estimator (SSCE) will allow you to estimate the best compression for your objects. It will estimate both ROW and PAGE compression, and will optionally report the Index Maintenance Ratio (a ratio that indicates how often an index is updated versus how often it is used to satisfy queries). You can then use that information to perhaps choose a less aggresive compression algorithm for heavily updated indexes.
Download page: ClearTrace
Release date: 2015-07-04
Support Version: 2008/2012/2014
Author: Bill Graziano
Free version: Yes
Price: No
ClearTrace imports SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000 trace and Profiler files into SQL Server and displays summary performance information.
Download page: SQLSentry Fragmentation Manager
Release date: 2016-08-03
Support Version: 2008/2012/2014
Author: SQLSentry
Free version: No
Price: $795
Dramatically improves the manageability and visibility of SQL Server index fragmentation across the enterprise
Fragmentation Manager helps you make good decisions about how and when to defragment. You can easily set up an environment-wide schedule to automate index analysis and defragmentation operations, while allowing the flexibility to customize the schedule and other specific instances, databases, tables, and even individual indexes. Fragmentation Manager will also allow you to perform index defragmentation faster than ever before via support for multiple concurrent operations.
Download page: SQLSentry Plan Explorer
Release date: 2016-01-28
Support Version: 2008/2012/2014
Author: SQLSentry
Free version: Yes
Price: $295
With both a free and PRO version, Plan Explorer builds upon the graphical plan view in SQL Server Management Studio (SSMS) to make query plan optimization more efficient. It is a lightweight standalone app that contains many of the plan analysis features introduced in SQL Sentry v6, and does not require a collector service or database.
Download page: SQLSentry Event Manager
Release date: 2016-03-08
Support Version: 2008/2012/2014
Author: SQLSentry
Free version: No
Price: $995
With specific products for SQL Server, Windows, SharePoint and Oracle, Event Manager provides DBAs with "Outlook-style" visibility and functionality for managing SQL Agent jobs, Windows Tasks, and Oracle jobs in increasingly complex cross-platform environments. Unlike most other scheduling products, Event Manager does not require an agent to be installed and managed on each server.
Download page: SQLSentry Performance Advisor
Release date: 2016-03-08
Support Version: 2008/2012/2014
Author: SQLSentry
Free version: No
Price: ?
Performance Advisor is the unmatched solution for monitoring and managing all aspects of your SQL Server infrastructure. Monitor SQL Server and Analysis Services, Windows servers and VMware hosts. Support for Microsoft Analytics Platform System (APS), Azure SQL Data Warehouse, Azure SQL Database, and Amazon EC2 allows you to monitor your environment on every platform.
Download page: Dell Security Explorer
Release date: 2015-06-25
Support Version: 2008/2012/2014
Author: Dell
Free version: No
Price: $850
This single toolset maximizes productivity through extensive automation, intuitive workflows and built-in expertise. Plus, it complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage large numbers of databases. It also makes it easy to manage change, resolve issues quickly and promote the highest levels of code quality, performance and maintainability.
Download page: Dell Security Explorer
Release date: 2015-07-31
Support Version: 2008/2012/2014
Author: Dell
Free version: No
Price: ?
Dramatically reduce backup and restore times and minimize storage costs while increasing the reliability of SQL Server data protection operations across the entire enterprise. Easily manage and monitor SQL Server protection while delivering a wide array of recovery capabilities. With LiteSpeed, a complete workbench of SQL Server recovery tools are at your fingertips so you can get data back online — fast.
Download page: Dell Toad for SQL Server
Release date: 2015-05-12
Support Version: 2008/2008R2/2012/2014
Author: Dell
Free version: No
Price: ?
Use a single console to manage access controls, permissions and security across Microsoft platforms that span multiple servers. Security Explorer provides an array of security enhancements, including the ability to identify who has rights to resources across the entire organization. You can also grant, revoke, clone, modify and overwrite permissions quickly and from a central location. Unlike native tools, Security Explorer provides the ability to back up and restore permissions only, ensuring the integrity of data. Security Explorer provides on-the-fly reports to help meet auditing requirements.
Download page: Dell Spotlight
Release date: 2016-03-10
Support Version: 2008/2008R2/2012/2014
Author: Dell
Free version: No
Price: $2561
When you can diagnose SQL Server performance issues quickly and accurately, ensuring a healthy database infrastructure is not just possible, but easy. Spotlight on SQL Server Enterprise delivers simplicity without compromise by providing unmatched monitoring, diagnosis and optimization of your SQL Server environments, ensuring peak performance around the clock. With intuitive overviews of enterprise health and performance, automated alerts and actions, an integrated Xpert tuning module and mobile device support, Spotlight on SQL Server Enterprise makes it easier than ever to obtain the data you need to ensure the health of your SQL Server databases.
Download page: Dell Foglight
Release date: 2015-09-22
Support Version: 2008/2008R2/2012/2014
Author: Dell
Free version: No
Price: ?
Ensure optimal database performance with comprehensive database, storage and virtualization monitoring and advanced workload analytics. Foglight for Databases enables you to consolidate and standardize database performance management across your diverse multi-platform environments – even when you use native or third-party tools — to promote collaboration, improve service levels and reduce costs. Get a wealth of information at a fraction of the impact of conventional collection methods.
Download page: Dell Foglight
Release date: 2011-09-22
Support Version: 2008/2008R2/2012/2014
Author: Dell
Free version: Yes
Price: No
- Take inventory of your network databases, including data amounts
- Choose the databases you want to consolidate
- Review database history, including installation and creation dates
- Find the SQL Server versions and service packs currently deployed
- Identify names of servers, instances and operating systems
- Learn the identity of your end users
Download page: Dell Enterprise Reporter
Release date: ?
Support Version: 2008/2008R2/2012/2014
Author: Dell
Free version: No
Price: $511
Dell Enterprise Reporter for SQL Server provides ad-hoc reporting for visibility database security configuration, including users and logins, roles and database permissions
Download page: SQLSolutions SQL Deadlock Detector
Release date: 2013-05-16
Support Version: ?
Author: SQLSolutions
Free version: No
Price: $295
- Monitor and detect long-running locks and deadlocks 24/7
- Identify blocking SQL code, locked objects and deadlock victims with pinpoint accuracy
- Accelerate system response time by reducing long lock waits
Download page: SQLSolutions SQL Heartbeat
Release date: 2013-03-03
Support Version: ?
Author: SQLSolutions
Free version: No
Price: $295
- Unlock the value of a full SQL Server trace
- Quickly diagnose and identify all performance bottlenecks
- Locate within minutes specific SQL statements responsible for each bottleneck
- Proactively and constantly monitor performance through scheduled traces
Download page: SQLSolutions SQL Trace Analyzer
Release date: 2009-12-09
Support Version: ?
Author: SQLSolutions
Free version: No
Price: $495
Monitor your SQL Server 24 x 7 to remedy performance bottlenecks and maintain server health. SQL Heartbeat monitors all of your SQL Servers in a way that allows you to identify and prevent SQL Server problems before they happen. SQL Heartbeat allows for an unlimited number of custom counters to be defined. Important metrics often include: logins per second, lack waits per second, total latch wait time, deadlocks per second, errors per second, buffer cache hits ratio, page life expectancy, percent CPU utilization and average disk queue lengths. As default metrics have been set up by SQL Server experts, the initial setup step is minimal.
Download page: SQLSolutions SQL Ultimate Debugger
Release date: ?
Support Version: ?
Author: SQLSolutions
Free version: No
Price: $295
The sql server tool for developers who debug SQL server stored procedures, functions (UDFs) and triggers. This tool allows a developer to inspect values of ALL objects: simple variables, temporary tables, table variables and even permanent tables.
Download page: SQLScripter
Release date: 2013-02-24
Support Version: ?
Author: Thomas Hinsenkamp
Free version: No
Price: €99
Generate T-SQL data scripts quick and easy.
Download page: Simple Dynamic Scheduler
Release date: 2016-05-02
Support Version: 2008/2012/2014
Author: Miljan Radovic
Free version: Yes
Price: No
Simple Dynamic Scheduler is alternative scheduling utility which uses SQL Server to store all configurations and logic.
- Simple - Easy to manage (once you finish reading this page)
- Dynamic - Not static
- Purely T-SQL - says it all
- Open source - Adoptable code to suit your business needs
- Light-weight - Provides only decision machanism (Run or Hold) without actually executing anything
Download page: ApexSQL Audit
Release date: 2016-04-08
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $1699
- Audit all SQL database and security activities
- Meet compliance requirements e.g. HIPAA, PCI
- Out-of-the-box and custom Win and Web reporting
- Securely store audit data in a tamper-evident repository
- Fully customize all auditing, alerts, and reporting
- Who, what, where, and when type auditing
- Deploy on SQL Server Failover Clusters
- Easily manage auditing on multiple servers
Download page: ApexSQL Backup
Release date: 2015-12-30
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $499
- Manage SQL backups across multiple servers
- Configure SQL backup plans with advanced scheduling
- Increase productivity with backup templates
- Automatic SQL backup naming using variables
- Restore to a point in time directly from timeline
- Schedule and execute index maintenance tasks
- Log shipping to multiple destinations
- Cleanup SQL backup and restore history
Download page: ApexSQL Log
Release date: 2015-11-23
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $1999
- Audit data, schema, and permission changes
- Gain full visibility into your transaction logs
- Rollback or replay any database transaction
- Forensically investigate who changed what and when
- Implement before and after auditing
- View a complete history of row changes
- Reverse inadvertent or malicious database transactions
- Avoid performance overhead and data storage
Download page: ApexSQL Monitor
Release date: 2015-12-29
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $499
- Monitor multiple SQL Server instances
- View system performance metrics
- Identify performance issues and deadlocks
- Use comprehensive dashboard for viewing metrics
- Analyze query waits
- Review query execution plans
- Calculate baselines and thresholds
- Visualize data with logarithmic scaling
Download page: ApexSQL Recover
Release date: 2015-01-21
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $1999
- Recover deleted, dropped and truncated data
- Reverse inadvertent or malicious database changes
- Extract data directly from backup files
- Recover deleted data and files from SharePoint
- Recover deleted BLOBs
- Extract BLOBs stored as files
Download page: ApexSQL Restore
Release date: 2014-12-08
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $399
- Work with backups just like with live databases
- Mount backups to a specific point in time
- Speed up SQL database restores
- Access data and objects directly inside backups
- Attach backups directly from network drives
- Modify data without altering backup files
Download page: ApexSQL Build
Release date: 2015-12-22
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $399
Run scripts on multiple databases at once
- Create C# executables / .NET deployment packages
- Deploy databases directly from SQL source control
- Consolidate multiple SQL scripts
- Build databases from scripts
- source control
- etc
- Ensure error free deployments
- Preview the script impact by action or SQL object
- Execute scripts on saved list of servers/databases
Download page: ApexSQL Clean
Release date: 2015-09-04
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $399
- View and analyze SQL and client code dependencies
- Perform impact analysis on potential changes
- Remove unwanted objects risk free
- Map dependencies down to the column level
- Analyze external databases for dependencies
- View object dependencies graphically
- Design the appearance of the dependency diagram
- Create and export reports from object dependencies
Download page: ApexSQL Data Diff
Release date: 2015-12-11
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $399
Compare data in live databases and backups
- Perform row level recovery without restoring
- Community
- Standard
- and Professional editions
- Compare huge databases quickly and without errors
- Automate and schedule data migrations
- Initiate database compares directly from SSMS
- Export results to HTML
- XML and Excel
- Create executable .NET packages
Download page: ApexSQL Diff
Release date: 2016-03-23
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $399
- Compare live DBs, backups, scripts and SC projects
- Deploy a database directly from source control
- Integrate with all popular SC systems e.g. Git, SVN
- Automate and schedule database synchronizations
- Initiate database compares directly from SSMS
- Report results to HTML, XML and Excel
- Create executable .NET packages
Download page: ApexSQL Doc
Release date: 2015-04-19
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $299
Document SQL Server databases and SSIS packages
- Generate documentation in CHM, HTML, Word and PDF
- Automate and schedule the documenting process
- Display graphical relationship diagrams
- Document SSAS Multidimensional and Tabular models
- Document SSIS Control flow and Data flow diagrams
- Fully customize the documentation output
- Include Data model diagrams
Download page: ApexSQL Generate
Release date: 2016-03-15
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $499
- Generate SQL test data for specified tables
- Export test data to SQL, XML, CSV, JSON, Excel
- Generate millions of rows quickly
- Customize test data plan with detailed options
- Support a full range of SQL data types
- Choose from multiple generators (Random List etc)
- Retain data consistency with foreign key support
- Emulate real-world test data
Download page: ApexSQL Script
Release date: 2015-09-11
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $249
- Script both SQL database objects and data
- Create executable .NET packages
- Script objects directly to Source Control
- Automate SQL database scripting and migrations
- Integrate with popular source control systems
- Script an entire server down to individual columns
- Save customized scripting profiles as projects
- Easily decrypt some/all encrypted database objects
Download page: ApexSQL Trigger
Release date: 2015-09-04
Support Version: 2008/2012/2014
Author: ApexSQL
Free version: No
Price: $1999
- Track data / DML changes in SQL Server databases
- Integrate royalty free auditing into your apps
- Translate data into information with lookups
- Create reports and exports from audited data
- Customize trigger templates with a built-in IDE
- Add additional data to audit trail with watches
- Track schema / DDL changes in audited database
- Audit who, what, and when for all changes
Download page: DBBest T-SQL Analyzer
Release date: 2015-03-13
Support Version: 2008/2012/2014
Author: DBBest
Free version: No
Price: $89
T-SQL Analyzer is a code analyzing tool for finding problematic spots in your Transact-SQL code in SQL Server. The tool analyzes stored procedures and user-defined functions in your SQL Server database against a predefined set of best practice rules.
Download page: DBBest Database Compare Suite
Release date: 2015-09-04
Support Version: 2008/2012/2014/2016
Author: DBBest
Free version: No
Price: $349
Comparing two production databases for migrating or upgrading
Download page: Advanced Query Tool
Release date: 2015-03-18
Support Version: 2008/2012/2014/2016
Author: DBBest
Free version: No
Price: $180
AQT provides a simple and easy-to-use interface to your many different databases: Oracle, DB2 for LUW, DB2 for z/OS, DB2 for iSeries, Sybase ASE, SQL Server, Informix, MySQL, MS Access, SQLite, Other.
Download page: SqlDiffFramework
Release date: 2012-04-17
Support Version: 2008/2012/2014/2016
Author: Michael Sorens
Free version: Yes
Price: No
SqlDiffFramework compares two data sources and highlights both row and column differences for just the columns you want.
- Compare the same data over time (either current data vs. prior data or two snapshots of prior data)
- Compare the same data on two different servers
- Compare data from different systems (e.g. SQL Server vs. Oracle)
- Verify two systems have synchronized data
Download page: DataGrip
Release date: 2016-05-06
Support Version: 2008/2012/2014/2016
Author: Jet Brains
Free version: No
Price: $199
- Exploring your databases
- Intelligent coding assistance
- Executing queries
- Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features
Download page: SQL Nexus Tool
Release date: 2015-04-17
Support Version: 2012/2014
Author: Jack Li
Free version: Yes
Price: No
PSSDIAG is a diagnostics utility used to collect profiler trace, perfmon data for SQL Server. PSSDAIG was created to troubleshoot SQL Server 7.0 and 2000 issues. It was evolved and shipped with SQL Server 2005 and beyond. But the shipped product only has a data collector engine called sqldiag.exe. Microsoft Product support continues to maintain a configuration tool that allows engineers to dynamically configure on what to collect.
Download page: SQL Nexus Tool
Release date: 2014-05-06
Support Version: 2008/2012/2014/2016
Author: Jack Li
Free version: Yes
Price: No
SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag and Sqldiag Manager. It can dramatically reduce the amount of time you spend manually analyzing data
- Fast, easy data loading: You can quickly and easily load SQL Trace files;
- Visualize loaded data via reports
- Executing queries
- Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features
Download page: DBSophic Qure Profiler
Release date: ?
Support Version: 2008/2012
Author: DBSophic
Free version: No
Price: $300
SQL server trace analysis tool
- View SQL activity in real-time
- Group, sort and export batches
- Real time index recommendations
- Compare SQL traces
- No limitations on the number of SQL servers, databases, processors etc.
Download page: DBSophic Qure Profiler
Release date: ?
Support Version: 2008/2012
Author: DBSophic
Free version: No
Price: ?
The workload tuning solution that automatically optimizes millions of queries in one go
Download page: DBSophic Qure Profiler
Release date: 2015-01-15
Support Version: ?
Author: SQLServerUtilities
Free version: No
Price: $99
RestoreChecker is a utility that restores SQL Server backup files in order to verify that the backup files can be successfully restored and in addition perform data integrity checks on the backups restored while offloading the intensive IO activity from your production servers.
Download page: DBSophic Qure Profiler
Release date: 2009-08-24
Support Version: ?
Author: SQLServerUtilities
Free version: No
Price: $99
SQLScripter is a powerful command line utility that scripts SQL Server objects. The utility is designed to automate the process of schema generation.
Download page: SQLC
Release date: 2016-05-23
Support Version: ?
Author: David Ingleton
Free version: Yes
Price: No
SQLC is a software tool for comparing two SQL Server databases. With SQLC you can perform Object comparison (Database schema) as well as Data comparison (Table data)
Download page: Database Performance Analyzer
Release date: ?
Support Version: ?
Author: SolarWinds
Free version: No
Price: $1995
Monitor across your entire environment: physical servers, virtualized, and in the Cloud
Download page: SQL Enlight
Release date: 2016-04-25
Support Version: 2005/2008/2008R2/2012/2014
Author: UbitSoft
Free version: No
Price: $295
- Advanced static analysis
- T-SQL code formatting
- Statements history
- Validate T-SQL code for syntax errors
- Script Summary
- Refactoring
- Continuous integration support
Download page: OmniCompare
Release date: 2016-06-03
Support Version: ?
Author: AireForge
Free version: Yes
Price: No
The first Aireforge product is now in beta. OmniCompare is a SQL Server configuration comparison tool which compares instance settings, users, permissions, jobs, linked servers and more.
Download page: HexaTier
Release date: ?
Support Version: ?
Author: HexaTier
Free version: No
Price: ?
Providing an all-in-one solution to protect your data from internal and external attacks with four key elements, including: Database Security, Discovery of Sensitive Data. Dynamic Data Masking, and Database Activity Monitoring to comply with regulatory requirements.
Download page: SoftTree SQL Assistant
Release date: 2016-03-18
Support Version: 2005/2008/2008R2/2012/2014/2016
Author: SoftTree
Free version: No
Price: $270
- Triples SQL developer productivity
- Improves code quality and accuracy
- Provides unmatched intelligent SQL code intellisense features
- Provides interactive SQL reference and SQL code assistance systems
- Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more...
Download page: EMS SQL Management Studio
Release date: 2016-05-26
Support Version: 2000/2005/2008/2008R2/2012/2014
Author: EMS Database Management Solutions
Free version: No
Price: $257
EMS SQL Management Studio for SQL Server is a complete solution for Microsoft SQL Server database administration and development. With components that focus on all critical MS SQL Server database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering SQL Server databases, managing database schema and objects as well as for SQL Server database design, migration, extraction, SQL Server query building, data import, export and database comparison. SQL Studio unites these database tools for MSSQL Server in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or business analyst, SQL Studio for SQL Server offers all essential SQL Server tools to make you more productive than ever before!
Download page: EMS SQL Backup
Release date: 2016-04-13
Support Version: 2000/2005/2008/2008R2/2012/2014
Author: EMS Database Management Solutions
Free version: No
Price: $82
EMS SQL Backup for SQL Server is an effective tool for automating backup, restore and log shipping tasks on all SQL Servers in your company. In addition, SQL Backup allows you to update statistics, perform re-indexing, truncate database, check database integrity and perform many other tasks that can be united into policies and deployed to SQL Servers in a few clicks. SQL Backup monitors the maintenance task execution, quickly investigates and resolves issues.
Download page: EMS SQL Administrator
Release date: 2015-04-14
Support Version: 2000/2005/2008/2008R2/2012/2014
Author: EMS Database Management Solutions
Free version: No
Price: $135
EMS SQL Administrator for SQL Server is a toolset for efficient SQL Server administration. It provides a complete and easy-to-use set of tools for administering SQL Server. SQL Administrator is designed specifically for database administrators and allows you to perform administrative tasks in the fastest, easiest and most efficient way.
Download page: EMS SQL Manager
Release date: 2016-05-26
Support Version: 2000/2005/2008/2008R2/2012/2014
Author: EMS Database Management Solutions
Free version: No
Price: $135
EMS SQL Manager for SQL Server is a high performance graphical tool for Microsoft SQL Server database development and administration. It makes creating and editing MS SQL Server database objects easy and fast, and allows you to run SQL scripts, manage SQL server users and their privileges, build SQL queries visually, work with metadata, export and import SQL Server database data and much more.
Download page: EMS Data Export
Release date: 2016-04-29
Support Version: -
Author: EMS Database Management Solutions
Free version: No
Price: $47
EMS Data Export for SQL Server is a powerful tool to export SQL Server database data quickly to any of 20 available formats, including MS Access, MS Excel, MS Word, RTF, HTML, TXT, ODF and more. Data Export for SQL Server has a friendly wizard, which allows you to set various options of SQL Server export process visually and a command-line utility to automate your SQL Server export jobs using the configuration file.
Download page: EMS Data Import
Release date: 2016-04-14
Support Version: -
Author: EMS Database Management Solutions
Free version: No
Price: $47
EMS Data Import for SQL Server is a powerful tool to import data to SQL Server tables from MS Excel 97-2007, MS Access, DBF, TXT, CSV, MS Word, RTF, ODF and HTML files. This utility allows you to quickly import data to one or several SQL Server tables or views at once, save all SQL Server import parameters set on current wizard session, use special batch insert mode to import SQL Server data at the maximum possible speed and much more.
Download page: EMS Data Pump
Release date: 2016-11-03
Support Version: -
Author: EMS Database Management Solutions
Free version: No
Price: $47
EMS Data Pump for SQL Server is an excellent migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MySQL or any other database with ADO support) to SQL Server databases. Database conversion and migration become as easy as possible with Data Pump for SQL Server!
Download page: EMS Data Generator
Release date: 2010-07-10
Support Version: -
Author: EMS Database Management Solutions
Free version: No
Price: $47
EMS Data Generator for SQL Server is an impressive tool for generating test data to SQL Server database tables. The utility can help you to simulate the database production environment and allows you to populate several SQL Server database tables with test data simultaneously, define tables for generating data, set value ranges, control a wide variety of generation parameters for each field type and much more. It has plenty of powerful functionalities to generate SQL Server test data in a simple and direct way.
Download page: EMS DB Comparer
Release date: 2015-07-24
Support Version: -
Author: EMS Database Management Solutions
Free version: No
Price: $47
EMS DB Comparer for SQL Server is an excellent tool for comparing SQL Server database schemas and discovering differences in their structures. You can view all the differences in compared database objects and execute an automatically generated script to synchronize structure of SQL Server databases and eliminate these differences. Define comparison parameters and many other features make your work with our tool for SQL Server database synchronization easy and fast.
Download page: EMS DB Extract
Release date: 2008-10-16
Support Version: -
Author: EMS Database Management Solutions
Free version: No
Price: $47
EMS DB Extract for SQL Server is an impressive and easy-to-use tool for creating SQL Server database backups in a form of SQL scripts. This database script utility allows you to save metadata of all SQL Server database objects as well as SQL Server table data as database snapshots. Flexible customization of the extract process enables you to select objects and data tables for SQL Server database dump and tune many other extract options.
Download page: EMS SQL Query
Release date: 2012-03-29
Support Version: -
Author: EMS Database Management Solutions
Free version: No
Price: $47
EMS SQL Query for SQL Server is a useful tool that lets you quickly and simply build SQL queries to SQL Server databases. Visual SQL Server query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to SQL Server databases, select tables and fields for a query to SQL Server, set the selection criteria and many more.
Download page: EMS Data Comparer
Release date: 2012-11-16
Support Version: -
Author: EMS Database Management Solutions
Free version: No
Price: $47
EMS Data Comparer for SQL Server is a powerful and easy-to-use tool for SQL Server data comparison and synchronization. Using this utility you can view all the differences in compared SQL Server tables and execute an automatically generated script to eliminate these differences. Data Comparer for SQL Server provides a wide range of configuration parameters for fast and effective data comparison and synchronization of SQL Server databases.