Difference between revisions of "Project"

From dbscript Online Help
Jump to: navigation, search
(Schema Comparisons)
 
(One intermediate revision by the same user not shown)
Line 18: Line 18:
  
 
Compare two Project Versions (two schemas) and create a database schema migration script from the difference.
 
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]]===
Line 40: Line 44:
  
 
See [[Main_Page#Samples|Samples]] for generated MediaWiki documentation.
 
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.

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.

Customers and Installations[edit]

Branches[edit]