Execute Data Scripts via RedGate Tasks on TFS?

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

  • Eddie DEddie D Posts: 1,807 Rose Gold 5
    Hi, thank you for your support request.

    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.