HomeSydney, 10th May 2005 ' TASC have released SQL Delta version 3.1, a high performance SQL schema and data comparison tool for analysis and synchronization of databases.
Version 3.1 of SQL Delta offers the following new feature and improvements and is available now http://www.sqldelta.com
COMMAND LINE FUNCTION
A powerful command line script processor has been introduced to SQL Delta 3.1. The script processor provides the user with a mechanism for controlling SQL Delta by remote control, allowing databases to be compared and changes scripted without any user intervention. The script language is standard XML and provides a variety of commands for configuring and controlling SQL Delta. In addition to the standard comparison and script functions the user can export reports in various formats including HTML format and then have those reports automatically emailed to the appropriate user. Even scripts can be emailed as attachments if a change is detected in the database.
'We have designed the script processor to provide users, especially DBA's, with the convenience of programmatic style control of SQL Delta without the need to dig out a compiler and build an application. Even so a programmer can very easily create a seamless execution of SQL Delta from within their own application if they desired' Jay Bailey ' SQL Development Manager.
Owner Mapping
SQL Delta 3.1 now provides object ownership mapping and now it is possible to perform comparisons between databases with different users and different ownership configurations. The user can map on a user to user basis or a many to one user basis and there is no limit to the number of users that can be mapped.
Other New Features
Improved tools such as 'star view' checking to ensure all views that may use 'select * ..' are up to date and a qualify names tool for checking to see if stored procedures include qualified names, therefore ensuring the best performance from your server.
About the author: Founded in 1991, The Australian Software Company (TASC) is an Information Technology solutions provider developing customer orientated applications. Over the past years we have developed a vast range of software applications