Delphix Products

 View Only
Back to discussions
Expand all | Collapse all

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

  Thread closed by the administrator, not accepting new replies.

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

    Posted 06-12-2014 05:17:00 PM
    No replies, thread closed.
    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.
    #sql
    #scripts
    #sqlserver