Automatically apply 40+ Naming Conventions and Design Patterns for all database objects like Tables, Views, Procedures and Constraints
Retroactively Diagnose and Repair design issues like missing Foreign Keys or Indexes, incorrect Naming Conventions and Performance
Apply database changes without breaking Application dependencies by automatically generating "Deprecated" placeholder Objects
Use 30+ Customizable Templates to create any database structure according to your Conventions and industry's Best Practices
Create Tables of specific Types like Entity, Reference, Junction or Localization to align your Database Model with your Application's needs
Lessen Technical Debt and replace Composite Primary Key with Surrogate Key, Move database objects between Schemas, Split and Merge tables...
Tools & Metrics
Create Save Points to Rollback to, empty all non-reference Tables, display Volumetry Reports...
Shield Apps from Database Changes
Automatic Placeholders Generation
AppDB.Studio can Generate PlaceHolders when doing Database Changes to avoid Refactoring dependent Applications.
PlaceHolders are flagged as Deprecated and can have an End-of-Life Date.
Heavily inspired from the seminal book Refactoring Databases.
Build App-Friendly Databases
30+ Customizable Templates to create all types of Database Objects according to Naming Conventions and Design Patterns.
7+ Table Archetypes to speed up Application Development, like Reference, Junction and Localization tables
10+ Refactorings to Rename Objects and Move Objects between Schemas without breaking Application Dependencies.
Also SSDT Refactorlog can be generated for every Refactoring.
Popular Design Patterns
5+ Design Patterns to automatically add standardized sets of columns to all application tables