Dbo .__ RefactorLog table not included in bacpac file
I have a database that I have created and modify via sqlproj. As a result, the database schema has a dbo .__ RefactorLog table. When I export the bacpac file from the database, everything in the schema is included except the __RefactorLog table.
Is this the expected behavior? Is there a way to get the __RefactorLog table to be included in bacpac?
source to share
The __RefactorLog table is essentially a "system" / internal table, automatically generated by SSDT. SSDT uses it to keep a record of what Refactor operations it has already performed during deployments, i.e. Whether it should reprocess this column or table.
The table does not need to be part of the schema and will be automatically recreated as needed on the target systems.
If you are wondering why it will not automatically generate the table right away, it will only do so when the Refactor SSDT operation needs to be performed and therefore recorded as completed. Therefore, the Refactor table will not be created in the "fresh" copy of the schema.
Short verson: this is an internal table, it shouldn't be, what you see seems normal to me.
For more information on Refactor actions / what they are, see the MSDN documentation .
source to share