cake-contrib / Cake.SqlPackage

Cake AddIn that extends Cake for creating and deploying SQL Server databases and DACPAC packages.
https://cakebuild.net/extensions/cake-sqlpackage
MIT License
11 stars 9 forks source link

Upgrade documentation for new SqlPackage version #27

Open AdaskoTheBeAsT opened 3 years ago

AdaskoTheBeAsT commented 3 years ago

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));