How can we help you today? How can we help you today?

Disable automatic mapping when deploying

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
annieluxton
0

Comments

3 comments

Sort by
  • 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!
    Jessica R
    0
  • 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

    annieluxton
    0
  • 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)

    Jessica R
    0

Add comment

Please sign in to leave a comment.