Delphix Products

 View Only
Back to discussions
Expand all | Collapse all

Tip of the Day: Using the CLI to Provision a SQL Server VDB

  Thread closed by the administrator, not accepting new replies.

  • 1.  Tip of the Day: Using the CLI to Provision a SQL Server VDB

    Posted 07-07-2014 04:31:00 PM
    No replies, thread closed.
    Please note you will need the following information prior to provisioning a VDB
    • 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. 
    • 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.

    Procedure:
    1. Execute the database provision command
         delphix > ls
         delphix > database
         delphix database > provision
    2. Execute the defaults command
         delphix database provision > defaults
    3. Set the time flow 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 container.name=vexample
         delphix database provision *> set container.group="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 host
         delphix database provision *> edit sourceConfig.instance
         delphix database provision sourceConfig.instance *> set host=targethost
         delphix database provision sourceConfig.instance *> back
    8. Set the target repository 
         delphix database provision *> set souceConfig.repository=targetEnv/SQLServer2008
    9. Commit the result.
         delphix database provision *> commit
    #provision
    #tip
    #cli
    #sql
    #sql_server
    #vdb
    #delphix