Notice that the tables and function are grouped under their schema folders.ĭouble-click Products.sql under Tables. Expand the dbo folder and you will find separate Functions, Tables and Views folders. When the import operation has completed, click Finish to exit the final screen.Įxamine the hierarchy in the Solution Explorer. The Import Database dialog shows a progress bar and displays a list of objects SSDT is importing. For an organized hierarchy of all your database objects, accept all default settings and click Start. In the Import Settings section, notice the options for importing specific objects and settings, and creating folders for each schema and/or object type.

In the Target project setting, change the name of the project to TradeDev. In the Import Database dialog box, notice that the Source database connection settings have been predefined by the database you have selected in SQL Server Object Explorer.

Right-click the TradeDev node in SQL Server Object Explorer and select Create New Project. To create a new database project off a connected database The following procedures utilize entities created in previous procedures in the Connected Database Development section.

Database visual studio 2017 sql server