Database

MobiControl uses a database to store configuration information and files that need to be accessed by MobiControl components. MobiControl can store configuration information and files (such as package files that are to be deployed, as well as other files) in an existing database server or can use a free Microsoft SQL Server database (e.g. MSDE) included with MobiControl.

MSDE is the Microsoft SQL Server 2000 database engine, without any UI tools, and with some limitations in the database size (i.e. maximum of 2 GB for data storage) and the number of connections. MSDE is a good, affordable starting database to use with MobiControl. If the number of mobile devices you are managing with MobiControl grows beyond the capabilities of MSDE, you can easily upgrade to a full Microsoft SQL Server database. Our testing results show that MSDE performs well for MobiControl sites that are managing up to 500 devices.

Microsoft SQL Server 2005 Express Edition is also a free database engine, however, unlike MSDE, it provides some basic UI tools and does not have as many performance limitations. Our testing results show that Microsoft SQL Server 2005 Express Edition performs well for MobiControl sites that are managing up to 1000 devices.

MobiControl currently supports the following databases:

• Microsoft SQL Server 2005
• Microsoft SQL Server 2005 Express Edition (optionally included with MobiControl)
• Microsoft SQL Server 2008
• Microsoft SQL Server 2008 Express Edition

Please see the Database Configuration page for detailed information about configuring MobiControl's database connection. Please see the Log Maintenance Options page to learn about incorporating automatic log maintenance features to your database.