====== MS SQL Database ======

===== Overview =====

If you want to use MS SQL database instead of default PostgreSQL, you need to change the following modules in default installation:
  * AIM.war
  * proof-code-admin.war
  * proof-code-user.war 
  * proof-form-admin.war 
  * proof-form-user.war
  * aducid-useradmin.war
  * ADUCID.properties
All modified files (except ADUCID.properties, where you need to enter your MSSQL DB hostname) **are already prepared on distribution DVD** in the /root/mssql directory of the virtual machine.

===== List of modifications =====

==== AIM.war ====

In the directory /opt/tomcat/webapps/AIM/WEB-INF, the file spring-resources.xml_mssql has been renamed to spring-resources.xml

==== Other .war files ====

In the directory WEB-INF/lib, the file provider-shared-*.jar has been modified.

This file contains several files named dispatcher-servlet-provider-shared.xml*. 
The file dispatcher-servlet-provider-shared.xml_mssql was renamed to dispatcher-servlet-provider-shared.xml


==== ADUCID.properties ====

You need to change syntax of database specification (default is commented with #) 
<sxh bash>
#DB_AIM_NAME=aim
DB_AIM_NAME=//[hostname];databaseName=aim;
</sxh>

<sxh bash>
#DB_PROVIDER_NAME=provider
DB_PROVIDER_NAME=//[hostname];databaseName=provider;
</sxh>

[<>]