Published 16 January 2014
You can only link to SSDT projects in SQL Source Control 3.4 and later.
You can link SQL Server Data Tools (SSDT) projects to source control. This means teams using Management Studio and Visual Studio can work on the same database.
Linking to SSDT projects is an unsupported feature. However, because of the similar structure of SSDT projects and the script folders created by SQL Source Control's comparison engine, linking is possible, with some known issues:
- CLR assembles aren't supported.
- Foreign and primary keys might be duplicated, which can cause exceptions.
- Database-level permissions might be misinterpreted and some users might not be given permissions.
- Visual Studio might not be able to read database-level extended properties created by SQL Source Control.
If you have problems, or if you'd like to see this feature supported, tell us on our feedback forum.
To link an SSDT project:
- Create a new empty database.
The SSDT project will be imported into this database.
- With the new database selected in the Object Explorer, go to SQL Source Control. On the Setup tab, click Link to source control.
The Link to source control dialog box opens.
In the left pane, select your source control system.
Specify the location of the repository that contains the SSDT project. The repository must contain the .sqlproj file and the bin, dbo and obj folders.
- If you're linking to a database that will be used by multiple developers, make sure Shared database is selected. For more information, see Database development models.
- Click Link.
SQL Source Control imports the SSDT project to the empty database and links it to source control.
For information about linking databases to source control, see Linking a database to source control.