fsprojects / FAKE

FAKE - F# Make
https://fake.build
Other
1.28k stars 585 forks source link

Use Microsoft.SqlServer.DACFx nuget instead of sqlpackage.exe #2251

Closed panesofglass closed 4 years ago

panesofglass commented 5 years ago

Description

This is a suggestion to use the new Microsoft.SqlServer.DACFx NuGet package to drive Fake.Sql.DacPac rather than relying on sqlpackage.exe. Would this be of interest? I am not familiar with these libraries but am interested in looking into this if it can alleviate some xplat pain with DacPac.

Note also that Microsoft is now providing previews of sqlpackage that can run on linux and macOS.

cc @isaacabraham

matthid commented 5 years ago

Honestly I'm not even sure what that means. Does that mean update Fake.Sql.DacPac to no longer require existing sqlpackage.exe and make it work xplat? That sounds more than reasonable. What speaks against that?

panesofglass commented 5 years ago

@matthid, yes, that's my understanding.

panesofglass commented 4 years ago

I'm probably about to investigate this more closely and may send a PR to show how this might work.