Renaming a SQL Server VDB via CLI
Delphix Administration / SQL Server Environments and Data Sources / Virtualizing Databases Using Delphix with SQL Server / Managing SQL Server VDBs / Additional VDB Topics / Renaming a SQL Server VDB via CLI

This topic describes how to change the database name on the SQL Server Instance for VDB through the Delphix CLI.

Database name on SQL Server vs. VDB name on Delphix

The database name is what you would see the SQL Server instance on the Target in SQL Server Management Studio or sys.databases. It is also the database name in the Configuration tab in Delphix.

The name of the VDB is an internal name within Delphix Engine and does not need to be the same as the database name on the Target. This is found on the Status tab of Delphx.

Prerequisites

  • The VDB must be running on the target environment.
  • The SQL server instance on the target environment where the VDB is located must be up and reachable.

Procedure

  1. Select the source associated with the VDB and disable the VDB.

    delphix> source "vexample"
    delphix source 'vexample'> disable
    delphix source 'vexample' disable *> commit

  2. Select the source config associated with the source.

    delphix source "vexample" > get config
         vexample
    delphix source "vexample" > /sourceconfig "vexample"
    delphix sourceconfig "vexample" >

  3. Update the databaseName to the new name.

    delphix sourceconfig "vexample" > update
    delphix sourceconfig "vexample" update *> set databaseName=newDBName
    delphix sourceconfig "vexample"   update *> commit
    delphix sourceconfig "vexample" >cd

  4. Enable the VDB.

    delphix> source "vexample"
    delphix source 'vexample'> enable
    delphix source 'vexample' enable *> commit