Ssdt Refactor Rename Is Ignored By The Schema Comparison Script Generation

I right-clicked on a column name in a CREATE TABLE script and selected Refactor | Rename. It renamed the column and the expected entry appears in the refactorlog XML file. However,

Solution 1:

I am not sure if this is the answer you need, Mark, but my solution to this problem is described here: SQL Server Data Tools Ignores Refactor on Schema Compare. Essentially, SQL Data Tools maintains metadata in the database to ensure that a refactor is only performed once. I'd be interested to know if this was the source of your problem. If not, did you ever find a correct solution?

Solution 2:

I just ran into this same issue, none of the suggestions worked out. It turns out that - in my case, at least - the Build Action property for the refactor log file was set to "None" - it should be set to "RefactorLog". Once I changed this setting and re-generated the script, all the associated entries in the log were addressed in the generated scripts.

Hope this helps someone.