search

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

Good effort! #4

Closed trailmax closed 6 years ago

trailmax commented 7 years ago

Hey, I also wanted to touch base with you. I'm a author of Cake.SqlServer package and some of my functionality is overlapping with what you do here.

However I'm using DacFx package and not having much success. I see you are using SqlPackage.exe and I suppose this makes more sense. I was looking for options for me not having to carry DacFx package around: it bloats my nuget package from a few kb to 4Mb, and adds a nasty warning message on every Cake execution.

What do you think if I depricate my DacFx functionality and redirect people to use your package?

RLittlesII commented 7 years ago

@trailmax I wrapped SqlPackage.exe in Cake.SqlPackage because I am currently using SqlPackage.exe to deploy my databases.

I would hate for your efforts to have been wasted, I am fine if you decide you want to point users of Cake.SqlServer here as an alternative. I would ask that you verify that this repo has everything required, and functions as you expect.

trailmax commented 7 years ago

To be honest, I've done very little code to work with BACPAC. DACPAC stuff was a pull request from @mabreuortega. Perhaps he should be doing the reviews and also involved in this chat as I'd imagine he is using DACPACs in his build.

Of course if I decide to direct users here, I'll need to provide a migration plan and that can take a while - not doing this any time soon. And yes, I'll need to migrate my projects first and make sure everything works as expected -)

My only problem with using SqlPackage.exe is the case when it is not installed on the executing machine. Is there a NuGet package that has SqlPackage.exe with dependencies? (Is this even possible?)

mabreuortega commented 7 years ago

What do you need from me, I can help you with any question.

trailmax commented 7 years ago

@mabreuortega Can you possibly try this package for your DACPAC build needs? I don't have any projects with DACPAC, so can't really try in real-life.

mabreuortega commented 7 years ago

Will do, I will keep you posted here

RLittlesII commented 7 years ago

@mabreuortega

Microsoft.Data.Tools.Msbuild is a nuget package that delivers SqlPackage.exe. If you look at the example in this repo, you should find everything you need to get started. I did not explicitly add the tool path for the nuget package, but it's on my list of things to do. Please let me know if you run into any issues.