CODEWITHSUNDEEP
c#.netsql-server-data-toolsdacpacdac
rlm96
rlm96

Reputation: 193

Convert publish profile file (.xml) into DacDeployOptions class

I am working on a C# project where I should deploy few .dacpac files so I have used the Microsoft.SqlServer.DacFx library (github from DacFx here).

I have used also in another part the SqlPackage.exe executable to deploy another .dacpac files (no relation between them), so I'm using a publish profile (.xml / .pubxml file) to configure the deployment options. The cmd command looks like this:

SqlPackage /Profile:"Database.publish.xml"

I would need to deserialize this .xml file into a DacDeployOptions class in order to use the same pulish profile when publishing the dacpacs, but as much as I have been able to search I can't find a way to do it. I would appreciate some help with this.

Thanks 😃

Upvotes: 0

Views: 1093

Answers (1)

DacPacLover
DacPacLover

Reputation: 46

After a long search I found the solution. Here the needed Code:

DacProfile profile = DacProfile.Load(@"C:\temp\publish.xml");
PublishOptions options = new PublishOptions();
options.GenerateDeploymentReport = true;
options.GenerateDeploymentScript = true;
options.DeployOptions = profile.DeployOptions;

Upvotes: 3

Related Questions