Prepare SQL tables

SQL database tables must be created or updated.

Login to SQL Server and locate the required SQL:

• Requires a SQL login account with table update permissions; for example:

• Select   File  >  Open  >  File...   and navigate to the following directory,

such as:   .\SYSPRO?\BASE\scripts  in the following example:

• If this is a first time Cadacus Solutions installation for this company, select EDITables.sql;  

otherwise, select  EDIUpdate.sql

Execute the SQL for each required company, as in the following example: