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

· Share on Twitter

Comments

  • 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
    · Share on Twitter
  • RameshShankarGRameshShankarG Posts: 18
    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,
    · Share on Twitter
  • RameshShankarGRameshShankarG Posts: 18
    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
    · Share on Twitter
  • Rob CRob C Posts: 419 Gold 2
    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
    · Share on Twitter
  • RameshShankarGRameshShankarG Posts: 18
    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.
    · Share on Twitter
  • Rob CRob C Posts: 419 Gold 2
    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
    · Share on Twitter
  • RameshShankarGRameshShankarG Posts: 18
    Hi Robert,

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

    Thanks..!!
    · Share on Twitter
  • RameshShankarGRameshShankarG Posts: 18
    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

    · Share on Twitter
  • RameshShankarGRameshShankarG Posts: 18
    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
    · Share on Twitter
  • Rob CRob C Posts: 419 Gold 2
    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
    · Share on Twitter
  • RameshShankarGRameshShankarG Posts: 18
    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,
    · Share on Twitter
  • Rob CRob C Posts: 419 Gold 2
    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
    · Share on Twitter
Sign In or Register to comment.