Installing the Database
File
IZYTRON.IQ BackEnd Database.msi
Description
This setup file installs the application server’s database.
MSI Package
The MSI package includes the following optional parameters, for which the respectively used default values are specified below. These are used automatically if the corresponding parameter isn’t specifically configured during installation.
PRODUCT_LANGUAGE=<server language; standard: de>
BACKEND_SERVERNAME = localhost
BACKEND_DATABASE=IZYTRON.IQ
BACKEND_DATABASE_USERNAME=<user name; standard: logged-on user>
BACKEND_DATABASE_USERPWD=<user password; standard: logged-on user>
The last two parameters are typically only required if the database to be set up will run on another server.
Example of configuration during installation:
msiexec /i "IZYTRON.IQ BackEnd Database.msi"
BACKEND_SERVERNAME=myserver\SQLEXPRESS
PRODUCT_LANGUAGE = en
BACKEND_DATABASE_USERNAME = johndoe
BACKEND_DATABASE_USERPWD = mypassword
In the example, the database for the English language is installed to the SQL server (“myserver”) with MS SQL instance SQLEXPRESS and user “johndoe” along with his password (“mypassword”) as “IZYTRON.IQ”.
Comments
– If the database already exists when setup is executed, it’s not deleted. If the version in the Database_Info table doesn’t correspond to the setup version, setup executes the corresponding update scripts in so far as an IZYTRONIQ database is involved.
– The database doesn’t necessarily have to be installed to the same server as the backend. If the connection string in the registry is appropriately modified, the application server utilizes the correct database. See
„Installing the Synchronization Service“ for details.
It’s advisable to determine whether or not the IZYTRONIQ database has been successfully created with the help of the Microsoft SQL Management Studio.