CAST SQL-Builder is the only SQL IDE that gives expert advice on code quality and helps master SQL code complexity. Use a widely adopted solution - go for reliability and performance: choose a solution backed by seven years' experience and chosen by a renowned consulting firm to equip its 1,500 consultants.

Far more than just an SQL IDE
CAST SQL-Builder provides all the common features of an SQL IDE for creating, testing and debugging the most complex database applications. But the incorporation of CAST's source code analysis technology makes SQL-Builder a more sophisticated tool than just a simple development environment. It offers unique functions like its 'Code Checker' or its 'Flow Chart' that contribute to differentiate SQL-Builder from the other development environments available on the market.

• Code Checker is dedicated to providing unique real-time expert advice on the SQL code - at both functional and performance levels. By automatically detecting in development programming "errors" that are normally only visible when the code is executed in the test phase or during a code review after a problem surfaces in production, SQL-Builder:
  • Saves development costs by avoiding functional and performance run-time 'errors'.
  • Saves DBAs' time by enabling them to avoid having to manually check the code at the end of the project.
• Flow Chart is a unique flow diagram graphical visualization feature allowing developers to save time when working with very complex pieces of code. This powerful feature is designed to graphically represent the structure of any coded T-SQL artifact (procedure, function, trigger etc.) in a flow diagram. It enables developers to:
  • Understand the structure of any complex stored procedure or trigger at a glance.
  • Access precisely the information they are looking for without searching through complex code

• Detect performance and functional run-time errors
• Spend less time checking code in production
• Understand complex pieces of code faster
• Deliver better code, faster
• Speed up code testing
• Debug the most complex situations
• Use a user-friendly and handy tool

CAST SQL-Builder encompasses:

• Code Checking facilities provide value-added advice on source code quality - both at functional and performance levels.
• A Flow Chart graphically represents the structure of any T-SQL object (procedure, function, trigger etc.) in a flow diagram to help understand complex pieces of code. See More
• Contextual vision. A graphical interface provides access to all SQL objects and shows all the Called & Calling objects of any element, thus giving an excellent understanding of the development environment. See More
• A Graphical Object Manager, which is an on-line graphical viewer for database objects that gives you an immediate understanding of your work context. It describes the nature of SQL artifacts and shows their interdependencies. See More
• Intelligent code editors (color-coded, word completion, syntax highlighted, templates and more) as well as an intuitive interface to create even the most complex requests simply by moving the mouse. See More
• A Table editor is a full editor, which takes into account all table structure modification commands (i.e.: alter table commands). When a table is being modified, it automatically generates the SQL script necessary for the transfer of data from the old to the new table.See More
• An SQL-Session facilitates testing through an easy-to-use interface that provides all the editing commands included in the editor and enables the visualization of any requests in grid and text format.See More
• An integrated debugger includes both persistent and conditional breakpoints to easily handle all debugging situations and incorporates an SQL-Session to query the database objects, particularly temporary tables, while debugging an object.See More

CAST SQL-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).