August 7, 2019 at 2:47 am
Hi,
Is there a better and effective way to validate the changes auto deployed using TFS. I have been using scheme compare report in SSMS and validate with the list of changes which were auto deployed and verify however I was thinking can this verification or validation process be automated or done in more efficient way. Now, when I say changes it can be SP's, views or tables to the databases which DEV team pushes via auto deploy in TFS. Honestly, I do not know how they are trying to auto deploying like generating script in VS and running need to confirm.
The problem with manual verification process is think about 70 changes deployed and now you need to pull the schema compare report and verify one by one which is time consuming and I feel it can be more efficeint process.
Please advise.
Thanks,
August 7, 2019 at 3:14 pm
This sentence doesn't quite make sense: Honestly, I do not know how they are trying to auto deploying like generating script in VS and running need to confirm
Doesn't your schema compare report, post deploy, show that everything from TFS is in sync? If you have in flight work, you should be asking they release from a release branch to version stamp what has been released.
August 7, 2019 at 3:37 pm
Thanks for your reply.
Let me check how they are trying to deploy and will get back to you. I am sure it is TFS however not aware of the complete auto deployment process.
Let us say, if there is Manual deployments, we rebuilt the .sln and publish and generate the script in VS for desired server. After generating you will run the script (SSMS) in the desired environment example adventureworks and commit the changes.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply