DBTransporterCMD /Options Parameter

Hi. Any additional information about the /options for the DBTransporterCMD tool? The docs only provide one example "/Options=ObjectFilter=Keepsettings" which isn't very illuminating :) Is there any other information anywhere about what you can specify please?

Parents

0 Markus Weiss-Ehlers over 2 years ago

As written in the documentation, the /options parameter allows you to set special options for importing synchronization projects.

On the ObjectFilter you can specify a pipe-separated list of tables that are ignored during import.

The ObjectFilter KeepSettings is just an alias for DPRSystemVariable|DPRSystemVariableSet|DPRProjectionStartInfo

This makes it possible to protect any other tables from being overwritten.

Example: The import should not overwrite the SystemConnections either.

To achieve that, instead of this parameter:

/Options="ObjectFilter=KeepSettings"

use this one:

/Options="ObjectFilter=DPRSystemVariable|DPRSystemVariableSet|DPRProjectionStartInfo|DPRSystemConnection"
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Reply

0 Markus Weiss-Ehlers over 2 years ago

As written in the documentation, the /options parameter allows you to set special options for importing synchronization projects.

On the ObjectFilter you can specify a pipe-separated list of tables that are ignored during import.

The ObjectFilter KeepSettings is just an alias for DPRSystemVariable|DPRSystemVariableSet|DPRProjectionStartInfo

This makes it possible to protect any other tables from being overwritten.

Example: The import should not overwrite the SystemConnections either.

To achieve that, instead of this parameter:

/Options="ObjectFilter=KeepSettings"

use this one:

/Options="ObjectFilter=DPRSystemVariable|DPRSystemVariableSet|DPRProjectionStartInfo|DPRSystemConnection"
Cancel
Up 0 Down

Reply

Verify Answer

Reject Answer

Cancel

Children

0 Marek Lotocki 5 months ago in reply to Markus Weiss-Ehlers

Does this work with Object Transport as well - ie. I have Config Parameters exported with parameter option as relation - template below. Can I add

/Options="ObjectFilter=DialogConfigParmOption"

to prevent overwrite dialog parameter options?

<TransportTemplate Version="1.0">
  <Header>
    <Parameter Name="Description">
    </Parameter>
  </Header>
  <Tasks>
    <Task Class="VI.Transport.ObjectTransport, VI.Transport" Display="ObjectTransport">
      <Parameter Name="Container">
        <Parameter Name="BaseObject">
          <Parameter Name="Tablename">DialogConfigParm</Parameter>
          <Parameter Name="Display">Custom\SOD</Parameter>
          <Parameter Name="Columns">
            <Parameter Name="UID_ConfigParm">CCC-9FBEBC487817FE4692DCBAD92624BCDE</Parameter>
          </Parameter>
        </Parameter>
        <Parameter Name="DeleteResiduals">1</Parameter>
        <Parameter Name="Relations">
          <Parameter Name="Relation">DialogConfigParm|UID_ParentConfigparm|CR</Parameter>
          <Parameter Name="Relation">DialogConfigParmOption|UID_ConfigParm|CR</Parameter>
          <Parameter Name="Relation">QBMConfigParmHasTask|UID_ConfigParm|CR</Parameter>
          <Parameter Name="Relation">DialogConfigParmOption|UID_ConfigParm|FK</Parameter>
        </Parameter>
      </Parameter>
    </Task>
  </Tasks>
</TransportTemplate>