Home
%3CLINGO-SUB%20id%3D%22lingo-sub-850080%22%20slang%3D%22en-US%22%3EHow%20to%20get%20started%20with%20a%20development%20environment%20using%20SSDT%20with%20SQL%20Data%20Warehouse%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-850080%22%20slang%3D%22en-US%22%3E%3CP%3EIt%E2%80%99s%20recommended%20to%20begin%20employing%20DevOps%20practices%20in%20your%20organization%20as%20soon%20as%20possible%20when%20building%20your%20analytics%20solution%20with%20SQL%20Data%20Warehouse.%20For%20SQL%20Data%20Warehouse%20developers%20who%20are%20just%20getting%20started%20with%20database%20DevOps%2C%20this%20blog%20shows%20how%20to%20simply%20import%20and%20onboard%20an%20existing%20SQL%20data%20warehouse%20to%20a%20local%20source%20control%20repository%20using%20SQL%20Server%20Data%20Tools%20(SSDT).%20You%20will%20then%20create%20a%20new%20development%20environment%20for%20this%20data%20warehouse.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-install-visual-studio%23install-visual-studio-2019-preview%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EInstall%20Visual%20Studio%202019%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EConnect%20to%20your%20data%20warehouse%20and%20right%20click%20on%20the%20object%20explorer%20to%20create%20a%20new%20project%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131366iB0E7F1F6664DFA18%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3ECreate%20and%20add%20the%20new%20project%20to%20local%20source%20control%20repository%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131367i09DBAB3E20D56551%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3EYou%20should%20now%20see%20your%20database%20project%20in%20the%20solution%20explorer%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131368iF815D19D1DD8DD42%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_2.png%22%20title%3D%22clipboard_image_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3EEnsure%20your%20project%20can%20build%20successfully.%20If%20you%20have%20any%20references%20to%20DMVs%20that%20are%20causing%20build%20errors%2C%20add%20a%20database%20reference%20to%20master.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131369iF8539E736880FF79%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_3.png%22%20title%3D%22clipboard_image_3.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131370i66BE9D14C6CCFA63%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_4.png%22%20title%3D%22clipboard_image_4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%3ENow%20create%20your%20development%20environment%20by%20right-clicking%20on%20your%20project%20and%20publishing%20to%20a%20server.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131379iACBF8D1036934BB1%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20have%20now%20placed%20your%20data%20warehouse%20model%20in%20source%20control%20and%20created%20a%20new%20development%20environment%20with%20SQL%20Data%20Warehouse.%20Learn%20more%20about%20SQL%20Data%20Warehouse%20DevOps%20by%20going%20through%20the%20following%20tutorials%3A%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fazure%252Fsql-data-warehouse%252Fsql-data-warehouse-source-control-integration%26amp%3Bdata%3D02%257C01%257Ckevin%2540microsoft.com%257C7060ae7d80754ee04a1008d733189645%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637034052998793750%26amp%3Bsdata%3D7kp2RC9Y3xR%252F8zuXl09vuTk2V%252F6O%252F%252FE2J2id8PkG9oM%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EIntegrate%20with%20source%20control%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20style%3D%22font-family%3A%20inherit%3B%20background-color%3A%20%23ffffff%3B%22%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fazure%252Fsql-data-warehouse%252Fsql-data-warehouse-continuous-integration-and-deployment%26amp%3Bdata%3D02%257C01%257Ckevin%2540microsoft.com%257C7060ae7d80754ee04a1008d733189645%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637034052998803758%26amp%3Bsdata%3DRL0GtR4%252By8LIFxXFCRsBpuNVmQ3ftpOJG76ujhI%252BNqY%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EContinuous%20integration%20and%20deployment.%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-850080%22%20slang%3D%22en-US%22%3E%3CP%3EDevOps%3A%20Leverage%20Visual%20Studio%20SQL%20Server%20Data%20Tools%20(SSDT)%20to%20set%20up%20a%20test%20and%20local%20environment%20for%20SQL%20Data%20Warehouse%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131374i5BF9792F07F76E41%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22SSDT%2BSQL%20Data%20Warehouse.png%22%20title%3D%22SSDT%2BSQL%20Data%20Warehouse.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-850080%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQL%20Data%20Warehouse%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EVisual%20Studio%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

It’s recommended to begin employing DevOps practices in your organization as soon as possible when building your analytics solution with SQL Data Warehouse. For SQL Data Warehouse developers who are just getting started with database DevOps, this blog shows how to simply import and onboard an existing SQL data warehouse to a local source control repository using SQL Server Data Tools (SSDT). You will then create a new development environment for this data warehouse.

 

  1. Install Visual Studio 2019
  2. Connect to your data warehouse and right click on the object explorer to create a new projectclipboard_image_0.png
  3. Create and add the new project to local source control repositoryclipboard_image_1.png
  4. You should now see your database project in the solution explorerclipboard_image_2.png
  5. Ensure your project can build successfully. If you have any references to DMVs that are causing build errors, add a database reference to master.clipboard_image_3.pngclipboard_image_4.png
  6. Now create your development environment by right-clicking on your project and publishing to a server.clipboard_image_1.png

 

You have now placed your data warehouse model in source control and created a new development environment with SQL Data Warehouse. Learn more about SQL Data Warehouse DevOps by going through the following tutorials: