Fast Guide: Free SQL Server tools

Fast Guide: Free SQL Server tools

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,

    Requires Free Membership to View

    Login

    When you register, you’ll also receive targeted emails from my team of award-winning editorial writers.  Our goal is to keep you informed on the hottest topics and biggest challenges faced by today's SQL Server database pros.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSQLServer.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSQLServer.com is governed by our Terms of Use. You may contact us at [email protected].

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

    Back to top