Database Development

Tools

Design

• https://dbschema.com/

Development

Below is a short list of solutions to source control and develop databases

• https://github.com/erikbra/grate
• Fluent Migrations - .net
• https://flywaydb.org/
• Visual Studio DB Projects (SSDT)
• Azure Data Studio
• Red Gate
• ApexSQL source control
• DBmaestro
• dbForge Source Control

Deployment

Below is a short list of solutions to deploy databases

• Bytebase
• Liquibase
• Atlas

Tool Comparisons

• Red Gate vs SSDT

Coding Standards

• https://ovid.github.io/articles/database-design-standards.html

Best Practices

• http://agiledata.org/essays/bestPractices.html
• https://www.martinfowler.com/articles/evodb.html
• https://www.red-gate.com/products/dba/sql-provision/entrypage/dedicated-database-development-environments
• https://www.red-gate.com/simple-talk/collections/database-lifecycle-management-patterns-practices-library/