ScriptDeployTools.Targets.SqlServer 2.0.5

.NET 9.0

dotnet add package ScriptDeployTools.Targets.SqlServer --version 2.0.5

NuGet\Install-Package ScriptDeployTools.Targets.SqlServer -Version 2.0.5

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="ScriptDeployTools.Targets.SqlServer" Version="2.0.5" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="ScriptDeployTools.Targets.SqlServer" Version="2.0.5" />
                    

                            Directory.Packages.props

<PackageReference Include="ScriptDeployTools.Targets.SqlServer" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add ScriptDeployTools.Targets.SqlServer --version 2.0.5

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: ScriptDeployTools.Targets.SqlServer, 2.0.5"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

#:package ScriptDeployTools.Targets.SqlServer@2.0.5

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=ScriptDeployTools.Targets.SqlServer&version=2.0.5
                    

                            Install as a Cake Addin

#tool nuget:?package=ScriptDeployTools.Targets.SqlServer&version=2.0.5
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

script-deploy-tools-targets

Targets for library script-deploy-tools:

ScriptDeployTools.Targets.SqlServer - - deploy scripts to SQL Server

IsInitializeTarget

This scripts can deploy when target is not created (e.g. script to create database).

When database is not exists target auto change database to [master]

Used

var deployService = new DeployBuilder()
    .AddLogger(loggerFactory.CreateLogger<IDeploymentService>())
    .AddOptions(new DeploymentOptions
    {
        InsertMigrationScript = scripts.FirstOrDefault(x =>
            x is { IsService: true, ScriptKey: "INSERT_MIGRATION" })
    })
    .FromEmbeddedResources(options =>
    {
        options.Assemblies = [typeof(DeployHelper).Assembly];
    })
    .ToSqlServer(options =>
    {
        options.ConnectionString = connectionString;
        options.GetDeployedInfoScript = scripts.FirstOrDefault(x =>
            x is { IsService: true, ScriptKey: "GET_DEPLOYED_SCRIPTS" });
    })
    .Build();

await deployService.Deploy(scripts, cancellationToken);

A more detailed example is available in this repository.

Product	Compatible and additional computed target framework versions.
.NET	net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net9.0
- Microsoft.Data.SqlClient (>= 5.2.2)
- ScriptDeployTools (>= 2.0.5)

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.