Disable automatic mapping when deploying

annieluxton

Hi there,

I've only just noticed that there is a feature called "automatic mapping". This has caused our recent deployment to map a column that was being deleted to a new column that was being added, but the two are completely unrelated and this was not the desired effect.

How can we disable this feature or use it on a 'case-by-case' basis with SQL Source Control and DLM Automation? We use TeamCity and Octopus to deploy our SQL Server DB.

Kind regards,

Annie Luxton

Jessica R

Thanks for your post!

You can set the NoAutoColumnMapping SQL Compare option to disable this: https://documentation.red-gate.com/disp ... umnMapping

Hope that helps!

annieluxton

Hi Jessica,

Thank you for your reply! To do this in SQL CI, should I add it as an option in the "Additional parameters" section of the TeamCity plugin? Like this - /NoAutoColumnMapping ?

Cheers,
Annie

Jessica R

Hi Annie!

Can I first check what versions of DLM Automation and the TeamCity plugin you have installed?

(The NoAutoColumnMapping option wasn't supported until version 2.0.4.148 of DLM Automation)