ByteDesigner is an enterprise tool for creating databases at all levels of an organization. This tool uses the same concepts found in tools costing a lot more. It includes an advanced SQL Editor, and support for all major RDBMS. This contains all the necessary features of a data modelling tool that is available at a reasonable price. The product is available for personal as well as group licenses. Personal licenses are way cheaper than a group license, of course. Several plug-ins for working with regular databases are available. These include plug-ins for DB2, Oracle, SQL base, SQL Server, etc. The product offers workspace and project oriented environment. ERD centric data modelling is available with the tool. Conceptual data modelling as well as logical data modeling and physical data modeling features are available. Free and open source databases like the MySQL, PostgreSQL, Firebird are also supported.
Model planner provides a very top level view of the database structure being designed. Quick find and navigation from output window is possible. Model validation tools let you ensure that the modeling have been designed correctly. The integrated advanced SQL editor with syntax highlighting helps create flawless SQL queries to be generated easily. Sessions could be saved and the SQL script retrieved for us later. ODBC being integrated, it is very easy to communicate with ODBC compatible databases. XML support facilitates easy communication of data between modules. Specific data types and syntax peculiar to a particular database is supported. Existing databases could be reverse engineered. It is possible to dynamically add or drop keys and linked indexes as well as foreign keys. This multi-platform tool is a very good product.