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 |