This software is a great tool for designing databases, allowing for easy creation, querying, and management using entity relationship diagrams (ERD) and database structure diagrams.
If you're in need of a tool for managing your relational database design, look no further than Database Design Studio Lite (DDS-Lite). This software provides a comprehensive environment for designing, creating, querying, and editing your database. Some of the key features you'll find in DDS-Lite include robust project management capabilities for various database design components (such as ERD, DSD, schemas, scripts, ODBC connections, table views, datastore, and other project files), an enhanced entity-relationship diagram (EERD) editor with the ability to model specialization and generalization relationships, automatic creation of a data structure diagram (DSD) from your ERD, and automatic schema creation from your ERD (including constraints like indexes).
DDS-Lite also offers SQL scripts for inserting data into your database and supports multiple database platforms, including ANSI, Ingres, InterBase, Informix, SQLBase, MicroSQL, Microsoft Access, Microsoft SQL Server, MySQL, and Oracle. For developers, DDS-Lite provides Microsoft Visual Basic and Java source code generators. Additionally, DDS-Lite allows you to create, access, and query a Microsoft Access database based on your model, without needing to install Microsoft Access. Other features of DDS-Lite include Java source code for creating and dropping tables within your JDBC accessible database (JDK not included), an integrated Java edit/build/run environment, syntax highlighting in the SQL, Java, and VB editors, a complete build/run environment for any project file (SQL, Java, JSQL, etc.), an SQL console window for ODBC connectivity to any data source, DDS-Lite datastore for creation and storage of test data (which can also be inserted into your live database), ODBC DSN manager integration, and more.
Customer reviews of DDS-Lite are glowing, with users praising its similarity to higher-priced tools like S-DESIGNOR and ERWIN, its ease of use and intuitive operation, its helpful database creation statements, and its ability to quickly create working schemata. Overall, if you're looking for a reliable, comprehensive tool for managing your relational database design, DDS-Lite may be just what you need.
DDS-Lite also offers SQL scripts for inserting data into your database and supports multiple database platforms, including ANSI, Ingres, InterBase, Informix, SQLBase, MicroSQL, Microsoft Access, Microsoft SQL Server, MySQL, and Oracle. For developers, DDS-Lite provides Microsoft Visual Basic and Java source code generators. Additionally, DDS-Lite allows you to create, access, and query a Microsoft Access database based on your model, without needing to install Microsoft Access. Other features of DDS-Lite include Java source code for creating and dropping tables within your JDBC accessible database (JDK not included), an integrated Java edit/build/run environment, syntax highlighting in the SQL, Java, and VB editors, a complete build/run environment for any project file (SQL, Java, JSQL, etc.), an SQL console window for ODBC connectivity to any data source, DDS-Lite datastore for creation and storage of test data (which can also be inserted into your live database), ODBC DSN manager integration, and more.
Customer reviews of DDS-Lite are glowing, with users praising its similarity to higher-priced tools like S-DESIGNOR and ERWIN, its ease of use and intuitive operation, its helpful database creation statements, and its ability to quickly create working schemata. Overall, if you're looking for a reliable, comprehensive tool for managing your relational database design, DDS-Lite may be just what you need.
What's New
Version 2.10.0: N/A