CLI cookbook: provisioning the SQL Server AG VDB

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

Prerequisites

You will need the following information:

The name of the AG VDB you want to create
The group in which to create the AG VDB
The SQL Server database name for the AG 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 environment on which you want to create the AG VDB. You can list the environments with the /environment list command.
The target repository (SQL Server Availability Group on the target environment) in which to create the AG VDB. These can be listed with the /repository list command.

Procedure

Execute the database provision command.
```
delphix> database provision
```
Execute the defaults command.
```
delphix database provision> defaults
```

Set the timeflow point parameters such as parent SQL server container and location for AG VDB provision.

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

Commit the operation to populate the defaults, as the browser interface provides. 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
```

Set the name and group for the new AG VDB.

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

Set the SQL Server instance for the new AG VDB to MSSqlAvailabilityGroupDBConfig.

delphix database provision *> set sourceConfig.type=MSSqlAvailabilityGroupDBConfig

Set the database name for the AG VDB on the target SQL Server AG cluster instance.
```
delphix database provision *> set sourceConfig.databaseName=vexample 
```

Set the target repository.

delphix database provision *> set sourceConfig.repository=targetAg

Set the database recovery model to FULL for the AG VDB.

 delphix database provision *> set sourceConfig.recoveryModel=FULL

Set the allowAutoVDBRestartOnHostRebootattribute to true.

delphix database provision *> set source.allowAutoVDBRestartOnHostReboot=true

Set the agProvisionConfig attribute for the AG VDB.

delphix database provision *> set source.agProvisionConfig.backupBased=true

For more details on ` agProvisionConfig.backupBased` please refer here.

Commit the result.
```
delphix database provision *> commit 
```