Switch to: V9V8V7V6V5

Schema Snapshot HELP

Valentina Studio Pro allows you to save database schema in structured format using the Schema Snapshot tool. Currently the only one method is available – the Script Folder. In the future the XML and Binary formats can be supported, according to the user's requirements. Unlike the SQL Dump, Schema Snapshot allows to granulate the schema representation. This will be helpful to tracking changes or using a part of schema. Moreover this is a best way to store the database structure in the version control system like Git, SVN or whatever you like.

You can create or load Schema Snapshot using Snapshot Wizard that can be invoked via main menu:

Inside the snapshot folder you can find one another file vstudio_snapshot. This is a help file for Valentina Studio that stores additional information that helps to manage snapshot properly.

Script Folder

The Script Folder is the most popular approach to store the database schema for versioning purposes. In this case each database object is stored in the separate file inside the particular folder according to the object type. So user easily can see all database structure even in the file explorer.

Create Snapshot Wizard

The Create Snapshot Wizard consists of two steps. At first you should to define snapshot participants and properties. Then the wizard will create a snapshot and will show result.

Create Snapshot Properties

  • Snapshot Folder – the path to the folder where snapshot should be saved
  • Remove Content – indicates whether the content of folder should be removed, or process should be aborted, if the target folder already contains any data
  • Connect to – allows to connect to the remote server using bookmarks or connect dialog
  • Objects Tree – shows the opened connections and available databases. here you should select the target database.
  • Filter – allows to filter the Objects Tree
  • Snapshot Kind – the kind of snapshot. Currently only Script Folder is available.

Create Snapshot Result

Creating the snapshot can be finished successfully or with errors.

Success Result

  • Show On Disk – opens the file manager in place where snapshot was created

Result With Errors

  • Erors Table – shows the list of occured errors
  • Show On Disk – opens the file manager in place where snapshot was created

Finally you can open the file manager to see the snapshot:

Load Snapshot Wizard

The Load Snapshot Wizard consists of two steps. At first you should to define snapshot participants and properties. Than the wizard will load a snapshot into the selected database and will show the result.

Load Snapshot Properties

  • Snapshot Folder – the path to the folder where snapshot should be saved
  • Ignore Snapshot Errors – indicates whether the wizrd should to load snapshot if it contains errors (for example sme file was not created), or should to abort loading
  • Connect to – allows to connect to the remote server using bookmarks or connect dialog
  • Objects Tree – shows the opened connections and available databases. here you should select the target database.
  • Filter – allows to filter the Objects Tree

Load Snapshot Result

Loading the snapshot can be finished successfully or with errors.

Success Result

Result With Errors

If loading was performed with errors this page will show them with specification of snapshot files and queries.

  • Errors Table – shows the list of occurred errors
  • Query – shows the query for selected error if any
  • Show On Disk – opens the file manager in place where snapshot was created

Related

  • Source Control – Commit, Evaluation to Commit, and Migrate database schema
  • SQLDIFF – Compare and evaluate schema of two databases, generate scripts