DATABASE MANAGEMENT
Update Tables
Laplas Soft announced SQLExecMS, a database-administration tool that supports SQL Server 2000 and 7.0. You can use the software to view and update data in your tables by using a grid or a field-by-field presentation. You can execute T-SQL statements by using the tool's syntax editor and code assistance feature. SQLExecMS lets you view index fragmentation in graph and text mode. The software also lets you generate SQL scripts to manage table data, users, and roles. Contact Laplas Soft at master@laplas-soft.com or http://www.laplas-soft.com.
Compare and Synchronize Database Schemas
e-dule Software announced DB SynchroComp 2.0, a tool for SQL Server that compares and synchronizes two database schemas. The software generates scripts that change the target database structure to match the source database structure. DB SynchroComp determines differences in functions and stored procedures by comparing the text of procedures. The software shows the results of database schema comparison hierarchically by displaying dependent objects below their parents. DB SynchroComp supports SQL Server 2000 and 7.0. Pricing is $499.95. Contact e-dule Software at office@e-dule.com or http://www.e-dule.com.
Clean Up Objects
LockwoodTech Software announced SQLClean 2.0, software for SQL Server 2000 and 7.0 that can help you determine which tables and views in your database you're using. SQLClean also analyzes the database to see what internal references exist between objects, then generates a file of SQL DROP statements to clean your database of useless objects. You can create file-search patterns to analyze all the files of a particular language or project. SQLClean is part of the SQL Developer Pack, which also includes Proc-Blaster, Auto-Audit, and Auto-Inserts. For pricing, contact LockwoodTech Software at sales@lockwoodtech.com or http://www.lockwoodtech.com.
DEVELOPER TOOL
Understand How Your Application Interacts with the Database
Compuware announced DevPartnerDB 4.1 for Microsoft SQL Server, an application-development tool for building, debugging, and monitoring stored procedures. To better understand how your application interacts with the database, you can perform proactive debugging of T-SQL within the context of your application. The latest release features enhanced XML support and implementation to give you a smooth transition to SQL Server 2000. The tool lets you control program execution and modify program variables. DevPartnerDB supports SQL Server 2000 and 7.0 and costs $800. Contact Compuware at 248-737-7300 or http://www
.compuware.com.