Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
  1. DB Best Documentation
  2. Migration Platform
  3. Data store
Migration Platform
  • Overview
  • Product features
    • Release notes
    • Source and target platforms
    • Third-party applications
  • Getting started
    • Creating a new project
    • Ora2Pg installation
    • Tree view filtering
    • Compatible ODAC versions
    • Opening an existing project
    • Connecting to servers
      • Connecting to an Azure SQL Database
      • Connecting to an Oracle database
      • Connecting to a PostgreSQL database
      • Connecting to a Microsoft SQL Server database
    • Command timeout
  • Mapping
    • Object mapping
    • Error mapping rules
    • Data types mapping
  • Schema conversion
  • Schema comparison
  • Data comparison
  • Data migration
    • Migration task
      • Creating migration tasks
      • Templates
      • Migration options
      • Task actions
      • Task statuses
      • Errors or non-standard situations
    • Installing migration agent
      • Installing and uninstalling the data migration agent
      • Registering the migration agents
    • Project settings
  • Test organizer
    • Creating tests
    • Auto-generating tests
    • Groups and tests execution
    • Groups and tests states and execution statuses
    • Tests moving logic
    • Importing and exporting tests
    • Advanced comparison options
    • Creating reports
    • Error handling
  • Data store
  • Development project
  • System requirements
  • Hot keys
  • Known issues
  • Support

Data store

  • Share
    • Share via Facebook
    • Share via Twitter
    • Share via Linkedin

​The Data Store module allows for creating and storing database snapshots (datasets) so that you can backup and restore them as part of your development, testing, and deployment processes.

To start working with Data Store, you should first click the Refresh button at the bottom left corner of the main field. By clicking it, the program updates the information for both the Source and Target databases.

Data store refresh button

Figure 1. Refresh button

Then, to enable Data Store functionality, you should install an extension pack for both the Source and Target databases. To do that, go to the data element you want to store, right-click on it, and select “Install extension pack“.

Data store extension pack install

Figure 2. Installing extension pack

Once installed, the selected data element will display with a black checkmark and the Packages list will contain the PKG_DATASTORE package.

Creating datasets

To create a dataset, follow these steps:

  1. Select the objects in the metadata tree that you want to store. That can be tables or nodes that contain table nodes.
  2. Select the Create dataset option in the context menu of the metadata tree.

Create context menu

Figure 3. Create dataset option

To add new tables to an existing dataset, select proper tables in the review metadata, right-click on each of them, and click Add to dataset.

Note: You cannot create a dataset for the data objects that contain LONG datatype, VDT columns, virtual columns or global temporary tables. If a data object wasn’t added to a dataset, the Warning column will show the reason for each of them.

  1. In the Dataset window specify the dataset name and description.

Dataset creation menu

Figure 4. Finalizing dataset creation

  1. Click the Save button to create a list of data objects you want to back up.

When done, the created datasets appear in the list in the main field of the Data store module.

Dataset list

Figure 5.  List of the datasets in the Data Store module

Backing up datasets

To back up a whole dataset or certain tables, click on the pencil icon to open the Dataset windows, choose the proper tables, and click the Backup button.

When the backup operation is complete, the dataset status in the State field changes.

There can be three possible values:

  • Partial backed up (checkmark with a red circle) — only a part of all the tables from a dataset was successfully restored.
  • Backed up (checkmark) — all the tables from a dataset were successfully restored.
  • Error (red cross) — the process wasn’t completed.

Backup and restore tables

Figure 6. Backup operation completed

Restoring datasets

To restore a whole dataset or its elements, click on the pencil icon to open the Dataset window, choose the proper elements, and click the Restore button.

Removing datasets

To remove a whole dataset, click the bucket button and confirm deleting in the dialog window.

Remove dataset

Figure 7. Deleting a dataset

To remove separate tables from a dataset, click the pencil button, select proper tables, and click Save.

Remove selected dataset tables

Figure 8. Deleting separate dataset tables


Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].

Did this page help you?

Provide Feedback
PreviousError handling
Next System requirements

Did this page help you? Yes

Thanks for letting us know that we did a great job.

Did this page help you? No

Thanks for letting us know that there is a problem on this page.

Send Feedback

Feel free to share your ideas or occurred issues with us. The DB Best team will be happy to make our documentation better.

Please, specify your email address so that we can reach out to you to clarify your question. Also, we will use this email address to notify you about solving the issue.

* marks the mandatory fields

Dark theme Light theme

© 2002–2021 DB Best Technologies, LLC. All rights reserved.