DB Ghost Data and Schema Scripter™


Download Trial Buy Now

Overview

DB Ghost Data and Schema Scripter scripts out all objects from a database into individual DROP/CREATE scripts for each object. It is used for capturing your current databases and placing them under source control to enable the "DB Ghost Process" which involves building and deploying your databases directly from your source control system.

The Data and Schema Scripter can also be used as an efficient way to capture schema snapshots if required.

Once a database has been successfully scripted and placed under source control it can then be regarded as the "source database". Therefore, instead of developers keeping a database instance up to date with their changes they simply update the scripts in source control to reflect the desired schema.

Features

  • Scripts all object types into individual DROP/CREATE scripts
  • Scripts data into boilerplate INSERT scripts
  • Command line execution for full process automation
  • Can add scripts to source control (VSS only)

Screenshots

The Data and Schema Scripter is a separate application (i.e. not part of the Change Manager) and allows you to save or use a previous sessions settings for each run:

Select the database to be scripted:

Select the object types to be scripted:

Select which tables should have static data INSERT scripts created for them:

Select the target root directory for the scripts and, if you have VSS installed, the VSS project the scripts should be added to:

Progress is displayed whilst the scripting engine executes:

Confirmation that the process has completed successfully: