Innovartis Ltd have just launched DB Ghost version 3.0, an end to end database change management solution for SQL Server users.

Innovartis Ltd have just launched DB Ghost version 3.0, a complete end-to-end database change management solution for SQL Server users, that builds and deploys databases directly from your Source Management System. Innovartis Ltd are also offering the DB Ghost Scripter as free software - just download the evaluation copy of DB Ghost version 3.0 (which is limited to 30 days) and the DB Ghost Scripter is included which never expires.

LONDON, England (PRWEB) May 16, 2004---What DB Ghost Does: DB Ghost is more than just a diff tool, its a new process that breaks away from the current methods of SQL server database change management. DB Ghost allows users to work with their SQL code in the same way they do with VB, ASP, C++ and Java, consequently eradicating many of the inherent timely and costly issues that are associated with the software development lifecycle. The DB Ghost process ensures that any changes to SQL Server source code are accurately reflected in all target databases in an auditable, reversible and repeatable way. And as the ability to audit SQL changes is now a reality, DB Ghost helps companies to fall in line with Sarbanes Oxley compliance as they now have the ability to see what, when and why changes were made to their databases along with who made them...down to the very last character.

In short, the DB Ghost process involves:

• As a one time process (using the DB Ghost Scripter) script out your entire production databases schema and static data into individual scripts, add these into your Source Management System (the DB Ghost Scripter will add these to SourceSafe) and instruct the team to use them in the same manner that they would VB, ASP, C++ or Java code.

• From that point on, in order to make a change, you check out the relevant script, make the amendments, execute it against your development database, do your unit testing/bug fixing and then check it back in when youre finished.

• What you end up with is a set of base schema creation scripts that succinctly reflect the desired database schema. To propagate those changes you point DB Ghost at your target database and at the scripts in your Source Management System. DB Ghost will then verify that all the scripts compile, with no dependency errors, and make all necessary changes to the target database to ensure that it matches the scripts. Simple.

Existing DB Ghost Features:

• Verify changes made to your database schema and static data.

• Report on all changes and errors.

• Automatically deploy changes.

• Compare two existing databases and make them match precisely.

• Compare an existing database against a set of base schema creation scripts (Stored Procedures, Tables, Views, Indexes, Foreign Keys etc.). This feature ensures DB Ghost works in harmony with your Source Management System.

• Builds new databases from scratch - just point it at a set of object creation scripts and let DB Ghost do the rest.

• Command line interface for automatic scheduling that works seamlessly with daily build processes.

• SessionSave facility means that you can script your upgrade answers to provide total automated repeatability.

• Intuitive, straightforward wizard based interface.

• Seamless integration with Visual SourceSafe.

The New Features:

• Now creates a script of the upgrade allowing you to upgrade databases even if they are not on your network -- a feature required by the ISP community.

• Includes the DB Ghost Scripter - a free schema and static data scripter that scripts out all your database objects as individual scripts. This includes static data, so you can now select your static data tables and the DB Ghost Scripter will create an SQL file containing all the insert statements for each table. Each different object type will be created within it's own directory. The DB Ghost Scripter can then add all these files into Visual SourceSafe mirroring the structure on your hard-drive as Directory to Project and source file to SourceSafe item.

• Overall application performance increase of 20%.

• Enhanced Data comparison algorithm and is now 30 times faster.

Evaluation Copy:

A 30-day trial copy of DB Ghost v3.0, which includes free technical support, can be downloaded from www.innovartis.co.uk/Evaluation.aspx. Innovartis Ltd have also provided a downloadable demo (with audio) that shows DB Ghost running through a simple scenario using the Northwind database.

The Company:

Innovartis Ltd provide consultation and end-to-end database change management solutions for Microsoft SQL Server users.