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


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


  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
    delphix database provision *> set"<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 repository.

    delphix database provision *> set sourceConfig.repository=targetEnv/SQLServer2008
  8. Commit the result.

    delphix database provision *> commit