Handling SQL identity columns - assure_mimix - 10.0

Assure MIMIX Administrator Reference

Product type
Software
Portfolio
Integrate
Product family
Assure
Product
Assure MIMIX™ Software
Version
10.0
Language
English
Product name
Assure MIMIX
Title
Assure MIMIX Administrator Reference
Copyright
2024
First publish date
1999
Last edition
2024-08-27
Last publish date
2024-08-27T12:04:03.662993

MIMIX replicates identity columns in SQL tables and checks for scenarios that can cause duplicate identity column values after switching and, if possible, prevents the problem from occurring. In some cases, identity columns will need to be processed by manually running the Set Identity Column Attribute (SETIDCOLA) command.

This command is useful for handling scenarios that would otherwise result in errors caused by duplicate identity column values when inserting rows into tables.