Remediation tasks

These are the problem areas that the tool attempts to fix during the Remediate phase:

• Fix option:
  • Alter incorrect columns
  • Add missing or fix incorrect constraints (check, default, foreign key, primary key and unique).
  • Add missing or fix incorrect indexes.
  • Add missing or fix incorrect data types.
  • Add missing views (only for table-generated views).
• Drop option:
  • Drop unapproved constraints
  • Drop unapproved indexes.
  • Drop unapproved stored procedures, functions, triggers, views, or assemblies (only for a “current” database).
• Rename option: Rename unapproved tables and columns. This option is valid only for a “current” database. (For DL0, this option is disabled; in that case, unapproved tables and columns result in failed validation and must be corrected manually.)
  • Tables are renamed to include the AccessAs prefix defined in the manifest (ue_ for SyteLine). For example, the table named mytable would be renamed ue_mytable.
  • For a “current” database, unapproved columns are renamed to include the AccessAs prefix defined in the manifest (ue_ for SyteLine). For example, the column named mycol would be renamed ue_mycol.