Initial installation of the ENTERPRISE Variant : Installing IZYTRONIQ Backend : Installing the Database
Installing the Database
IZYTRONIQ BackEnd Database.msi
 
Description
This setup 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 in the following. These are used automatically if the corresponding parameter isn’t specifically configured during installation.
 
PRODUCT_LANGUAGE = de
BACKEND_SERVERNAME = localhost
BACKEND_DATABASE = IZYTRON.IQ
BACKEND_DATABASE_USERNAME =
BACKEND_DATABASE_USERPWD =
 
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 does not correspond to setup, 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 “IZYTRON.IQ.SyncSvc.exe.config” file is appropriately modified, the application server utilizes the correct database.
 
It’s advisable to determine whether or not the IZYTRONIQ database has been successfully created with the help of the MS SQL Management Studio.