Overtaxed DBAs Get Relief

By Brian Fonseca  |  Posted 2003-12-15 Print this article Print

SQL tool developers upgrade their offerings.

SQL tool developers Adept SQL Tools, ApexSQL and Red Gate Software Ltd. are upgrading their respective wares to help database administrators avert programming mishaps and clean up the clutter in production and testing environments using Microsoft Corp.s SQL Server database.

Adept SQL last week released Version 1.5 of AdeptSQL Diff, which features new capabilities to compare database schemata and data in tables in a unified offering. The update adds support for object and statement permissions in SQL Server.

Other notable enhancements in AdeptSQL Diff 1.5 include a redesigned options dialog for more flexible configuration and an OLE automation interface to manipulate a comparison programmatically from any language supporting ActiveX, said officials at Adept SQL, in Limassol, Cyprus.

On a similar note, ApexSQL, of Chapel Hill, N.C., will release ApexSQL Diff 3.x by months end. Enhancements include a full, scriptable object model embedded in the tool, exposing the metadata model to users. The update bolsters the softwares batch/command-line interface and offers new differential analysis reports, officials said.

For its part, Red Gate early this month announced its SQL Comparison and Synchronization Toolkit Version 3.0. The software was rebuilt to accommodate Microsoft .Net and to simplify the creation of automated programs that compare and synchronize SQL Server database structures, according to officials at the Cambridge, England, company.

A new tool kit API in Version 3.0 allows developers and database administrators to identify and push out object changes and respond to migration needs along different database development stages, officials said.

Minimizing lost productivity is fast becoming a significant priority for overburdened DBAs. John Allman, senior database administrator for American Medical Security Group Inc., in Green Bay, Wis., said he uses Red Gate technology to institute change management scenarios between database testing and production stages.

"It keeps us honest and saves a lot of headaches [instead of doing] that manually and helps us occasionally find differences pretty readily," said Allman.

Brian Fonseca is a senior writer at eWEEK who covers database, data management and storage management software, as well as storage hardware. He works out of eWEEK's Woburn, Mass., office. Prior to joining eWEEK, Brian spent four years at InfoWorld as the publication's security reporter. He also covered services, and systems management. Before becoming an IT journalist, Brian worked as a beat reporter for The Herald News in Fall River, Mass., and cut his teeth in the news business as a sports and news producer for Channel 12-WPRI/Fox 64-WNAC in Providence, RI. Brian holds a B.A. in Communications from the University of Massachusetts Amherst.

Submit a Comment

Loading Comments...
Manage your Newsletters: Login   Register My Newsletters

Rocket Fuel