In this brief article, we will see how to setup SQL Server Database Source Control using Visual Studio step by step —

1. Create a new repository to GitHub
1. create new repo SQL Server Database Source Control using Visual Studio: Git2. Clone the repository to local directory
3. Create a new Sql Server Database project inside the repository
3. select sql server database project 1 SQL Server Database Source Control using Visual Studio: Git
4. Right click on the project -> Import -> Select Database or Data-tier Application(*.dacpac)
4. import database data tier SQL Server Database Source Control using Visual Studio: GitFor Data-tier Application(*.dacpac) option, Select/Browse the file then click on ’Start’.
4.1. import data tier SQL Server Database Source Control using Visual Studio: GitFor Database option, Select Connection of the Source Sql Server Database then click on ’Start’.
[But this option is not available in Visual Studio Community Edition]
4.2. import database SQL Server Database Source Control using Visual Studio: Git
4.3. finish SQL Server Database Source Control using Visual Studio: Git
5. Now update a Stored procedure (Add comment) from source Sql Server Database as well as create a new table for testing purpose.
5. update source database SQL Server Database Source Control using Visual Studio: Git
6. To compare the Source Database and our target project, Right click on the project name the select  ‘Schema Compare’
6. compare schema SQL Server Database Source Control using Visual Studio: Git
7. Select Source Database and Target Project then click on ‘Compare Button’
7. compare SQL Server Database Source Control using Visual Studio: Git
8. Check the changes
8.1. check changes SQL Server Database Source Control using Visual Studio: Git8.2. check changes SQL Server Database Source Control using Visual Studio: Git
9. To update the Target Project/Source Control click on ‘Update’
9.1. update target SQL Server Database Source Control using Visual Studio: Git9.2. update target SQL Server Database Source Control using Visual Studio: Git
10. Commit & Push the changes.
10. final updated source controll SQL Server Database Source Control using Visual Studio: Git
10.1. final updated source controll SQL Server Database Source Control using Visual Studio: Git
Thanks…