Difference between revisions of "Overview"

From dbscript Online Help
Jump to: navigation, search
(New page: http://www.devio.at/images/dbscript-overview-0.93-jan09-a5.png)
 
Line 1: Line 1:
 +
dbscript operates on database schema information imported from an MS SQL Server database, or uploaded via .sql files containing CREATE statements, organizing the schema information in [[Project Version|Project Versions]]
 +
 +
Based on this data, users can define [[Value Script|Value Scripts]], [[Compare|compare schemas]], and generate [[Documentation Generator|schema documentation]]:
 +
 
http://www.devio.at/images/dbscript-overview-0.93-jan09-a5.png
 
http://www.devio.at/images/dbscript-overview-0.93-jan09-a5.png
 +
 +
===How does this help developers?===
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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# developer
 +
 +
|-
 +
| 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
 +
 +
|}

Revision as of 09:13, 7 January 2009

dbscript operates on database schema information imported from an MS SQL Server database, or uploaded via .sql files containing CREATE statements, organizing the schema information in Project Versions

Based on this data, users can define Value Scripts, compare schemas, and generate schema documentation:

http://www.devio.at/images/dbscript-overview-0.93-jan09-a5.png

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# developer
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