cake-contrib/Cake.SqlPackage

Upgrade documentation for new SqlPackage version

Opened this issue · 0 comments

Last working solution for package was
#tool nuget:?package=Microsoft.Data.Tools.Msbuild&version=10.0.61804.210&loaddependencies=true

for new
#tool nuget:?package=Microsoft.Data.Tools.Msbuild&version=16.0.62004.28040&loaddependencies=true
there is also need to install
#tool nuget:?package=Microsoft.SqlServer.DACFx&version=150.4897.1&loaddependencies=true

and copy dlls by using

        var sourceDllDirectoryPath = System.IO.Path.GetDirectoryName(
            Context.Tools.Resolve("Microsoft.Data.Tools.Utilities.dll").FullPath);
        var sourcePath = System.IO.Path.Combine(sourceDllDirectoryPath, "../net46");
        var targetPath = System.IO.Path.GetDirectoryName(
            Context.Tools.Resolve("SqlPackage.exe").FullPath);
        CopyDirectory(new DirectoryPath(sourcePath), new DirectoryPath(targetPath));