What are the challenges you face when working across database platforms? Take the survey
Options

DLM Automation exclude:Additional

RameshShankarGRameshShankarG Posts: 18
edited April 4, 2017 9:14AM in DLM Automation

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

Comments

  • Options
    Rob CRob C Posts: 419 Gold 2
    edited April 5, 2017 6:43AM
    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.
    Software Engineer
    Redgate Software
  • Options
    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,
  • Options
    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
  • Options
    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
    Software Engineer
    Redgate Software
  • Options
    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.
  • Options
    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.
    Software Engineer
    Redgate Software
  • Options
    Hi Robert,

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

    Thanks..!!
  • Options
    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

  • Options
    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
  • Options
    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.
    Software Engineer
    Redgate Software
  • Options
    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,
  • Options
    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
    Software Engineer
    Redgate Software
Sign In or Register to comment.