If you cannot use the SETIDCOLA command because of its known limitations, you have these options.
Manually reset the identity column starting point: Following a switch to the backup system, you can manually reset the restart value for tables with identity columns. The SQL statement ALTER TABLE
name
ALTER COLUMN
can be used for this purpose.
Convert to SQL sequence objects: To overcome the limitations of identity column switching and to avoid the need to use the SETIDCOLA command, SQL sequence objects can be used instead of identity columns. Sequence objects are implemented using a data area which can be replicated by MIMIX. The data area for the sequence object must be configured for replication through the user journal (cooperatively processed).