SSDT

SSDT

Use:

• Visual Studio 2017
• Managment Studio
• Database: WideWorldImporters-Full

1. Import database WideWorldImporters in Managment Studio. link

2. Create new project in Visual Studio 2017 (SQL Server Database Project).link

3. Import database to Visual Studio 2017.link x

4. Create new profile (connection to new database).link

5. Publish.link

6. Add new obcjets :view vPurchaseOrderLines and generation scripts.link

7. Add new column [Purchasing].[PurchaseOrderLines] column name [Twitter], Generation Scrpit / Publishlink