dbscript Overview
Integrated Database Versioning, Code Generation, and Documentation
Database Versioning
dbscript operates on database schema information imported from a database (MSSQL, Oracle, PostgreSQL), or uploaded via SQL DDL files containing CREATE statements, organizing the schema information in Project Versions.
Code Generation
Using a built-in script engine, dbscript allows developers to generate:
- SQL DDL code of database objects
- SQL INSERT/UPDATE scripts to migrate data
- C# and VB.Net constant definitions
Documentation
By defining Documentation Generators, developers can easily create documentation of any imported database version in these formats:
| MS SQL Server | Oracle | PostgreSql | EF edmx | |
| dbscript HTML | view | view | view | |
| dbscript Single HTML | view | view | view | view view |
| HTML (single file) | view | view | view | view view |
| MediaWiki | view | view | view | view view |
| ScrewTurn Wiki (V2) | view | view | view | |
| ScrewTurn Wiki (V3) | view | view | view | |
| Word HTML | view | view | view | view view |
dbscript generates Data Diagrams as .png and .dia files:
| MS SQL Server | Oracle | PostgreSql | |
| PNG | view | view | view |
| Dia | view | view | view |
All documentation samples are based on these freely available demo projects:
| MS SQL Server | AdventureWorks (2005) |
| Oracle | Oracle Demo Schema |
| PostgreSql | OpenNMS |