Difference between revisions of "Project"

From dbscript Online Help
Jump to: navigation, search
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]], and [[Saved Script|Saved Scripts]].
+
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]]===
  
A comparison of two Project Versions (two schemas).
+
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 for C# constants and T-SQL INSERT/UPDATE statements to replicate data in source (development) tables to production databases.
+
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.

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.