ADDA is a multipurpose toolkit for designing, creating and maintaining the database layer throughout the entire application lifecycle.

Classic development tools specializing in database applications such as FoxPro, Magic or Clarion rely heavily on data dictionary. Metadata coupled with application code reduces chaos and speeds up development. Modern IDEs for .NET, such as MS Visual Studio, Borland Delphi and Borland C# Builder although supplied with powerful tools, lack the strong link to the database structure.

ADDA is the perfect solution for this niche. It provides convenient and easy way to manage data dictionary, as well as complete upgrade solution and customization capabilities for advanced end users.

Highlights:
• Database primary planning.
• Keep track of most recent changes.
• Automatically deploy changes.
• Verify changes made to your database schema.
• Using pool of columns for common use to speed up development time.
• CASE like database display.
• End user can add customized tables and columns.
• Instant automatic database creation.
• Handles all types of database object.
• Fully automatic lossless upgrade of customer's database.
• Open file format (XML).
• Reverse-engineer existing databases.
• Generate SQL creation scripts.
• Report on all changes and errors.
• Print data dictionary.

ADDA contains four modules:
1. Dictionary Designer for Developer
2. Database Synchronizer
3. Visual Studio Add-In
4. Dictionary Designer for End User

Module Descriptions
1. Dictionary Designer for Developer:
   • Builds data dictionary either from scratch or by reverse-engineering an existing database
   • Column data type is stored in backend-independent format which allows instant switching between backends
   • Reuse column designs by linking to special pool columns, or copying from another table
   • Smart entity duplication
   • Convenient search capabilities
   • Bird's eye view of data dictionary with the ability to zoom in/out, search and display tables for certain column values (with different color displays for the results)
   • Printing out search results
   • Special support for Clarion legacy date and time formats
2. Database Synchronizer:
   • Upgrades end user's database
   • No need for DBA or IT professional involvement within the customer site
   • No need for any supporting tools like SQL Server Enterprise Manager or SQL Server Query Analyzer
   • Easy to operate yet powerful enough to do selective upgrades or completely rebuild existing tables while preserving the data
   • The query to be run can be copied to clipboard
   • Aware of possible end user's customization
3. Visual Studio Add-In
   • Enables quick access to data dictionary while coding in MS Visual Studio
   • Each dictionary is effectively coupled with relevant VS solution. Dictionary FieldBox is automatically loaded and unloaded when opening and closing proper solution
   • Simply double click the column name and then paste it anywhere you want
4. Data Dictionary Designer for End User (available only with ADDA Enterprise edition)
   • Enables end user to customize the database by adding new columns, tables, triggers, etc.
   • Common developer-defined entities are protected and cannot be altered or deleted
   • Keeps syncronization process aware of the customization

Compare editions of ADDA

Feature	ADDA Professional	ADDA Enterprise
Data dictionary design
Track of most recent changes
Bird's eye view
Instant automatic database creation
Open file format (XML)
Fully automatic upgrade of customer's database
Reverse-engineer existing databases
Pool of columns
MS Visual Studio © Add-in
End-user specific customization

Summary:

ADDA is an excellent supplement to the modern development tools. Not only it organizes database-related metadata, but also transforms the long tedious procedure of database upgrade to a single click, eliminating the very need of DBA presence on site. Given its easy deployment, it is even more effective for large scale application users.Save time and money developing databases.

System Requirements

Microsoft .NET Framework 1.1 Microsoft SQL Server 7 or better (other SQL backends in development) Optional – Microsoft Visual Studio ©