Fast Guide: Free SQL Server tools

This list of free SQL Server tools will help reduce your workload, streamline maintenance and improve the performance of your databases.

As a SQL Server DBA or developer, you have many routine tasks that can often take up more time and energy than you'd like to admit. This collection of free tools will help automate some of those repetive database tasks. For our complete collection of tools, visit our Windows IT Downloads Library.

Working with a great SQL Server tool or script? Tell us about it and we'll enter you to win a new SQL Server DBA or developer book.

TABLE OF CONTENTS
Backup and recovery
Database development
Database administration and monitoring

        

  Backup and recovery  Return to Table of Contents

  • Download: SQL Backup
    SQL Backup creates smaller, safer, faster backups of SQL Server databases.

  • Download: TimeData
    TimeSpring's TimeData continuous data protection (CDP) software allows SQL Server 2005 Customer Technology Preview (CTP) users to test and migrate real-time production data from SQL Server 2000 without shutting down, slowing down or exporting data.

  • Download: LiteSpeed 2005
    LiteSpeed is advanced backup and recovery software for Microsoft SQL Server 7, 2000 and Yukon that provides integrated high performance compression technology.

    •   Database development  Return to Table of Contents

  • Download: DDL Archive Utility
    The DDL Utility is a freeware utility that lets a database programmer create SQL Server 2000 DDL scripts that can be imported into a Microsoft Visual SourceSafe repository.

  • Download: PromptSQL
    PromptSQL is an add-on application that provides auto-complete functionality as you type for programs used to create SQL statements. It works with QA, UltraEdit32, Visual Studio.NET 2003, Visual Studio 2005 and SQL Server 2000 Enterprise Manager.

  • Download: TOAD for SQL Server
    TOAD for SQL Server improves the productivity of developers and administrators by providing an easy-to-use database and T-SQL code development environment.

    •   Database administration and monitoring  Return to Table of Contents

  • Performance tuning freebies to add to your favorites
    You may already be working with the typical SQL Server performance tuning tools, but are you using all the features available in each tool? Don't miss out on these must-have tools.

  • Download: SQLPing
    SQLPing can be used to discover detailed information about the connectivity of SQL Server 2000 installations without authentication of any kind

  • Download: Apex SQL Report
    SQLPing can be used to discover detailed information about the connectivity of SQL Server 2000 installations without authentication of any kind

  • Download: SmartDBA Cockpit
    SmartDBA Cockpit is an interactive database productivity tool that allows data base administrators to manage their enterprise databases from any computer with an Internet browser.

  • Download: SQLcheck
    SQLcheck investigates, organizes and explains critical diagnostic information about your server's hardware, operating system and SQL Server.

  • Download: SQLcheck
    SQLcheck investigates, organizes and explains critical diagnostic information about your server's hardware, operating system and SQL Server.

  • Download: myLittleAdmin For SQL Server
    myLittleAdmin for SQL Server is a web-based SQL Server and MSDE Database administration tool. It is intended to handle the administration of SQL Server and MSDE databases over the WWW. It allows you to fully manage your databases even when you don't want or cannot use MS Enterprise Manager.

  • Download: Transaction Manager
    Transaction Manager is a long transaction handler designed for Microsoft SQL Server 2000. The Gnosis Transaction Manager can perform long transactions of virtually unlimited duration, size and complexity.

  • Download: Teratrax Performance Monitor
    Teratrax Database Manager enables you to manage all versions and editions of SQL Server from one interface.

    • This was first published in November 2005

    Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

    Pro+

    Features

    Enjoy the benefits of Pro+ membership, learn more and join.

    0 comments

    Oldest 

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to:

    -ADS BY GOOGLE

    SearchBusinessAnalytics

    SearchDataCenter

    SearchDataManagement

    SearchAWS

    SearchOracle

    SearchContentManagement

    SearchWindowsServer

    Close