Delphix Products

 View Only
  • 1.  Powershell Script to initiate a particular VDB refresh with most recent snapshot

    Posted 12-01-2022 03:07:00 PM
    Hello, we are a "Windows shop" and run 99% SQL server for our databases. Is there a way to invoke a Delphix engine command via Powershell *from* a Windows server that will initiate a VDB refresh with the most recent snapshot? I'm thinking the PS script would call a dxtoolkit script?

    ------------------------------
    Chris Patton
    Database Adminstrator, Sr
    CalOptima
    ------------------------------


  • 2.  RE: Powershell Script to initiate a particular VDB refresh with most recent snapshot
    Best Answer

    Posted 12-05-2022 03:44:00 PM

    Hi Chris,
    I am pretty sure you can do that.  We execute SQLCMD.exe from Powershell and other windows commands via shell scripts for the dataset operations so you ought to be able to invoke the dxtoolkit commands from Powershell.  You'd call https://github.com/delphix/dxtoolkit/wiki/dx_refresh_db, and by default it uses the most recent snapshot.

    Cheers,



    ------------------------------
    Paul Vero
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------



  • 3.  RE: Powershell Script to initiate a particular VDB refresh with most recent snapshot

    Posted 12-06-2022 11:03:00 AM
    Thank you, Paul. I'm hoping there is an existing example out there somewhere as I am not a proficient programmer. We have an Operations Team that would ultimately be calling the script, and again, it would be a call initiated from a Windows Server to a PS script that would be invoking a command in the dxtoolkit on the Ubuntu Linux Delphix Engine.

    ------------------------------
    Chris Patton
    Database Adminstrator, Sr
    CalOptima
    ------------------------------



  • 4.  RE: Powershell Script to initiate a particular VDB refresh with most recent snapshot

    Posted 12-06-2022 11:54:00 AM
    Hi Chris,

    I found this as well - we have this KBA with some resources that might prove useful:

    https://support.delphix.com/Support_Policies_and_Technical_Bulletins/Support_Policies/How_To_Obtain_Support_for_DxToolkit_(KBA1842)

    As for the specific Powershell calling it should be not an issue - As long as the script has access to where dxtoolkit exists on Windows you should be fine.

    Cheers,

    ------------------------------
    Paul Vero
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------