This website uses cookies to ensure you get the best experience on our website.
Learn more
OK
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Liberate your data.
Skip main navigation (Press Enter).
Toggle navigation
Communities
Announcements
Delphix Products
Data Company Central
All Communities
Events
DevOps + Data Impact 2024
Upcoming Events
Champions
Become a Champion!
Browse
Discussion Posts
Events
Library Entries
Documentation
Blogs
Webinars
Academy
Delphix Products
View Only
Community Home
Discussion
6K
Library
169
Blogs
113
Events
0
Members
5.8K
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
1
Recommend
Delphix FAQs
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 n
ote 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
×
New Best Answer
This thread already has a best answer. Would you like to mark this message as the new best answer?
Related Content
SDK Implement script bash in artifact
Eugenio -
Added 09-13-2019
Discussion Thread
4
post script with autorefresh
Anup Anand
Added 06-23-2014
Discussion Thread
3
TDM Implementation
Sreshtha Das
Added 06-14-2021
Discussion Thread
4
Running post script for EVERY VDB that is created from a source
Mark Hayter
Added 09-09-2016
Discussion Thread
2
Data Control Tower (DCT) - Access Control Implementation
Nicholas Mathison
Added 05-26-2023
Blog Entry
Copyright 2023. All rights reserved.
Powered by Higher Logic