AppDB.Studio 2019

Application Database IDE / MS-SQL Extension

FREE DOWNLOAD

DEVELOP DATABASES LIKE A DBA

Take control of your Database Development Practices using 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

Management Studio v17+

Microsoft SQL Server 2008+

Visual Studio SSDT Database Projects

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

FREE DOWNLOAD

PERSONAL EDITION

US $89.00

Billed to an Individual

Unfiltered Repair Tool, Template Customization

BUY NOW

ENTERPRISE EDITION

US $189.00

Billed to a Company

Unfiltered Repair Tool, Template Customization

BUY NOW

Download the Free Community Edition

Free Download