Schema update and Schema shrink using SQL command

Question

Hi,

We are using an Azure pipeline to deploy our packages using Intragen.

Currently we are using change labels to do the changes in our system.

For a change I am currently working on we need to extend the length of an attribute, I used the following SQL code for this:

'

ALTER TABLE <Table>
ALTER COLUMN <Column> VARCHAR(2048);

GO

EXEC QBM_PColumnSchemaDataTypeCorr 'CCC'

Now also need to update and shrink the OneIdentity Schema in our synchronization project (Generic LDAP Connector).

Is there an SQL command to do the schema update, shink and commit the changes so we can use this in our pipeline?

Thanks a lot!

Kind Regards,

Patrick Schaffer

Markus Weiss-Ehlers · Answer

I've checked in 9.2 and the CLI allows you to specify if the schema should be shrunk ( -C ) and if the synchronization project should be activated ( -A ) if you do a schema update.

Synchronization Editor Command Line Interface V9.2.0.0
c 2023 One Identity LLC. All rights reserved.

Usage:

SynchronizationEditor.CLI.exe <Command> {<Options>} {<Parameter>}

SynchronizationEditor.CLI.exe (--CreateShell) {-(V|?|H)} [/Workspace=<Definition.xml>] {/SetParam <Name=Value>}

Examples:

SynchronizationEditor.CLI.exe --CreateShell -S /Workspace ActiveDirectory.sews

SynchronizationEditor.CLI.exe --CreateShell -S /Workspace ActiveDirectory.sews /SetParam UserName=<username> /SetParam Password=<password>

Options:

-A (Case sensitive) Activates the synchronization project subsequently.
                       Used by commands: UpdateSchema

-n                   Defines whether the CLI should operate non-interactively. That means parameter queries will fail.

-q                   Do not ask for confirmation of irreversible actions.

-r                   Defines whether the target system connection should be remoted using the remote access parameter provided in the sews-file.

-s                   Save results to database.

-?|h                 Displays this help.

-C (Case sensitive) Shrinks schemas subsequently.
                       Used by commands: UpdateSchema

-v                   Verbose mode.

Schema update and Schema shrink using SQL command

Top Replies