Database Project merge in TFS

• Jayakumar.kaliappan

  SSC Enthusiast

  Points: 128

  More actions

  September 19, 2013 at 4:35 pm

  #298946

  Hi,

  We are using VS 2010 TFS database project for version control and deployment. However I would like to know the best practices for merging the changes from one branch to another. Here is the details below on the TFS branching

  Main

  - UAT

  - QA

  - DEV

  All our development work is being checked in at the DEV branch and after that we want to merge the development changes into QA followed by UAT branches.

  Currently I am using DB Schema compare option to merge the changes from DEV--> QA and QA-->UAT etc.

  This approach is manual and it needs lot of effort if the changes are more and moreover the DB compare does not clean and easy to use for merging whereas it will show the changes in components which does not have any change at all etc...

  So please help me with the best approach on merging DB projects.