Tip of the Day: Implementing SQL Server Pre- and Post-Scripts

  • 1
  • Announcement
  • Updated 4 years ago
For SQL Server, both dSource and VDB scripts can be either text or binary executables.
  • For SQL Server dSources, pre- and post-scripts are incorporated into the validated sync process. 
  • For SQL Server single instance environments, scripts must exist and be readable on the staging environment.
  • Scripts can also be run as part of the SQL Server VDB provisioning process, in which case they must exist and be readable on the target environment.
Please note that pre-scripts are executed before the SnapSync policy, and if the script fails, SnapSync will fail as well. In the case of a post-script, the script will execute after SnapSync is complete. If a post-script fails, you will see an error message.
Photo of Delphix FAQs

Delphix FAQs, Official Rep

  • 4,000 Points 4k badge 2x thumb

Posted 5 years ago

  • 1
Photo of Piotr Goliasz

Piotr Goliasz

  • 980 Points 500 badge 2x thumb
Can you share some basic power shell scripts, please? Just some examples. What environment variables are available to such scripts?