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:

• Main Menu → Tools
  • Create Schema Snapshot
  • Load Schema Snapshot

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.

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.

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.

• 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.

Creating the snapshot can be finished successfully or with errors.

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

• 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:

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.

• 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

Loading the snapshot can be finished successfully or 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