Microsoft
Version 12 of Mamut Business Software
is based on the Microsoft
If you choose the default single-user installation - meaning the program will only be used on one computer - this computer will act as the database server.
If you choose a multi-user installation, one of the computers within the network will act as the database server. If no previous installation can be detected on this server, the Microsoft SQL Server will be installed.
If you choose a client installation - through which you connect to a database server already available within the network - you will not be required to install Microsoft SQL Server when installing the Mamut Business Software program files.
Read more about Installing the Program
Read more about Network/Multi-user Installations
Instance
A database server can have several different instances. When installing Mamut Business Software, MAMUT will be suggested as the default instance name. You can enter a different instance name if you, already have access to an existing instance for example. In order to get a full overview of the systems, it is recommended that you create your own instance for the Mamut Business Software database.
The database server name will often consist of the server name + the instance name. An example of a database server can be: SERVERNAME\MAMUT.
Note! Instance name is only required if you will be running several SQL Servers on the same computer.
An instance can contain one or several databases. The Mamut Business Software database consists of one system database and one or several company databases.
Read more about Installed Files
System Database
The program's database consists of company database files and system files. The company database files contain data relevant for the various company databases while the system files contain data which is shared by all company databases. Shared information can, for example, include information about users and access information.
Company Database
A company database represents one set of accounting records. Where book-keeping agencies refer to "clients", other users handling several companies may view one company database as one company/organisation. It is possible to manage several company databases in a single program installation. The maximum number of company databases is determined by your licence.
Read more about Company Databases
Client Manager
Some program versions include Client Manager, which is a tool for managing several system databases. One system database - or one "installation" - can contain several company databases (companies/clients/sets of accounting records). For instance, accounting agencies, which handle a large number of clients, are the kind of users who require several system databases.
Read more about Client Manager
Database Maintenance
Maintenance tasks such as repairing, re-indexing, or compressing the database, are performed using a separate application called DataTools. DataTools is a tool for database administration, and supports the most common administrative tools for SQL Server-based databases. The application is automatically installed with the installation of Mamut Business Software, and can be launched by double-clicking the file MDataTools.exe. This is located in the DataTools folder, where the Mamut Business Software program files were installed. Example: C:\Program Files\Mamut\DataTools.
In addition to maintenance tasks, you can also able to create and restore backup copies using DataTools. More information can be found within the DataTools help files.
Read more about:
Creating a New Company Database