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

Stephen Raj

6y887

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Stephen Raj6y ago
Thank you Atul but those links provides only generic info. Basically folks are saying PowerShell script can be written to build all SQL objects from TFS and include a PowerShell task in Build pipeline. I'm not sure about writing a PowerShell script that would take all latets SQL objects from TFS server and build.
0
Atul Warade6y ago
Hi Stephan,

Please check below URL it might help you

https://stackoverflow.com/questions/187936/how-can-i-add-sql-server-database-objects-to-tfs

https://www.c-sharpcorner.com/UploadFile/31514f/database-tracking-in-sql-through-tfs/
0