Database Solution Tool_Configuration

Return to Create DB Solution

Database Solution Tool Setup Configuration

Preparation by System Developer

Navigate to the nuget-for-sql-projects\NugetDbToolsPackageTools.Builder.Db folder and copy NuGetDbToolsInstall.Template.ps1 as NuGetDbToolsInstall.ps1. Open it in an editor, and set the custom values:

$nugetSource = '<<<<URI of local NuGet server>>>>'
$nugetApiKey = '<<<<ApiKey of local NuGet server>>>>'
$defaultLocation = '<<<<Default solution location on developer PC>>>>'
$sampleSolutionName = '<<<<An example solution name>>>>'
$sampleDatabaseName = '<<<<An example database name>>>>'
$sampleDependencyId = '<<<<An example database reference in the form solutionName.databaseName>>>>'

• $nugetSource

  The URL of the local NuGet server, e.g. http://localserv:808/NugetServer/nuget, or a URI, e.g. \\localserv\nuget

• $nugetApiKey

  The ApiKey of the local NuGet server. Leave the string empty if developers are not allowed to publish NuGet packages directly. In that event, the ApiKey needs to be set in the build server configuration found at %appdata%\JamieO53\NugetDbTools\NugetDbTools.config under the build login.

• $defaultLocation

  The default location for developer PC Visual Studio solutions, e.g. C:\Dev.

• $sampleSolutionName

  An illustrative solution name familiar to developers.

• $sampleDatabaseName

  The name of the database belonging to the illustrative solution.

• $sampleDependencyId

  A database referenced by the illustrative solution database in the form solutionName.databaseName.

Save the file in the Intranet where developers can access it.