CAST Release-Builder is a sophisticated tool for facilitating and securing accurate database/schema deployments throughout a project's lifecycle, by fully automating the processes of script extraction, database comparison and script generation update. The incorporation of CAST's unique technology of syntactic and semantic code analysis ensures unique reliability in database releases: accuracy levels are far above those achieved manually.

Automated script extraction & reordering
Release-Builder extracts and recreates the script corresponding to one or multiple databases. Extracted objects are automatically re-ordered, which ensures the respect of referential constraints and thus the correct execution of the script. Release-Builder checks for missing dependencies to verify that the script is complete. This proves particularly important when the extraction does not include all the objects in the database. Release-Builder guarantees a quick and accurate transfer of Database scripts and data between servers.
Speed up the release process - update scripts ten times faster

Automated comparison & update script generation
Release Builder's database comparison feature is tightly linked to the extraction engine. It automatically compares the object structures of two different databases, checks for missing dependencies, verifies that the script is complete and generates update scripts for the target database. When modifications call for dropping or recreating a table, CAST Release Builder saves and restores the data of the impacted table. Release Builder's unique ability to move changes will save you time and help you gain control over change management issues.
Secure the release process - ensure high-quality deliverables

• Automate and secure the SQL release process
• Implement complex database changes quickly and accurately
• Get automated script extraction and reordering
• Control the ensemble of database comparison
• Save time and avoid data loss with automated delta script generation

Tasks that Release-Builder automates for you:

• Extract, compare and synchronize the differences between database objects
• Compare the object structures of two different Databases and generate reports listing all the differences between the two databases
• Identify and compare all the modified objects between development and production databases
• Re-order objects while extracting the scripts and ensure the respect of the referential constraints
• Generate the delta script to update the database
• Generate batch scripts via the command line
• Copy objects between production, development or test databases safely
• Check for missing dependencies and verify that the script is complete
• Document all changes through HTML reports

CAST Release-Builder is available for:

• Operating Systems: Windows 2000 SP4, WindowsXP Professional SP2, Windows 2003 Server
• Microsoft SQL Server: 7.0, 2000 with SP1 or higher, 2005 with SP1.
• Sybase: 11.9.2, 12, 12.5.x, 15.0 ESD#2
• Oracle: 7.3.4.x, 8.0.5.x, 8.1.5.x, 9.0.1.1.x, 9.2.0.1.x, 10.1.0.x with x>= 2, 10.2.0.x

CAST provides a Source Manager Interface for use with SQL-Builder and Release Builder, enabling you to interface with source managers that support the Microsoft Source Code Control API (SCC API).