Integrating R into the SQL Server Database lifecycle workflow
Earlier in Chapter 7, Operationalizing R Prediction Models, we discussed how to create an R project in Visual Studio 2017. We also talked about integrating R code as part of sp_execute_external_script in SQL Server. Here, we will revisit Visual Studio 2017, specifically in the context of integrating R code in sp_execute_external_script as part of a SQL Server Database Project, and holistically as part of the database lifecycle workflow.
Preparing your environment for the database lifecycle workflow
In this section, we will discuss the stages of the database lifecycle workflow and the tools that we will be using. For each of the stages in the workflow, there will also be some suggested alternatives for you to explore.
- Coding and managing SQL Server database projects/solutions: There are a few different ways to manage your SQL Server DML/DDL scripts that form a SQL Server database project. SQL SSDT in Visual Studio 2017 (VS2017) is...
