Project

From dbscript Online Help
Revision as of 23:41, 2 November 2008 by Ho (talk | contribs)
Jump to: navigation, search

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, and Saved Scripts.

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

A comparison of two Project Versions (two schemas).

Value Scripts

Script generator for C# constants and T-SQL INSERT/UPDATE statements to replicate data in source (development) tables to production databases.

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.