Execute Data Scripts via RedGate Tasks on TFS?
mkumar
Posts: 8 New member
Can I deploy/execute data scripts from a source control (with a custom folder in it) to the database via RedGate Tasks on TFS 2018 without using Visual Studio or SSMS? Assuming I know the target database, SQL Server credentials...
Tagged:
Answers
You can use the PowerShell Module of SQL Change Automation (SCA) to deploy between your source control application to a target database.
Best place to start would be the help documentation for SCA, available here.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com