Delphix Products

Tip of the Day: Renaming a SQL Server VDB

  Thread closed by the administrator. It is viewable, but not accepting new replies.
  • 1.  Tip of the Day: Renaming a SQL Server VDB

    Posted 09-02-2014 04:51:00 PM
    No replies, thread closed.
    Note: The database name that is changed in this procedure is what you would see under the SQL Server instance on the target environment and is on the back of the VDB card. The name of the VDB object itself is a name internal to Delphix and is what you see on front of the VDB card.

    1. Select the source associated with the VDB.
    delphix > source "vexample"

    2. Select the source configassociated with the source.
    delphix source "vexample" >: get config       vexample
    delphix source "vexample" > /sourceconfig "vexample"
    delphix sourceconfig "vexample" >

    3. Update the databaseNameto the new name.
    delphix sourceconfig "vexample" > update
    delphix sourceconfig "vexample" update *> set databaseName=newDBName
    delphix sourceconfig "vexample" update *>: commit
    delphix sourceconfig "vexample" >