CLI cookbook: provisioning a SQL server VDB

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:

  CODE

  snapshot list database=dexample
  snapshot list timeflow=dexample
  snapshot list fromDate="2020-03-01T00:00:00.000Z" toDate="2020-03-04T11:31:27.883Z"

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

   CODE

   delphix> database provision

2. Execute the defaults command.

   CODE

   delphix database provision> defaults

3. Set the timeflow point source timeflow and location.

   CODE

   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.

   CODE

   delphix database provision defaults *> commit

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

   CODE

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

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

   CODE

   delphix database provision *> set sourceConfig.databaseName=vexample

7. Set the target repository

   CODE

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

8. Commit the result.

   CODE

   delphix database provision *> commit