Thanks for your post.
Normally the actions carried out by SQL Source control would be performed manually by each developer when they're happy with the work they have completed and are ready to commit the changes to the source control repository. It's probably not a great idea to have check-ins performed automatically, as a developer might have left the database in an inconsistent state.
If you want to automate the deployment of these checked-in changes to other environments, such as a staging or test environment, the best thing to use would be SQL Compare. You can automate the process using the command line interface.
Here is an article that discusses the workflow. Click here
I hope this helps.