Document toolboxDocument toolbox

SQLServer

Ensure that there are two SQL Server databases in the same SQL Server instance, one for ServiceScheduling and one for ServiceSWAT.

Ensure that the properties file is edited to include these database names. Two parameters are included “dbname” and “swatdname” for ServiceScheduling and ServiceSWAT respectively.

 

Run <installation directory>\webapps\ServiceSWAT\database\SWAT-runall-Once.bat as an administrative user.

          SWAT-runall-Once.bat <swat-db-name> <Machine Host Name\SQL Server Instance> <scheduling-db-name> <username> <password>

          SWAT-runall-Once.bat swat STOC-W7-64-1\STOCW7 scheduling testDBuser test