Skip to main content

Create a sandbox clone in Workload Factory for Databases

Contributors netapp-rlithman

Creating a sandbox clone of a database in Workload Factory for Databases lets you use the clone for development, testing, integration, analytics, training, QA, and more without altering the source database.

About this task

A sandbox clone is created from the most recent snapshot on the source database. It may be cloned in the same Microsoft SQL Server as the source database or cloned in another Microsoft SQL Server as long as they share the same FSx for ONTAP file system.

Before you begin

Ensure you complete the following prerequisites before you create a sandbox clone.

Credentials and permissions

You must have AWS account credentials and read or automate mode permissions to create a sandbox clone in Workload Factory.

Alternatively, you can use the Codebox to copy a partially completed template or create a completed template so that you can create the sandbox clone outside of Workload Factory using REST API. Learn more about Codebox automation.

Microsoft SQL Server

You must have a managed Microsoft SQL Server in Workload Factory for Databases to host the new sandbox clone.

AWS Systems Manager

Ensure the NT Authority\SYSTEM user privilege is enabled in the Microsoft SQL host via AWS Systems Manager.

Source database

You need a source database available for the clone.

Steps
  1. Log in to the Workload Factory console.

  2. In the Databases tile, select Go to Databases Inventory.

  3. In Databases, select the Sandboxes tab.

  4. In the Sandboxes tab, select Create new sandbox.

  5. On the Create new sandbox page, under Database source, provide the following:

    1. Source database host: Select the source database host.

    2. Source database instance: Select the source database instance.

    3. Source database: Select the source database to clone from.

  6. Under Database target, provide the following:

    1. Target database host: Select a target database host for the sandbox clone that is in the same VPC and has the same FSx for ONTAP file system as the source host.

    2. Target database instance: Select the target database instance for the sandbox clone.

    3. Target database: Enter a name for the sandbox clone.

  7. Mount: When cloning a SQL database that has multiple data and/or log files, Workload Factory clones all files under the auto-assigned or defined drive letter.

    Select one of the following options:

    1. Auto-assign mount point

    2. Define mount point path

      Provide the following to define the mount point path:

      • Enter the drive letter for the data file path.

      • Enter the drive letter for the log file path.

  8. Define tag: Select a tag to define the sandbox clone.

  9. Click Create.

To check the job's progress, go to the Job monitoring tab.