Using a SQL Server Database Project or database linked to SQL Source Control - SQL Connect

SQL Connect can create projects from SQL Server Database Projects or databases linked to SQL Source Control, so teams can share database changes whether they use Visual Studio or SQL Server Management Studio.

Note: SQL Source Control 3.0.9 or later is required to use databases linked to SQL Source Control.

1. If you are using a database linked to SQL Source Control, check out the database repository to a folder using your source control system. For more information, see your source control system's documentation.
2. In Visual Studio, if the SQL Connect window is not displayed, go to the SQL Connect menu and select SQL Connect.

   In the SQL Connect window, click Create from an existing database project.

   The Create from an existing database project dialog box is displayed:

   

   Click Browse, and specify the location of your database project or folder.

   For SQL Server Database Projects, this is the folder containing the project file.

   For databases linked to SQL Source Control, this is the folder your repository is checked out to.

3. Click Create Project.

   The Specify database details dialog box is displayed:

   

4. Select the server and database you want to use, and click Create Project.

   The database is linked to your project.

To modify the database in Visual Studio, see Modifying a database.