App-Centric upgrade to SQL Server
Take control of your Database Development Practices using App-Centric Naming Conventions, Design Patterns and Refactorings with this new Application Database design Extension for Microsoft SQL Server Management Studio v17+.
FEATURES OVERVIEW
Architects
Conventions
Automatically apply 40+ Naming Conventions and Design Patterns for all database objects like Tables, Views, Procedures and Constraints
Repair Tool
Retroactively Diagnose and Repair design issues like missing Foreign Keys or Indexes, incorrect Naming Conventions and Performance
Change Shield
Apply database changes without breaking Application dependencies by automatically generating "Deprecated" placeholder Objects
Compatibility
Developers
Templates
Use 30+ Customizable Templates to create any database structure according to your Conventions and industry's Best Practices
Typed Tables
Create Tables of specific Types like Entity, Reference, Junction or Localization to align your Database Model with your Application's needs
Refactorings
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.
Development Workflow
Architects configure conventions
40+ Conventions for Object Naming and Design Patterns to Standardize the Application Database
Developers build the Database
The Templates and Refactorings menus accelerate and standardize development and maintenance
Architects review & repair
Summary and Detailed Reports as well as a Repair Script Generator for database-wide Code Review
Build App-Friendly Databases
Code Templates
30+ Customizable Templates to create all types of Database Objects according to Naming Conventions and Design Patterns.
Typed Tables
7+ Table Archetypes to speed up Application Development, like Reference, Junction and Localization tables
Refactorings
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
Pricing
COMMUNITY EDITION
Free Download
Most features are free to use
Up to 20 Objects in Repair Tool, Stock Templates
PERSONAL EDITION
US $89.00
Billed to an Individual
Unfiltered Repair Tool, Template Customization
ENTERPRISE EDITION
US $189.00
Billed to a Company
Unfiltered Repair Tool, Template Customization