Dataedo Portable

Dedicated to database experts and organizations, Dataedo is an application that facilitates a user-friendly interface and comprehensive tools to help you create relevant documentation for your SQL databases. This way, you can reduce bottlenecks, avoid errors, and save a lot of time in the process.

The program can be used to put together and maintain data dictionaries with descriptions for tables, columns and relationships, to view database schemas with ERDs (Entity Relationship Diagrams), as well as to take control over document procedures, functions and triggers. It supports Oracle, SQL Server, and MySQL.

Since this edition is wrapped in a portable package, you can extract the files from the downloaded archive and simply double-click the launcher to reach the main app window right away. However, it creates and uses files in %USERPROFILE%. For instance, if you want to keep it stored on a USB flash drive and move it between machines, it's necessary to reinput the purchased product key. Also, the recent files tab might be cleared.

You can get started by creating a new local or server repository. Luckily, sample data can be loaded to find out how stuff works. In terms of appearance, Dataedo resembles Microsoft Office. Table, view, procedure and function documentation can be created for the schema and metadata, ERDs, dependencies, and utilities. It's possible to use a search function, re-arrange modules, update the documentation and export it to file (PDF, HTML, Excel). Existing descriptions can be imported into the database.

Standard text formatting options are available for the descriptions, such as font styles, line spacing, hyperlinks, and bookmarks, helping you best describe and highlight tables, columns, relations, unique keys, triggers, and views.

Meanwhile, ER diagrams can be effortlessly designed using an intuitive editor (canvas with color assigning). The table relationships are added automatically using the data dictionary. Worth mentioning is that multiple diagrams can be created for the same documentation (for each topic).

The application worked without error on Windows 10 in our our tests, having minimal impact on system performance. Taking into account its clear-cut interface and options, Dataedo should come in handy to all users looking for a simple solution to document their databases.