Since projects only contain SQL scripts and Visual Studio configuration files, they can be committed to version control without any extra configuration.
When committing to version control you should ignore the following:
bin folder
obj folder
[project name].dbmdl file
[project name].jfm file
[project name].sqlproj.user file
It is especially important to ignore the user file as this contains user-specific settings which can cause unexpected behavior for other users.
A .gitignore file containing rules to ignore the files listed above can be downloaded here.
Place your .gitignore file in the same folder as your SQL Change Automation project file (.sqlproj file).
Git encourages workflows that branch and merge often. We encourage Git users to embrace branching and merging for their database code for the same reasons many people do this for application code. Read more about this in "The Managers Guide to Git Training for Database Administrators."
SQL Change Automation works well with many popular branching strategies, including Git Flow, Release Flow, and other patterns. If you are not sure which pattern to begin using, we often advise: