DLM Automation exclude:Additional

RameshShankarG · April 4, 2017 9:14AM

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

Rob C · April 5, 2017 6:42AM

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.

RameshShankarG · April 5, 2017 8:14AM

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 · April 5, 2017 8:14AM

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

Rob C · April 5, 2017 12:13PM

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

RameshShankarG · April 5, 2017 6:27PM

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.

Rob C · April 6, 2017 8:31AM

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.

RameshShankarG · April 6, 2017 9:12AM

Hi Robert,

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

Thanks..!!

RameshShankarG · April 18, 2017 6:10PM

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 · April 19, 2017 5:31PM

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

Rob C · April 20, 2017 1:05PM

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.

RameshShankarG · April 20, 2017 7:27PM

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,

Rob C · April 21, 2017 10:23AM

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

DLM Automation exclude:Additional

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk