Stephen Raj

Stephen Raj

  • 2k
  • 6
  • 200

How to refresh SQL server databases with new SQL objects from TFS

Jul 20 2020 2:16 PM
Hi - I'm in the process of builiding a VSTS/TFS pipeline to build and release automation scripts. Before building  C# Automation scripts I need ot ensure that the databases in QA SQL server contains the latest SQL objects like (Functions, Stored Procedures, Tables, new columns etc) are added to the QA SQL server databases. Manually I used to right click on the folders in TFS and select 'Get Latest'; however in VSTS/TFS pipeliene I cannot do it manually so please guide me how to get the latest SQL objects from TFS server to QA SQL Server dataabases using the Build Pipeline.  

Answers (2)