This software is a top-notch tool for effortlessly designing, querying, and managing databases through the use of entity relationship diagrams, database structure diagrams, and other features.
One of the best features of this software is its Enhanced Entity Relationship Diagram (EERD) editor. It includes a variety of functions such as specialized and generalization relationships. Additionally, DDS Lite automatically generates a Data Structure Diagram (DSD) in addition to schemas from your ERD, including necessary constraints such as indexes. Users also receive SQL scripts for inserting data into the database quickly.
DDS-Lite impressively supports ANSI, Ingres, InterBase, Informix, SQLBase, MicroSQL, Microsoft Access, Microsoft SQL Server, MySQL, and Oracle databases, as well as Microsoft Visual Basic and Java source code generator. Additionally, you can create, access, and query a Microsoft Access database based on your model without the need to install MS Access. Generating and dropping tables within JDBC accessible database is also possible as DDS-Lite includes an integrated Java edit, build, run environment.
DDS software reviews are highly positive as syntax highlighting of reserved and keywords in SQL, Java, and VB editors are also available. All project files, including SQL, Java, and JSQL, are completed in a complete build/run environment. The SQL Console Window also allows ODBC connectivity to any data source. DDS-Lite Datastore is an added feature for the creation and storage of test data enabling it to be inserted into your live database easily.
Customers are highly satisfied with DDS-Lite's capabilities. Developers have called it an affordable alternative to ERWIN and S-DESIGNOR, with both easy and intuitive to use. Setting up and testing an ERD and easy database creation statements were another customer favorite. Others highlight DDS-Lite's ease of use, quick to create a working schema with outputs that print effectively, and faultless database model amendments.
In conclusion, Database Design Studio Lite provides an exceptional set of advanced features ideal for any organization that works with databases in their day-to-day operations. With DDS-Lite, you can manage your database design and project management with ease, and generate accurate, high-quality databases in no time at an affordable price point.
Version 2.0: N/A