Chilli Source - Software Products

Database Design Studio - Lite (DDS-Lite)

DDS-Lite is for ERD modeling, SQL script generation and forward engineering of relational databases. Enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, complete with Cascading Referential Integrity Constraints, Indexes, Checks, Defaults and Unique constraints. Data Structure Diagram that is created automatically from the Enhanced Entity Relationship Diagram shows the complete table structure. Data Definition Language (DDL) Scripts for creating, dropping and loading the database can be quickly and easily generated for all of the supported database servers. Supports All Major Databases including Oracle, DB2, SQL Server, Informix, Sybase, MySQL, PostgreSQL, Interbase, Access, SQLBase, Ingres, ANSI and MicroSQL. Cross DBMS Target Compatibility allows you to design once and create for all. No need to concern yourself with vendor specific variations to SQL syntax. All is handled by the application. Project Manager for managing the files that are used and generated by the application. Full support for Windows Shell such as delete to the recycle bin, drag and drop, file renaming etc. Integrate Tools from the Database vendors to execute the Data Definition Language scripts directly within the application. Java Source Code can be created directly from the Enhanced Entity Relationship Diagram to contain the Data Definition Language for any of the supported database targets. Source code can be compiled and executed from within the DDS-Lite environment. Template Language to define the Data Definition Language scripts allows you to create the scripts exactly as you want them. SQL Editors with syntax hi-lighting, context sensitive auto-complete of SQL words. Build and Run environment integrated with the DBMS vendor tools. User Defined Types or domains are an integral part of the Entity Relationship Diagram editing environment. Database Design Studio - Lite (DDS-Lite) is a development tools software.

Keywords: manager tools structure diagram data definition language relational databases script generation enhanced entity relationship diagram db2 sql java source code windows shell forward engineering entity relationship diagram template language language scripts database vendors application java sql script application project referential integrity constraints structure data database servers share digital music jukebox

SQLConsole (SQLC)

SQLConsole (SQLC) creates SQL queries using drag and drop Visual Query Builder for every database (ODBC). As easy as dragging and dropping tables and joins the most complex of queries can be developed in mere minutes. Full support for correlated subqueries, totally configurable SQL functions and target mapped function drag and drop operations. SQL editors are context sensitive providing auto-complete of SQL keywords and table or view columns. SQLC provides the end user with a fully integrated set of development tools for data manipulation and data definition. Complete with a metadata view of the underlying data structure, the end user is presented with a total overview of the data environment. Visual Query Builder which provides you with a modeling environment to visually create the most complex of SQL queries in mere minutes. With drag and drop functionality you can quickly and easily build an SQL query comprising of all manner of joins, search conditions, functions and even with an unlimited numbers of subqueries. Connection Manager maintains an interactive list of all open database connections and the metadata associated with each connection in a dockable window called the Connection Manager. The information presented in the Connection Manager is central to all other operations within SQLC. Intelligent Auto-Complete feature that allows you to "auto-complete" reserved words and keywords with a simple keystroke. Context Sensitive Editing monitors editor contents and keystrokes and will display a selectable list of table columns whenever the "dot" separator character is typed after a table alias or table name. Unlimited Email Support is provided for all registered users of SQLC with free upgrades. SQLConsole (SQLC) is a development tools software.

Keywords: keystroke open database search conditions correlated subqueries drop functionality drop operations table columns drag and drop data environment intelligent auto data structure database connections free upgrades sql query visual query builder sql functions data manipulation dockable window sql queries target registry manipulation optimal solution

Database Design Studio - Professional (DDS-Pro)

DDS-Pro is for reverse engineering databases, ERD modeling, SQL script generation and forward engineering of relational databases. Enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, complete with Cascading Referential Integrity Constraints, Indexes, Checks, Defaults and Unique constraints. Data Structure Diagram that is created automatically from the Enhanced Entity Relationship Diagram shows the complete table structure. Data Definition Language (DDL) Scripts for creating, dropping and loading the database can be quickly and easily generated for all of the supported database servers. Supports All Major Databases including Oracle, DB2, SQL Server, Informix, Sybase, MySQL, PostgreSQL, Interbase, Access, SQLBase, Ingres, ANSI and MicroSQL. Cross DBMS Target Compatibility allows you to design once and create for all. No need to concern yourself with vendor specific variations to SQL syntax. All is handled by the application. Project Manager for managing the files that are used and generated by the application. Full support for Windows Shell such as delete to the recycle bin, drag and drop, file renaming etc. Integrate Tools from the Database vendors to execute the Data Definition Language scripts directly within the application. Java Source Code can be created directly from the Enhanced Entity Relationship Diagram to contain the Data Definition Language for any of the supported database targets. Source code can be compiled and executed from within the DDS-Lite environment. Template Language to define the Data Definition Language scripts allows you to create the scripts exactly as you want them. SQL Editors with syntax hi-lighting, context sensitive auto-complete of SQL words. Build and Run environment integrated with the DBMS vendor tools. User Defined Types or domains are an integral part of the Entity Relationship Diagram editing environment. This is a shareware listed under databases, programming, business category.

Keywords: template language relational databases database vendors data definition language db2 sql target forward engineering java source code enhanced entity relationship diagram script generation structure data database servers referential integrity constraints windows shell manager tools language scripts application project application java structure diagram entity relationship diagram test drive image backup