Any support for dacpac refactor log?

[asrichesson]

I know in the old project format you could include a refactor log for storing object renames as discussed here:

https://learn.microsoft.com/en-us/sql/ssdt/how-to-use-rename-and-refactoring-to-make-changes-to-your-database-objects?view=sql-server-ver16

These refactors would be baked into the dacpac and applied (if necessary) on deployment.

Obviously, there isn't any visual studio support yet, but is adding the refactor log entries manually an option?

I would expect it to look something like this in the csproj file:

<RefactorLog Include="MyDatabase.refactorlog" />

And the refactor log:

<?xml version="1.0" encoding="utf-8"?>
<Operations Version="1.0" xmlns="http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02">
  <Operation Name="Rename Refactor" Key="1f43734f-1598-4c41-a2f5-1ca07a32cf45" ChangeDateTime="03/04/2023 00:44:44">
    <Property Name="ElementName" Value="[dbo].[MyTable].[MyColumn]" />
    <Property Name="ElementType" Value="SqlSimpleColumn" />
    <Property Name="ParentElementName" Value="[dbo].[MyTable]" />
    <Property Name="ParentElementType" Value="SqlTable" />
    <Property Name="NewName" Value="[MyNewColumnName]" />
  </Operation>
</Operations>

[lavbnon]

Same question for me, did not find anything yet to support changes in table structures.

[asrichesson]

Adding this to your sdk sqlproj seems to work.

<ItemGroup>
  <RefactorLog Include="SdkTestDatabase.refactorlog" />
</ItemGroup>