DB Ghost Data and Schema Scripter

Overview


Download Trial Buy Now

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
  • Speed - the engine operates at up to 8000 objects per minute (around 130 objects per second)
  • Creates a Visual Studio database project so that SQL code can be added in to your overall solutioncreating a single environment for the development team to work in
  • Command line or API execution for total process automation (requires Automation Toolkit™)

Screenshots

The first page allows you to start a new project or load an existing one (a project that you have saved from a previous session):

Select the database to be scripted:

Select the objects to be scripted:

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

Select the target root directory for the scripts, whether or not to produce a project file for use in Visual Studio and the filename of the report to be produced:

Progress is displayed whilst the scripting engine executes:

Confirmation that the process has completed successfully and a dialog asking if the db project should be opened in Visual Studio (note the time - 3 seconds!)