Deploy static data

Deploying static data involves transferring and integrating fixed datasets, such as reference tables, configuration settings, and predefined lists, across different environments.

Prerequisite

  • Clone a repository to a local scripts folder.

Workflow

Deploying static data includes the following steps:

1. Comparing a scripts folder that stores the repository with the database.

2. Synchronizing the data.

Tip

You can create a scripts folder by using the Create Scripts Folder or Snapshot dialog or Generate Scripts Wizard.

Compare a scripts folder with the database

1. Open the New Data Comparison wizard in one of these ways:

  • In the top menu, select Comparison > New Data Comparison.
  • On the Start Page, select Database Sync > New Data Comparison.

2. Select the source and target data sources:

  • Under Source:

    1. In Type, select Scripts Folder.

    2. In Database Scripts Folder, click the ellipsis (…) to select a scripts folder whose data you want to compare to the target database.

  • Under Target:

    1. In Type, select Database.

    2. In Connection, select the server connection for the target database.

    3. In Database, select the target database.

3. Optional: On the Options page, configure the comparison options.

4. Click Compare.

The Data Comparison document opens, displaying the comparison results. Use checkboxes to include or exclude objects and records for synchronization.

Synchronize the data

1. At the top of the document, click Synchronize data to the target database to open the Data Synchronization Wizard.

2. Select the output option to generate a synchronization script.

3. Click Synchronize.