sql2yaml 0.1.12

There is a newer version of this package available.
See the version list below for details.

dotnet tool install --global sql2yaml --version 0.1.12

This package contains a .NET tool you can call from the shell/command line.

dotnet new tool-manifest # if you are setting up this repo
dotnet tool install --local sql2yaml --version 0.1.12

This package contains a .NET tool you can call from the shell/command line.

#tool dotnet:?package=sql2yaml&version=0.1.12

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

nuke :add-package sql2yaml --version 0.1.12

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

sql2yaml

Import & export sql tables into yaml files and vice versa.

dotnet tool sql2yaml export -c 'Data Source=.;Initial Catalog=.;...' -d ./export -t table1 table2 table3

dotnet tool sql2yaml import -c 'Data Source=.;Initial Catalog=.;...' -d ./export

The import uses a temporary table for staging and merges the data into the target table.

All triggers and foreign keys are disabled before execution and re-enabled again when done.

The entire import is executed within a transaction.

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

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

delete in target table unmatched records from sourceß