Difference between revisions of "Overview"
(New page: http://www.devio.at/images/dbscript-overview-0.93-jan09-a5.png) |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | http://www.devio.at/images/dbscript-overview-0. | + | 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]], [[Comparison|compare schemas]], and generate [[Documentation Generator|schema documentation]]: | ||
| + | |||
| + | http://www.devio.at/images/dbscript-overview-0.99-oct09-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 | ||
| + | |||
| + | |} | ||
Latest revision as of 21:04, 13 October 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.99-oct09-a5.png
How does this help developers?[edit]
| 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 |
