This topic describes how to provision a virtual database (VDB) from a SQL Server dSource.
- You must have already linked a dSource from a source database, as described in Linking a SQL Server dSource, or have already created a VDB from which you want to provision another VDB.
- You must have already set up Windows target environments and installed the Delphix Connector on them, as described in Adding a SQL Server Standalone Target Environment.
- Make sure that you have the required privileges on the target environment as described in Setting up and Configuring Delphix for SQL Server.
- If you are provisioning to a different target environment than the one where the staging database has been set up, make sure that the two environments have compatible operating systems, as described in Setting up and Configuring Delphix for SQL Server. For more information on the staging database and the validated sync process, see Overview of Setting Up SQL Server Environments.
- Login to the Delphix Management application.
- Click Manage.
- Select Datasets.
- Select a dSource.
- Click TimeFlow tab.
- Next to a snapshot select the
The Provision VDB panel will open, and the Database Name and Recovery Model will auto-populate with information from the dSource. Provision VDB icon.
- Select a target environment.
- Select an Instance to use.
If the selected target environment is a Windows Failover Cluster environment, select a drive letter from Available Drives. This drive will contain volume mount points to Delphix storage.
Windows Cluster Volume Management Software Requirements
Only cluster volumes managed by the native Windows Volume Manager are supported. For example, cluster volumes managed by Veritas VxVM are not supported.
If you use third-party volume management software, create a new LU (recommended to be 10GB in size) and add this LU as a clustered resource to the SQL Server instance using native Windows volume management tools. Assign a drive letter for this LU. You can then use this LU as the volume mount point location for Delphix VDB provisioning.
- Enter a VDB Name and select a Target Group for the VDB.
- Enable Auto VDB Restart to allow the Delphix Engine to automatically restart the VDB when it detects target host reboot.
- Click Next.
- Select a Snapshot Policy for the VDB. Click Next.
- Specify any Pre- or Post-Scripts that should be used during the provisioning process.
- For more information, see Customizing SQL Server VDB Management with Hook Operations.
- Click Next.
- The final summary tab will enable you to review your configurations.
- Click Submit.
When provisioning starts, the VDB will appear in the Datasets panel. Select the VDB and navigate to the Status tab to see the progress of the job. When provisioning is complete, you can see more information on the Configuration tab.
You can select a SQL Server instance that has a higher version than the source database and the VDB will be automatically upgraded. For more information about compatibility between different versions of SQL Server, see SQL Server Operating System Compatibility Matrices.
Provisioning by Snapshot or LogSync
When provisioning by snapshot, you can provision to the start of any particular snapshot, either by time or LSN.
You can take a new snapshot of the dSource and provision from it by clicking the Camera icon.
|Provisioning By Snapshot||Description|
|Provision by Time|
You can provision to the start of any snapshot by selecting that snapshot card from the TimeFlow tab, or by selectingand entering a value in the time entry fields. The values you enter will snap to the beginning of the nearest snapshot.
|Provision by LSN||You can use Provision by LSN control to open the LSN entry field. Here, you can type or paste in the LSN to which you want to provision. After entering a value, it will "snap" to the start of the closest appropriate snapshot.|
Automatic VDB Restart on Target Server After Reboot
This feature is not supported for the following data source types:
- Oracle RAC VDBs
- Oracle 12c vPDBs that are provisioned into a non-virtual CDB.
- MSSQL cluster VDBs.
Automatic VDB Restart is supported for Oracle 12c vPDBs that are provisioned into a virtual CDB. User can choose to enable or disable automatic restart at the virtual CDB level. There is not individual vPDB automatic restart setting.
To enable automatic restart, complete the following steps:
- When provisioning a new VDB in the VDB Provisioning wizard, check the Auto VDB Restart box.
- Once the VDB has been provisioned, you will be able to turn Automatic VDB Restart on.
In the Datasets panel, select the VDB.
Select the Configuration tab.
Select the Source sub-tab.
- Select Database edit.
- Linking a SQL Server dSource
- Adding a SQL Server Standalone Target Environment
- Adding a SQL Server Failover Cluster Target Environment
- Setting up and Configuring Delphix for SQL Server
- Overview of Setting Up SQL Server Environments
- Using Pre- and Post-Scripts with SQL Server VDBs
- Customizing SQL Server VDB Management with Hook Operations
- Additional VDB Topics