Rules

Secret ingredients to quality software

Do you have invalid DefaultValue and ValidationRule properties (Upsizing problem)?

Last updated by SSW.Rules.SharePointExtractor on 22 Feb 2021 02:04 am (9 months ago) See History

When you upsize a table, the Upsizing Wizard tries to "map" Visual Basic for Applications functions in your DefaultValue and ValidationRule properties to an equivalent TSQL function. If this attempt is not successful, the validation rule or default will be skipped by the Upsizing Wizard. Consider the following:

  • If the Upsizing Wizard fails to map a function in a field's ValidationRule property, only the validation rule is skipped, and the rest of the table is upsized.
  • If the Upsizing Wizard fails to map a function in a field's DefaultValue property, the entire table is skipped.
  • Access 2000: Validation rules are not upsized
Upsizing PRO will check this rule
Adam CoganAdam Cogan

We open source. Powered by GitHub