This software is an exceptional tool for designing databases with ease, featuring entity relationship and database structure diagrams. It provides efficient database creation, querying, and management.
With its Enhanced Entity Relationship Diagram (EERD) editor, DDS-Lite lets you create complex data models with ease, including specialisation and generalisation relationships. You can even generate a Data Structure Diagram (DSD) and schemas from your ERD, complete with constraints such as indexes, thanks to DDS-Lite's automated tools. Additionally, DDS-Lite supports ANSI, Ingres, InterBase, Informix, SQLBase, MicroSQL, Microsoft Access, Microsoft SQL Server, MySQL, and Oracle, as well as Microsoft Visual Basic and Java source code generator.
What really sets DDS-Lite apart, though, is its seamless integration with Microsoft Access. Even if you don't have the software on your machine, you can still create, access, and query a Microsoft Access database based on your model. You can also generate Java source code for performing CRUD operations on your JDBC-accessible database.
But DDS-Lite's features don't stop there: it offers syntax highlighting of keywords and reserved words in SQL, Java, and VB editors, an intuitive build/run environment for any project file type (SQL, Java, JSQL, etc.), an ODBC Console Window, and much more. With DDS-Lite Datastore, you can even create and store test data to be inserted into your live database.
What do customers think of DDS-Lite? One satisfied user from Rock-Tenn Inc. stated that the tool offers the same functionality as S-DESIGNOR and ERWIN at an affordable price. Another reviewer from Collins Informatik praised DDS-Lite's ease of use and ERD preparation tools, which make it simple to test and modify your data model. And finally, a reviewer from The Digital Mage appreciated DDS-Lite's efficiency in creating working schemas quickly and producing great-looking output in print.
Overall, if you need a powerful yet affordable solution for your database design needs, DDS-Lite is definitely worth checking out.
Version 2.10.0: N/A