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
------------------------------
Original Message:
Sent: 12-05-2022 03:43:35 PM
From: Paul Vero
Subject: Powershell Script to initiate a particular VDB refresh with most recent snapshot
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
Original Message:
Sent: 12-01-2022 03:07:02 PM
From: Chris Patton
Subject: Powershell Script to initiate a particular VDB refresh with most recent snapshot
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
------------------------------