Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Mar 27, 2007

SQL Professional Toolbelt

By Steven Warren

Are you a SQL Server DBA that wants to streamline work? Or maybe you are a Network Engineer that just inherited SQL Server tasks to do your job. If you are new or a seasoned veteran, there are specific tools available to help you with your day-to-day SQL Server tasks. RED Gate Software recently released a new service called SQL Professional Toolbelt, a compilation of all of their tools for an annual subscription. You can compare it to a Microsoft MSDN or Technet subscription where all the software is free to you for one year. As a SQL Professional Toolbelt subscriber, you have access to all of their current and new tools for one price. The annual subscription which includes 12 months of support and upgrades, is $1,995 and renewals are $995.

"SQL Professional Toolbelt is like tapping into the entire contents of our developer's brains as they turn out the tools you need to get the job done," says Simon Galbraith, joint CEO of Red Gate. "There are three major benefits to this subscription. First, it's astonishingly good value. Second, the one-off annual payment greatly simplifies purchasing. Third, it gives SQL DBAs and developers access to the preferred tools they need right now – not in a month's time after the purchase order has been approved. It's in the nature of the DBA role that you have to deal with live issues quickly and get it right the first time. SQL Professional Toolbelt gives flexibility, speed and confidence."

With this annual subscription, the following products are available to you: SQL Compare, SQL Data Compare, SQL Packager, SQL Backup, SQL Doc, SQL Toolkit, SQL Dependency, SQL Log Rescue, SQL Refactor, SQL Prompt, and 12 months support for their products which includes upgrades.

Let’s provide you with a brief overview of these products.

SQL Compare allows you to compare and synchronized the structure of your SQL Server databases (database schemas). With this product, you choose the databases that need to be compared and then review the differences. Once that is complete, you can create a script to “synch” the databases together. You can even choose the direction in which you want the data synchronized. A close relative of SQL Compare is SQL Data Compare. This tool allows you to keep your data in production, development, and disaster recovery databases in “synch.”

Do you have a need to deploy databases on a regular basis? If so, SQL Packager allows you to deploy databases by themselves or as a part of any .Net applications that you use. One of my favorite tools is SQL Backup. Simply stated, it allows you to encrypt and compress your database backups.

With SQL Doc you can connect to a database(s) and output documentation in an HTML format. It enables you to quickly access an overview of your database, including schema and dependencies. SQL Doc Pro comes with a command-line interface. Any DBA that needs to produce documentation quickly can benefit from this tool.

The SQL Toolkit compares and synchronizes databases' schema and data. By giving you access to the APIs and command-line utilities you can automate your SQL comparison and synchronization tasks.

SQL Dependency Tracker allows you to dynamically explore all your database object dependencies, using a range of graphical layouts. You can analyze very large Microsoft SQL 2000 and SQL 2005 databases and produce diagrams for all of your database changes.

SQL Log Rescue is a safety net for SQL Server databases. It is used for identifying transactions that have damaged a database, recovering a damaged database without any downtime or data loss, understanding demands on a database in terms of numbers of transactions, rate of data change, volume of users etc, protecting your data in the event of mistakes or accidents and so on.

SQL Refactor allows you to automatically format your SQL code and database objects in the style of your choice. SQL Refactor improves the quality of your code, making it easier to read, understand and share amongst a team.

SQL Prompt provides IntelliSense-style auto-completion for Microsoft SQL Server editors. It will tell you the exact formatting you should use for your SQL commands, while you are writing them, and will therefore help you write fast, perfectly formatted SQL statements. SQL Prompt improves the productivity of all SQL script creation.

About Red Gate Software

“Since 1999, Red Gate Software has been developing ingeniously simple tools that simplify the business of working with SQL Server and .NET. Our tools, which include SQL Compare, SQL Backup and ANTS Profiler, have become industry standards for developers and DBAs worldwide.” Red Gate is a Microsoft Gold Visual Studio .NET launch partner and a VSIP partner.

Download a 2 week free trial of SQL Professional Toolbelt form Red Gate’s web site and see their tools first hand.

» See All Articles by Columnist Steven S. Warren

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM