dbscript Architecture

dbscript Architecture

dbscript operates on database schema information imported from a database (MSSQL, Oracle, PostgreSQL), or uploaded via .sql files containing CREATE statements, organizing the schema information in Project Versions.

Based on this data, users can define Value Scripts to generate C# and VB.Net constants or script the values as SQL statements, compare schemas, and generate schema documentation:

 

 

How does this help developers?

Functionality Activity
Generate SQL statements from Schema information Version Management, Release, Installation
Generate XML representation of Schema information Version Management, Documentation
Generate C# const declarations C# development
Generate VB.Net const declarations VB.Net development
Generate SQL table data scripts Version Management, Release, Installation
Generate XML representation of table data Version Management, Documentation
Generate SQL statements from Schema Comparison Version Management, Release, Upgrade
Documentation Generator Version Management, Documentation
Customer and Installation Management Support