CODEWITHSUNDEEP
sql-serversqlpackage
Max
Max

Reputation: 7090

SqlPackage /Profile properties

Where I can find SqlPackage XML profile documentation?

Let me explain: on this page you can find documentation about all switches you can pass to SqlPackage directly on the command line.

The documentation says that you can use also an XML profile BUT does not mention in any way what are the equivalent switches for the XML profile, for example for the switch CreateNewDatabase the equivalent is the same <CreateNewDatabase>False</CreateNewDatabase> BUT for example ExcludeObjectType=Users, you must use <ExcludeUsers>True</ExcludeUsers>.

It seems that all boolean switches can be used inside the XML profile, but I'm now sure.

I did not find any documentation/XSD schema about this mapping between the cli switch and related XML properties.

Searching on Google I found that someone uses Visual Studio to generate the publish profile, but I'm using the Azure Data Studio project with an SDK-style project (preview) and when I open the project inside Visual Studio it tries to upgrade the project to .NET Framework 4.8.

Inside Azure Data Studio on the Database project, I can only create a basic publish profile.

Upvotes: 0

Views: 273

Answers (1)

Ellioth Velasquez
Ellioth Velasquez

Reputation: 49

the XML values are Properties names, here is the full list scroll on the left panel.

Upvotes: 0

Related Questions