Difference between revisions of "Project"
(→Schema Comparisons) |
|||
| (3 intermediate revisions by the same user not shown) | |||
| 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]], [[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. | |
| + | |||
| + | ===[[Multi-Comparison|Multi-Comparisons]]=== | ||
| + | |||
| + | ''Version 0.99'' | ||
===[[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 | ||
| − | ===[[Selection|Object Selections]]=== | + | ===[[Object Selection|Object Selections]]=== |
A name- and object type-based filter on schema objects. | A name- and object type-based filter on schema objects. | ||
| Line 30: | Line 38: | ||
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. | ||
| + | |||
| + | ===[[Customers and Installations]]=== | ||
| + | |||
| + | ===[[Branch|Branches]]=== | ||
Latest revision as of 07:45, 21 September 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[edit]
See Proj-edit
Project Versions[edit]
Each version of a schema or database snapshot is stored in a Project Version containing a set of Objects representing the schema objects.
Databases[edit]
Databases represent the development and production databases containing the schemas.
Schema Comparisons[edit]
Compare two Project Versions (two schemas) and create a database schema migration script from the difference.
Multi-Comparisons[edit]
Version 0.99
Value Scripts[edit]
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[edit]
A name- and object type-based filter on schema objects.
Saved Scripts[edit]
Imported and generated schema, comparison and value scripts saved by the user.
Documentation Generators[edit]
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.
