Validations for moving to Single Version

You must run the Database Validation and Prep Tool after you upgrade to DL 0 and before you run the Single Version Installer (SVI). Use the tool to identify and fix any problems that might cause the SVI to fail.

For a DL 0 database, the tool validates these areas:

• All SyteLine and third-party schema is present and correct as it existed when the DL 0 version of the application was created.
• Custom columns on SyteLine schema are either nullable or contain a default constraint.
• No additional constraints or unique indexes have been added to SyteLine tables or columns.
• The prerequisite database consolidation was performed so that the application, templates, forms, and objects databases are all in the same database.