No announcements
Found 3870339 threads
-
0 VotesHow to execute sql scripts after deployment using webdeploy 3.0?
User-166373564 posted Hi, As we know, Web Deploy enables us to not only publish files – but also provision database schema/data, run ...Answered | 2 Replies | 121 Views | Created by Anonymous - Wednesday, June 19, 2013 7:38 AM | Last reply by Anonymous - Monday, June 24, 2013 8:44 AM
-
2 Votes
SQL script automation deployment
Hi there, One way of doing it is SQl agent job with multi step. every step you can include your script which executes similer from executing cmp ...Answered | 2 Replies | 4167 Views | Created by Krish Tucker - Friday, December 21, 2012 11:38 AM | Last reply by Kumar muppa - Friday, December 21, 2012 11:54 PM -
0 Votes
Scheduling UIAutomation scripts execution after build deployment.
Hi Basava Refer the following ...Answered | 1 Replies | 3812 Views | Created by Basava Kumar M - Thursday, May 5, 2011 7:35 AM | Last reply by Deepak.Singhal [MSFT] - Thursday, May 5, 2011 10:05 AM -
1 Votes
TFS 2012 / SQL Scripts / Deployment options
I've started to look at this problem a bit differently - if I can execute a post-build command I could include the db scripts in the deployment package, run them on the ...Answered | 11 Replies | 2328 Views | Created by BlakeDuffey - Thursday, October 24, 2013 6:05 PM | Last reply by BlakeDuffey - Wednesday, October 30, 2013 1:59 PM -
0 Votes
How to Execute any T-SQL script after database Restore
One other option is you can read the error log and look for "RESTORE DATABASE" operation and if there is any such event, you can trigger to execute the ...Answered | 1 Replies | 4087 Views | Created by Amandeep Dhindsa - Sunday, March 31, 2013 11:46 AM | Last reply by Stan210 - Monday, April 1, 2013 3:00 AM -
1 Votes
Script task does not work after deployment but with no errors
How do you generate the ispac from Visual Studio?Answered | 10 Replies | 1914 Views | Created by Increment a variable value within a SP per job - Wednesday, March 11, 2020 2:35 PM | Last reply by Yitzhak Khabinsky - Wednesday, March 25, 2020 3:44 PM -
0 Votes
How to execute SQL scripts in batch
you can use sqlcmd https://msdn.microsoft.com/en-us/library/ms162773.aspx other options are ...Answered | 2 Replies | 1191 Views | Created by Balushanmugham - Wednesday, April 8, 2015 8:49 AM | Last reply by Visakh16 - Wednesday, April 8, 2015 9:05 AM -
6 Votes
How to include all SQL scripts in a folder in post deployment script
Use a powershell script as suggested to loop through the folder and then add the paths into the post deployment script.Answered | 6 Replies | 5929 Views | Created by Anitha_Thanam - Thursday, February 20, 2014 10:10 AM | Last reply by rrjamesjr81 - Friday, May 12, 2017 9:06 PM -
1 Votes
How to execute an SQL Script with GO statements without using SQL SMO
Hello, You can use the SqlCmd.exe tool to run the script; it can interpret the GO as batch separator.Answered | 1 Replies | 7852 Views | Created by Nishit19 - Tuesday, December 21, 2010 5:51 AM | Last reply by Olaf Helper - Tuesday, December 21, 2010 8:07 AM -
5 Votes
Many Sql scripts to execute
See my blog about the subject http://dimantdatabasesolutions.blogspot.co.il/2009/01/executing-multiple-script-file-via.html Best Regards,Uri Dimant ...Answered | 5 Replies | 1467 Views | Created by waqar100 - Saturday, February 16, 2013 4:47 PM | Last reply by Uri Dimant - Monday, February 18, 2013 10:42 AM -
0 Votes
Customising WebDeploy URL used by Visual Studio (2015) during publishing
Hello, I'm using (and administering) WebsitePanel hosting software which is generating publishing profiles for websites WebDeploy publishing functionality.Answered | 2 Replies | 841 Views | Created by Webio - Monday, January 25, 2016 1:37 PM | Last reply by Weiwei Cai - Wednesday, January 27, 2016 5:37 AM -
2 Votes
How to create Batch file to execute sql scripts
Are going to use windows auth or sql auth.Answered | 15 Replies | 181660 Views | Created by Ravi_P - Thursday, October 7, 2010 11:35 AM | Last reply by Rao chandan - Tuesday, June 24, 2014 10:37 AM -
0 Votes
Automating SQL Script Deployment
You can use SQL Server Data Tools (SSDT) project and using its SQL compare feature.Answered | 1 Replies | 986 Views | Created by NCIII - Monday, July 13, 2015 7:11 PM | Last reply by Saeid Hasani - Monday, July 13, 2015 7:21 PM -
0 Votes
SQL SMS Script Execution
Provided that you are using SQL Server 2008 (or 2008 R2) in SQL Server Managment Studio the little green arrow is Debug.Answered | 2 Replies | 6651 Views | Created by active47 - Monday, May 30, 2011 8:25 PM | Last reply by active47 - Monday, May 30, 2011 9:06 PM -
0 Votes
SQL DDL Scripts execution
Abby, SQLCMD can execute one input file (.sql).Answered | 4 Replies | 9438 Views | Created by Abby M - Monday, October 12, 2009 7:10 AM | Last reply by Kalman Toth - Saturday, October 31, 2009 3:36 PM -
1 Votes
How to run Sql script using Release management
You should add your SQL script to source control and make sure that it is part of the build output.Answered | 1 Replies | 3302 Views | Created by Narasimha Murthy Sirisinahal - Wednesday, October 7, 2015 8:39 PM | Last reply by Jakob Ehn - Thursday, October 8, 2015 12:44 PM -
0 Votes
If there is no SQL script in the deployment package, how can I skip "SQL stage" of the release path?
Hi Teirli, If you have two build definitions, you can trigger the release path after the build completed.Answered | 3 Replies | 492 Views | Created by Tireli Efe - Thursday, December 17, 2015 8:19 AM | Last reply by Shrek L - Monday, December 21, 2015 6:24 AM -
3 Votes
How to use <PreDeployEvent> to execute pre-predeployment script?
The problem is, how to pass connection VS uses on deployment.Answered | 7 Replies | 7157 Views | Created by Sinix - Thursday, February 11, 2010 7:37 AM | Last reply by Sinix - Wednesday, September 21, 2011 12:00 AM -
0 Votes
Multiple Post-Deployment Scripts
Ok, I see how it works now.Answered | 2 Replies | 6231 Views | Created by psidari - Wednesday, September 16, 2009 6:23 PM | Last reply by psidari - Thursday, September 17, 2009 4:16 PM -
0 Votes
Scripting the SSAS Deployment Wizard
I used "/s:c:\data\deploy.log /o:c:\data\test.xmla" and I got both a log and an output xmla script.Answered | 11 Replies | 3818 Views | Created by Todd C - Thursday, November 17, 2011 9:00 PM | Last reply by Darren Gosbell - Thursday, November 24, 2011 5:16 AM - Items 1 to 20 of 3870339 Next ›
No announcements
