SQL Server Requirements
A SQL Server table should have a primary key defined to ensure rows can be identified uniquely. The preferred mechanism is to define the primary key column as IDENTITY.
-
If the primary key column has an IDENTITY specification, it will be used for ID generation
-
If the primary key does not have an IDENTITY specification then
For a numeric primary key Bentley Map will query for the maximum value and increment that by one when adding a new record
For other column types Bentley Map will attempt to store the UUID that XFM uses internally.
It is preferred that the table contain rows of like data type.