My version control experience was one of two options. If you use SQLExpress user instance databases (this is mdf in the App_Data folder), I find that all versions other than this database file and the dataconfig.config file in the configuration folder will allow each developer to run their own copy of the website.
from there you can do some kind of manual database merge or just create a new one for deployment.
This option works best if your developers just work on the features and donβt need to work on a real website, changing the content that should be synchronized.
Alternatively, if they need to work with live content and everything should be the same, create a database on a shared server that everyone has access to and change everything (since the connection string should be the same for both).
This works best if your developers do the job of supporting existing content, rather than creating modules that manage the database (creating tables, columns, etc.), because keep in mind this method, everyone will have access and modify the same database.
Personally, I prefer option 1, because it allows each developer to fully control their environment. the source can then be combined and shaded onto an intermediate server, so that only one instance affects the main content of the site.
I hope this will be helpful!
source share