TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Stephen Raj
NA
6
600
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.
Reply
Answers (
2
)
insert Query for sql server
Create a Table script