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

DLM Automation exclude:Additional

Hi,

We are using/evaluating Redgate DLM plugin in Teamcity/Octopus and our application allows users to create their own forms/tables. During continuous integration, we need to use SQL Compare switch exclude:Additional to avoid dropping/deleting the changes done by customer in production environment.. Is there a way/work around to accomplish this.. Anticipating your reply on this ASAP..

Note: We are using licensed version of SQL Source Control/DLM Suite.. the scenario that we are expecting is more common and we are a bit surprised the RedGate team might have this thought during development.. Please reply ASAP.

Thanks,
Ramesh Shankar G
Core Solutions Inc

RameshShankarG
0

Comments

12 comments

Sort by
  • Rob C
    Hi Ramesh,

    The Powershell cmdlet now includes the -IgnoreAdditional parameter to utilise SQL Compare's /Exclude:Additional switch. If your "Create Release" step in Octopus Deploy is a Powershell script then you should be able to add -IgnoreAdditional to the call to the New-DlmDatabaseRelease cmdlet.

    Are you using the Octopus Deploy step templates? If so, the step template hasn't been updated to include this option yet. You could always edit the step template definition manually to add -IgnoreAdditional to the call to the New-DlmDatabaseRelease cmdlet.
    Rob C
    0
  • RameshShankarG
    Hi Robert,

    Thanks for the quick feedback, i have tried adding the switch -IgnoreAdditional:True to the -Newdlm release cmdlet and it throws an exception while deploying. The exception is

    New-DlmDatabaseRelease : A parameter cannot be found that matches parameter
    Error name 'IgnoreAdditional'

    Can you please provide an usage example ASAP.. Please note that we are using Octopus 3.4.8

    Thanks,
    RameshShankarG
    0
  • RameshShankarG
    HI Robert,

    Any update on this.. Please let us know. We need to get this fixed so that we can implement Redgate for our Database Continuous Integration process.

    Anticipating reply.

    Thanks
    RameshShankarG
    0
  • Rob C
    Hi Ramesh,

    In that case you might be using a version before this functionality was added. Can you try upgrading to the latest version? Here's a download link - ftp://support.red-gate.com/patches/DLMAutomation/13Mar2017/DLMAutomation.exe
    Rob C
    0
  • RameshShankarG
    Hi Robert,

    Thanks again for the quick feedback, please let us know there will be an impact if we upgrade the DLM automation suite. Also, if we do so, whether it will be automatically reflected in Octopus deploy step template, or should we go in and manually add the -IgnoreAdditional switch. Please let us know. It will be great if we could get the reply today.. We are working in a tight timeline to get the CI process implemented in our organization..

    Anticipating reply..

    Thanks again.
    RameshShankarG
    0
  • Rob C
    Hi Ramesh,

    Unless you're using a much older version, there shouldn't really be an impact. The option is not available in the step template so you'll have to manually add the -IgnoreAdditional switch.
    Rob C
    0
  • RameshShankarG
    Hi Robert,

    Thanks again for the quick feedback. We will try this out and let you know if there are any issues.

    Thanks..!!
    RameshShankarG
    0
  • RameshShankarG
    Hi Robert,,

    We have tried upgrading the DLM Automation plugin to the latest version as suggested, and able to use the -IgnoreAdditional switch. But on the other hand, we are facing new issues. In team city build, when the schema is being validated in SQL Local DB, it is throwing exception for one of the stored procedures which was running fine with the earlier plugin. The issue is related to a column alias name in the select statement of a stored procedure. When looking at the release notes of the latest DLM plugin it did not provide any useful information, just it asks the users to review the release notes of other tools such as SQL Compare, SQL Data Compare etc.,Do we need to change the existing scripts when upgrading the plugin to the latest version, do you have any suggestion/recommendation on this? Please let us know.

    The other issue that we are facing is OutofMemoryException (we have 20+GB of free space in the redgate/teamcity installation drive), which never happened with the earlier version of the DLM plugin. Please provide feedback on why this is happening with the latest version of DLM plugin.

    Anticipating Reply.

    Thanks,
    Ramesh Shankar G
    Core Solutions Inc

    RameshShankarG
    0
  • RameshShankarG
    Any update on this.? We are unable to move forward due to the plugin upgrade. Please let us know the fix for this issue.

    Thanks
    Ramesh Shankar G
    RameshShankarG
    0
  • Rob C
    Sadly I think it's going to be a bit difficult to diagnose the problem without any specific details. I think your best course of action would be to create a support ticket through the Support section on the website, or by emailing support@red-gate.com. That way we can investigate in a lot more detail and try to diagnose the problem for you. If you can include any logs, that would be really helpful.
    Rob C
    0
  • RameshShankarG
    Hi Rob,

    Thanks for the feedback, I have one question. The latest DLM plugin will be compatible with SQL Source Control 3 right? Or do we need to upgrade SQL Source Control too to the latest version?

    Please let us know..

    Thanks,
    RameshShankarG
    0
  • Rob C
    If you're using migration scripts then you'll need to upgrade SQL Source Control as there is a new migrations solution. Have a look at this page for more information - https://documentation.red-gate.com/display/SOC5/Upgrading+from+old+versions+of+migration+scripts
    Rob C
    0

Add comment

Please sign in to leave a comment.