|
|
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.
Keywords: sql database database design er modeling entity erd entity relationship diagram dsd data structure diagram sql scripts ddl data definition language foreign key constraints referential integrity relational database word translation case studies
|
|
|
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.
Keywords: sql query builder query designer sql scripts ddl data definition language dml data manipulation language database metadata schema dbms odbc database management system oracle sql server swiss german alternate language
|
