0045 User Columns

0045 User Columns

Migration Path

• INFORMATION_SCHEMA.COLUMNS -> AssetDefinition
• INFORMATION_SCHEMA.COLUMNS -> EventDefinition
• < CUSTOM USER TABLES > -> < CORRESPONDING ASSET TABLE >

Data Considerations

• Duplicates
• Null Data Replacement - See SQL

Other Notes

• The user column migration is a complex dynamic sql script that reads information about user tables from database metadata (ie. USRBRDGE, USRINSP, etc) and moved those columns to the corresponding asset table in BrM 7.x and then migrated the data to the same. It is not recommended to try and modify this script.
• DATA CONVERSION NOTES
  • FLOAT types will be converted to NUMBER(28,16) OR NUMERIC(28,16) which may round the original data to 16 decimal places.
  • DECIMAL types will convert to NUMBER or NUMERIC
  • SMALLINT will convert to INT
  • MONEY will convert to NUMERIC (19,4)