Documentation 5.0

Release Information

Introduction

Getting Started

Delphix Engine System Administration

Virtual Database Management with the Delphix Engine

Data Backup and Recovery

Delphix Modernization Engine

Delphix Masking

Virtualizing Unstructured Files in the Delphix Engine

Virtualizing Oracle E-Business Suite in the Delphix Engine

JetStream

Mission Control

Delphix Express User Guide

Reference

Documentation for Previous Versions of the Delphix Engine

Delphix Server 3.0 Documentation
Delphix Server 3.1 Documentation
Delphix Engine 3.2 Documentation
Delphix Engine 4.0 Documentation
Delphix Engine 4.1 Documentation
Delphix Engine 4.2 Documentation
Delphix Engine 4.3 Documentation

Skip to end of metadata
Go to start of metadata

This topic describes how to provision a SQL Server VDB using the command line interface.

Prerequisites

You will need the following information:

  • The name of the VDB you want to create
  • The group in which to create the VDB
  • The SQL Server database name for the VDB
  • The source dSource or VDB from which you wish to provision

  • The semanticLocation, LSN, or timestamp of the point you want to provision from. You can run these commands to get the list of snapshots or timeflow ranges:

    snapshot list database=dexample
timeflow "dexample" timeflowRanges; commit
  • The target host on which you want to create the VDB. You can list the hosts with the /host list command.

  • The source repository (SQL Server instance on the target host)  in which to create the VDB. These can be listed with the /repository list command.

Procedure

  1. Execute the database provision command.

    delphix> database provision

  2. Execute the defaults command.

    delphix database provision> defaults

  3. Set the timeflow point source timeflow and location.

    delphix database provision defaults *> set type=TimeflowPointSemantic
delphix database provision defaults *> set container=dexample
delphix database provision defaults *> set location=LATEST_SNAPSHOT

  4. Commit the operation to populate the defaults, as provided by the browser interface. At this point, the operation can be committed, though you will likely need to change the defaults to match the information.

    delphix database provision defaults *> commit

  5. Set the name and group for the new VDB.

    delphix database provision *> set container.name=vexample
delphix database provision *> set container.group="<New Group>"

  6. Set the database name for the VDB on the target SQL Server instance.

    delphix database provision *> set sourceConfig.databaseName=vexample

  7. Set the target host.

    delphix database provision *> edit sourceConfig.instance
delphix database provision sourceConfig.instance *> set host=targethost
delphix database provision sourceConfig.instance *> back

  8. Set the target repository.

    delphix database provision *> set sourceConfig.repository=targetEnv/SQLServer2008

  9. Commit the result.

    delphix database provision *> commit