Difference between revisions of "Project"
| Line 1: | Line 1: | ||
In dbscript, every information exists in the context of a Project. | In dbscript, every information exists in the context of a Project. | ||
| − | A Project contains a collection of [[Project Version|Project Versions]], [[Database|Databases]], [[Comparison|Schema Comparisons]], [[Value Script|Value Scripts]], [[Object Selection|Object Selections]], | + | A Project contains a collection of [[Project Version|Project Versions]], [[Database|Databases]], [[Comparison|Schema Comparisons]], [[Value Script|Value Scripts]], [[Object Selection|Object Selections]], [[Saved Script|Saved Scripts]], and [[Documentation Generator|Documentation Generators]]. |
===Properties=== | ===Properties=== | ||
| Line 17: | Line 17: | ||
===[[Comparison|Schema Comparisons]]=== | ===[[Comparison|Schema Comparisons]]=== | ||
| − | + | Compare two Project Versions (two schemas) and create a database schema migration script from the difference. | |
===[[Value Script|Value Scripts]]=== | ===[[Value Script|Value Scripts]]=== | ||
| − | Script generator | + | Script generator to generate |
| + | |||
| + | * table data as C# constants | ||
| + | * T-SQL INSERT/UPDATE statements to replicate data in source (development) tables to production databases. | ||
| + | * XML files containing data of selected tables | ||
===[[Object Selection|Object Selections]]=== | ===[[Object Selection|Object Selections]]=== | ||
| Line 30: | Line 34: | ||
Imported and generated schema, comparison and value scripts saved by the user. | Imported and generated schema, comparison and value scripts saved by the user. | ||
| + | |||
| + | ===[[Documentation Generator|Documentation Generators]]=== | ||
| + | |||
| + | Generate Database Documentation by using built-in or user-defined XSL to transform XML generated by Project Versions, Objects and Value Scripts. | ||
| + | |||
| + | See [[Main_Page#Samples|Samples]] for generated MediaWiki documentation. | ||
Revision as of 08:01, 2 January 2009
In dbscript, every information exists in the context of a Project.
A Project contains a collection of Project Versions, Databases, Schema Comparisons, Value Scripts, Object Selections, Saved Scripts, and Documentation Generators.
Contents
Properties
See Proj-edit
Project Versions
Each version of a schema or database snapshot is stored in a Project Version containing a set of Objects representing the schema objects.
Databases
Databases represent the development and production databases containing the schemas.
Schema Comparisons
Compare two Project Versions (two schemas) and create a database schema migration script from the difference.
Value Scripts
Script generator to generate
- table data as C# constants
- T-SQL INSERT/UPDATE statements to replicate data in source (development) tables to production databases.
- XML files containing data of selected tables
Object Selections
A name- and object type-based filter on schema objects.
Saved Scripts
Imported and generated schema, comparison and value scripts saved by the user.
Documentation Generators
Generate Database Documentation by using built-in or user-defined XSL to transform XML generated by Project Versions, Objects and Value Scripts.
See Samples for generated MediaWiki documentation.
