feature request : Add support of Xml PublishProfile configuration

[didaskein]

Hi,

Could you add the Xml PublishProfile configuration as an input of the Github action ?

For example what we have for Azure Devops :

  - task: SqlAzureDacpacDeployment@1
    displayName: "Execute Azure SQL : DacpacTask"
    inputs:
      azureSubscription: "${{parameters.serviceConnection}}"
      AuthenticationType: connectionString
      ConnectionString: "$(kv-SQL-ConnectionString)"
      DacpacFile: "$(Pipeline.Workspace)/drop/SQL/bin/Release/.Database.dacpac"
      PublishProfile: "$(Pipeline.Workspace)/drop/SQL/Profile.publish.xml" 

The kind of stuff we can configure in the publish profile :

<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="14.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <IgnoreIdentitySeed>False</IgnoreIdentitySeed>
    <IgnoreColumnCollation>False</IgnoreColumnCollation>
    <IncludeTransactionalScripts>True</IncludeTransactionalScripts>
    <CreateNewDatabase>False</CreateNewDatabase>
    <BackupDatabaseBeforeChanges>False</BackupDatabaseBeforeChanges>
    **<BlockOnPossibleDataLoss>False</BlockOnPossibleDataLoss>**
    <NoAlterStatementsToChangeCLRTypes>False</NoAlterStatementsToChangeCLRTypes>
    <ProfileVersionNumber>1</ProfileVersionNumber>
    <ScriptDatabaseOptions>False</ScriptDatabaseOptions>
    <IncludeCompositeObjects>True</IncludeCompositeObjects>
    <TargetTimeout>4500</TargetTimeout>
    <IgnoreNotForReplication>True</IgnoreNotForReplication>
    <IgnoreFullTextCatalogFilePath>True</IgnoreFullTextCatalogFilePath>
    <VerifyDeployment>True</VerifyDeployment>
    <IgnorePartitionSchemes>True</IgnorePartitionSchemes>
    <DeployDatabaseInSingleUserMode>True</DeployDatabaseInSingleUserMode>
    <!--Drop and Exclude Objects-->
    <DropObjectsNotInSource>False</DropObjectsNotInSource>
    <IgnoreRoleMembership>True</IgnoreRoleMembership>
    <IgnoreUserSettingsObjects>True</IgnoreUserSettingsObjects>
    <IgnoreUserLoginMappings>True</IgnoreUserLoginMappings>
    <DoNotDropUsers>True</DoNotDropUsers>
    <IgnorePermissions>True</IgnorePermissions>
    <DoNotDropLogins>True</DoNotDropLogins>
    <DoNotDropLinkedServers>True</DoNotDropLinkedServers>
  </PropertyGroup>
</Project>

Thank you,
Kind regards.

[github-actions]

This issue is marked need-to-triage for generating issues report.

[github-actions]

This issue is idle because it has been open for 14 days with no activity.

[didaskein]

We have coded this solution while waiting for it to be exposed by the Github Action
We coded

deploy-db:
   runs-on: windows-latest
   environment:
     name: ${{ needs.set-env.outputs.env }}
   steps:
     - uses: actions/checkout@v2

     - name: Install msbuild
       uses: microsoft/setup-msbuild@v1.0.2

     - name: Install sqlpackage
       uses: coreywebber/setup-sqlpackage@v1

     - name: Get SQL server connection string from Key Vault
       id: get_connection_string
       shell: pwsh
       run: |
         az login --service-principal -u ${{ secrets.ARM_CLIENT_ID }} -p ${{ secrets.ARM_CLIENT_SECRET }} --tenant ${{ secrets.ARM_TENANT_ID }} --output none
         $connection_string = az keyvault secret show --name ConnectionStrings--IpamSQL --vault-name ${{ env.KEYVAULT_NAME }} --subscription ${{ secrets.ARM_SUBSCRIPTION_ID }} --query value --output tsv
         echo "::set-output name=connection_string::$connection_string"
         echo "::add-mask::$connection_string"
       env:
         KEYVAULT_NAME: ${{ format(env.KEYVAULT_NAME_FORMAT, needs.set-env.outputs.env_id) }}

     - name: Build Database Project
       shell: pwsh
       run: |
         cd src
         msbuild "es.Database\es.Database.sqlproj" /p:Configuration=Release
 
     - name: Deploy dacpac to SQL server
       shell: pwsh
       run: |
         cd src\es.Database\bin\Release
         **sqlpackage /action:Publish /SourceFile:"es.Database.dacpac" /pr:"es.publish.xml" /TargetConnectionString:"$env:CONNECTION_STRING" `
                    /Variables:"EnvId=$env:TARGET_ENV_ID"** 
       env:
         CONNECTION_STRING: ${{ steps.get_connection_string.outputs.connection_string }}
         TARGET_ENV_ID: ${{ needs.set-env.outputs.env_id }}

[github-actions]

This issue is idle because it has been open for 14 days with no activity.

[zijchen]

The DACPAC action supports an optional arguments input that lets you specify additional sqlpackage parameters. Can you try specifying /pr:profile_path there?

uses: azure/sql-action
  with:
    connection-string: ${{ secrets.AZURE_SQL_CONNECTION_STRING }}
    dacpac-package: './Database.dacpac'
    arguments: '/pr:profile_path'

[github-actions]

This issue is idle because it has been open for 14 days with no activity.