#
Server Installation
The Server Installation package provides all required resources for preparing the database server and also for preparing the client software to be used by PCs to be connected to the server.
The Server Installation program can be found in the executable file ServerSetup.exe. The installation program can be used on any PC that has a connection to the database server. It's not necessary to run the installation program directly on the server.
The installation process consists of two parts:
- Database Server Installation
- File Server Installation
#
Database Server Installation
After starting the installation program ServerSetup.exe you must provide the name of the server where the ZeeBORN Database Engine is installed on. With the Test button you can check if a connection can be established and if the server is ready for installation.
#
File Server Installation
As soon as the system will be used by more than one user, the configuration of a file server network share is mandatory. Using a file server instead of storing files directly in the database has major advantages regarding system performance but also removes the maximum file size limit of 20 MB per file attachment.
Any file server accessible via SMB network shares (Windows network shares) can be used. The file server (or a simple Windows PC or NAS) can be a different machine than the database server.
Please make sure that all users who will use the ZeeBORN software have read/write access to the network share.
If the file server was already defined during a previous installation of the software and will be changed during the installation of an update, the installation system takes care that all files previously stored in the old location will be copied to the new location.
#
Installation Procedure
The installation process can be started by clicking on the Install button.
During the installation process the installation program performs the following tasks:
- Uploading of database templates describing the required structure of database tables used by the ZeeBORN software.
- Checking of already available database tables against the uploaded database * templates and applying modifications to the already existing database tables, if necessary.
- Uploading of shared resources (e.g. report layouts used creating printouts).
- Uploading of the new client software to be used for updating all connected PCs.
The time required for the installation process highly depends on the amount of data already existing on the server and the number of changes to be applied to the existing data. If you a huge number of changes needs to be applied, it can take up to 30 minutes for installing the server resources.
#
Updates/Upgrades
If a newer version of the ZeeBORN software is released, just run the ServerSetup.exe of the new version and use the Upgrade command for performing an upgrade. The installation software automatically detects which previous version is installed on the database server and what tasks need to be executed for upgrading all involved components to the newest version.
#
Repair
If the setup program detects that the newest version is already installed on the server, you can still executed a Repair operation. Clicking on Repair will just re-upload all required resources to the server and will perform a database check if all database tables still have the required format. The Repair option won't delete any data that already exist on the server.
#
Command Line Parameters
The ServerSetup.exe can be started from the command line with additional parameters.
serversetup -auto -server dbserver:3306 will connect to server dbserver on port 3306, will check and prepare all database tables and upload the client components. If the current version is already installed, the setup will performm a check and repair of the database.
This option can be used for updating servers to a newer version, but can also be used for a fresh install.
The optional parameter -disconnect can be used for forcefully disconnecting all users that may still have an client application connected to the server. Users will see a related error message in the client application after being disconnected.