SQL Server Tools
IT Database professionals (database administrators, sql developers, Business Intelligence developers, report builders) require SQL Server tools for :
SQL Database Management Tools
Data Modeling Tools
SQL Monitoring Tools
SQL Tracing Tools
SQL Auditing Tools
Optimizing / Optimization Tools
Building SQL Jobs
Business Intelligence Tools for developing Business Intelligence applications
DTS Converting and DTS Migration Tools
Data Importing Tools and Data Exporting Tools
Data Transformation – ETL Tools
SQL / T-SQL Rapid Development Tools
SQL Formatter (SQL Formatting Tools)
SQL Server Query Tool
SQL Backup Tools
Deployment Tools for deployment of database objects like script deployment, sql job deployment
dealing with high number of servers
Compare Database Schemas and SQL Database Objects
Script Data in Database Tables
Building Reports / Report Development
Intellisense or Autocomplete in SQL Editor
Documenting SQL Objects or Database Documentation
In this list of tools for SQL Server in which users can find sql tools download links from the product developers and software vendors. There are hundered and thousand of tools out there but most of DBA used this tool.
SQL Server Management Tools
EMS SQL Management Studio for SQL Server
SQL Management Studio for SQL Server provides a complete package for all common SQL Server tasks for database administrators and developers.
DBArtisan is a database administration tool from Embarcadero which aims the maximum availability, performance and security of databases including MS SQL Server DBArtisan provides powerful GUI editor and wizards for DBSa in order to speed routine tasks while minimizing errors for increades productivity.
EMS SQL Manager for SQL Server
EMS SQL Manager for SQL Server is a MS SQL Server administration and database development tool.
Discovery Wizard for SQL Server from Quest Software.
Quest Software is being developing a very useful and handy tool for SQL Server administrators. The SQL tool is in Beta phase and MS SQLServer administrators can download free.
This SQLServer tool enables administrators to gather information about the SQL Server installations in their network.
And what makes this tool unique is that SQL admins can see the users and the network traffic connecting to those MS SQL Server instances and watch this traffic within a period of time.
A must tool for SQL Server administrators especially for those administrators that are new in the company and want to get a summary of the existing MS SQL Server instances in their company network.
Tools for SQL Server – Database Desing and Data Modeling Tools
Embarcadero ER/Studio is a data modeling tool enables database designers document and re-use data assets. ER/Studio enable database desingners reverse engineering so making it easier to analyze and optimize existing SQL Server databases. BI-Tools.
Embarcadero Schema Examiner
Schema Examiner can be used to validate database design errors, and find out schema errors. Schema Examiner prepares sql scripts for resolving the found schema problems.
Schema Examiner can be used to identify problems like missing relationships between sql tables, or incorrect relationships, disabled triggers, required missing indexes on sql tables, etc.
Tools for SQL Server – SQL Monitor and Database Monitoring Tools
SQL Response is a sql monitoring tool SQL Server administrators require much. SQL Response monitors the health of the SQL Server instance and the activity on the server. Administrators can build alerts for notification of problems when they occur on the server. It is easy to monitor sql deadlocks, blocking processes or problems like long running and resource consuming queries.
Zero Impact Sql Monitor
Zero Impact SQL Monitor is an other tool for SQL Server that is used as database monitoring tools. Zero Impact SQL Monitor enables database administrators to monitor performance of their SQL Server database systems without any affect.
SecureSphere Database Activity Monitoring
SecureSphere Database Activity Monitoring is a compact tool for major databases like SQL Server for sql monitoring, auditing and reporting.
SQL Server Tools to Compare Schema
SQL Compare can be used to compare schemas of two different databases and synchronize SQL database schemas of the sql databases by DDL sql commands. SQL Compare can especially be used between development and test databaases or test and production databases.
DB Comparer for SQL Server
EMS DB Comparer for SQL Server compares SQL Server databases and finds schema differences between sql databases.
DB Comparer for SQL Server prepares sql scripts that can be used to eliminate the database schema differences between SQL Server databases and synchronizing sql database structures.
dbForge Schema Compare for SQL Server
dbForge Schema Compare for SQL Server is used for schema comparison and synchronization between different sql databases. dbForge Schema Compare enables analyze the differences in database structures of development, test and production databases environments. It can build scripts and propagate the desired modifications to a target SQL Server database.
SQL Server Tools Compare Data and Data Synchronization
Data Sync is a data compare and data synchronization tool. An important feature of Data Sync tool from Spectral Core is that Data Sync can compare and synchronize data between two different database servers.
SQL Data Compare
SQL Data Compare is a handy tools for SQL Server professionals in order to compare data in sql tables and if required synchronize SQL database contents by generating sql DML scripts like insert, update or delete.
dbForge Data Compare for SQL Server
dbForge Data Compare for SQL Server enables database workers for easy data comparison and synchronization between different SQL Server databases.
SQL Comparison SDK
SQL Comparison SDK supplies developers an API for reaching Data and Schema comparison tools of Red Gate.
Data Comparer for SQL Server
EMS Data Comparer for SQL Server is a powerful data compare and synchronization tool. Data Comparer for SQL Server can create automatic scripts for eliminating data differences between SQL Server database tables.
SQL Server Backup Tools – SQL Backup and SQL Server Backup Compression Software
SQL Server professionals can find more related information on sql backup compression at SQL Backup Compression Default Option in MS SQL Server 2008 sp_configure Command.
They can also refer to SQL Server Backup Compression Software for more detailed review of SQL Server backup compression software and SQL Server tools for sql backup compression.
SQL Backup from Red-Gate is a complete sql tool to compress, encrypt and monitor SQL Server backups for SQL Server administrators.
LiteSpeed for SQL Server
One of the SQL Server tools of Quest Software company is the SQL Server Backup and Recovery Tool “LiteSpeed for SQL Server”. LiteSpeed offers secure encrypted backups and fast sql backup compression method for saving from sql backup time and backup storage space. It is also possible using LiteSpeed Backup and Recovery Tool for SQL Server to restore individual database objects. You can also download a 15 day free evaluation and free trial download of this SQL Server Backup and Recovery tool.
For a detailed review on LiteSpeed please refer to LiteSpeed Backup SQL Server Backup Compression Tool.
Task Automation Tools for SQL Server
DB Mail is an automation tool not for sending e-mails from most common databases but can manage automation of sending e-faxes, SMS and cell phone messages, etc. DB Mail is a perfect tool for automating messaging needs of a database application.
Tools for SQL Server Development
Rapid SQL from Embarcadero is a tool for database and application developers which can be used to produce high quality SQL code faster. Rapid SQL supports team work environments that will boost the outcome of teams. Rapid SQL easies sql coding and source code control, database object management, reverse-engineering and deployment of a database schema.
Rapid SQL also supplies profiling tools for application and sql developers.
One of the SQL Server tools that I have found very interesting as well as very useful is the SQL Sets from PrimalBits Software. SQL developers and test teams can create snapshots of data that will be affected during tests before starting the test. After the test is completed sql developers and test team members can create the same snapshot with new data that are changed during the test processes. Comparing two data sets it will be easier to understand what has happened and what went wrong during tests.
SQL Sets also enables SQL users to create Portable Data Documents which are query based data which can be saved and shared between collaborating teams and members. Users can add annotations into portable data documents to highlight important issues related with data. One additional feature of SQL Sets SQL Server tool is SQL developers and SQL Server administrators can easily export sql data in various formats. Developers interested in SQL Sets tool can download the 14-day free trial version from product download page.
SQL Multi Script
SQL Multi Script enables deployment of multiple sql scripts to multiple MS SQL Servers by executing each script on each database with a single click in this tool. SQL Multi Script easies database management tasks on multi servers for administrators. Developers can query multi databases parallel and aggregate results of their queries in case of need.
SQL Assistant is a SQL Server tool from SoftTree Technologies. In fact database developers can this database development tool not only for SQL Server but for Oracle, DB2, MS Access, MySQL, etc. Code snippets, SQL syntax check, format code, refactoring, test data generation, unit test, compare code are all very useful features of this SQL Server tool.
SQL Refactor can be used by sql programmers for refactoring and formatting sql code in their work.
SQL Prompt enables intelligent code completion known as intellisense for sql developers to be used on SQL Server query editors.
SoftTree SQL Assistant
SoftTree SQL Assistant enables a high code quality and accuracy with increased speed in database development and sql coding for database administrators and developers.
DatabaseSpy is a multi-database query editor which enables sql developers to work on one query editor tool on all common databases. DatabaseSpy is also a database design tool for sql administrators.
EMS Advanced Query Builder
EMS Advanced Query Builder is an sql query editor tool in order to build sql statements like Select, Insert, Update and Delete. Query Builder tool has the advantage to work with major databases and with its visual GUI building sql statements is easier without any knowledge of SQL.
EMS SQL Query for SQL Server
EMS SQL Query for SQL Server is a sql query editor tool with a visual editor interface as well as the text query editor. SQL query editor tool also displays query execution plans for t-sql developers.
Toad for SQL Server, SQL Server Management and Development Tool-Set for SQL Administrators and SQL Developers from Quest Software. The development tool for SQL Server “Toad for SQL Server” brings the power of MS Visual Studio and SQL Server Management Studio (SSMS) together and makes it easy for DBA ‘s and developers their daily tasks.
For example, comparing schemas and synchronizing schemas. Also data compare and synchronization is made easier. It is possible to run an SQL script on more than one instances so developers can work on multiple SQL Server instances using the Toad for SQL Server. Besides these, managing SQL Server jobs is an additional feature for this SQL Server tool.
SQL Server Tools – Test Data Generator
SQL Data Generator
Red-Gate SQL Data Generator is a SQL Server tool for developers or testers in order to ease production development stages with automatically populating sql databases with realistic test data. You can refer to tutorial Create Test Data using SQL Data Generator as an example on this tool.
Data Generator for SQL Server
Data Generator for SQL Server can be used by database testers and application programmers to generate test data for MS SQL Server database tables. There is also a tutorial for Creating test data using EMS Data Generator for SQL Server as an example on this sql data generation tool.
Datanamic DB Data Generator
Database developer can use DB Data Generator as a SQL Server tool for creating meaninful test data in order to test their applications. One of the features of DB Data Generator is that it can use a well enough mask for string values while generating test data. If you want more information on this tool please read my review at SQL Data Generator – Generate Test Data for SQL Server Using Datanamic DB Data Generator Tool.
SQL Server Tools for Documentation
SQL Doc is a handy documentation tool for sql developers who wants to document their databases. SQL Doc can create database documentation from database schema and build descriptions for database objects like tables, views, and even for columns. Documentation includes internal or external database dependencies for the related database objects.
Developers can build database documentation in HTML format or MS Word format.
Document! X 2008
Document! X documentation tool helps admins and developers creating and maintaining the documentation of databases including MS SQL Server.
Documenter for SQL Server
Documenter for SQL Server enables SQL Server database administrators prepare a full documentation of their databases covering all of the database objects. DBAS can prepare quickly cross-linked HTML documentation or Windows Help File (in CHM format) documentation of all database objects by parsing database properties.
SQL Server References
SQL Safari is a reference resource for SQL Server administrators and sql developers. SQL Safari enables full access to most appretiated SQL Server books from Safari Books Online
SQL Server Database Schema Management Tools
SQL Packager tools is used to package and compress schema and the database contents of a SQL Server database.
SQL Server Log Management Tools
SQL Log Rescue
SQL Log Rescue is log analysis tool which IT professionals can use for viewing details in SQL Server logs and information on database transactions. DBAs can also use SQL Log Rescue records in order to get lost data back in case you have accidentally delete, or modify data in a database.
SQL Audit Tool
DB Audit Expert
DB Audit Expert is a professional sql auditing tool for SQL Server. System, database and security administrators as well as auditors can use DB Audit Expert as an sql audit tool.
DB Audit Expert enables tracking and analyzing database activity about database security, data access and usage, data creation, data updates or data deletion.
SSW SQL Auditor
SSW SQL Auditor or SQLAuditor is a tool for big development teams to ensure Quality Assurance. Database designers can trace if best practice standards are applied to the SQL Server application by running SQL Auditor. SQL Auditor sql audit tool can be assumed as the FxCop for SQL Server development teams. This tool can find database desing problems and fix them, can identify sql naming problems, can find missing relations, missing primary keys, foreign keys, etc.
Lumigent Audit DB
Audit DB is a sql auditing software package from Lumigent. Audit DB is a perfect solution for data auditing and security policy management. SQL Server database administrators can easily detect unauthorized access to data and can follow privileged database users activity. Security administrators can publish security policies and can ensure and control that the security policy management is working successfully. One more important feature of the Lumigent Audit DB sql auditing software is that it comply with data protection and data security regulations like 21CFR11, Basel II, HIPAA, PCI, SB1386, Sarbanes-Oxley, etc.
ApexSQL Audit is an sql auditing tool from Apex. It can track DML statements and save audit data into an other seperate SQL database.
ApexSQL Audit tool has also command line support.
OmniAudit SQL Server Auditing tool is easy to install and easy to use sql audit tool. By activating OmniAudit on any database, table and field, database administrators can identify which field in which table has been altered by which user. SQL auditing tool also reports before update and after update data values as well as change time. OmniAudit also fullfills the Compliance Requirements of regulations like FDA Part 11, HIPAA, PCI-CISP, Sarbanes-Oxley, etc.
Business Intelligence Tools (BI Tools)
PrismCubed enables developers and database professionals build business intelligence applications within short periods of time. PrismCubed provides ETL (Extract – Transform – Load) functions with huge amounts of data. Provides a simply interface for users to filter data, analyze data and visualize data.
DTS xChange is one of the most searched tools in the market which convert DTS packages to SSIS 2005 or SSIS 2008 packages. The Business Intelligence tool DTS xChange from Pragmatic Works Software can successfully migrate existing SQL Server 2000 DTS packages to new SQL Server Integration Services SSIS packages. A very little manual work is left to SQL BI developers after DTS xChange is used for migration DTS packages.
Your opinion, suggestions and comments are highly appreciated.
SQL – SPS DBA, MCTS