Mimer SQL on Windows
Server Type

This sets the type of the database server process. Different functionality will be available in the database server depending on this choice. The actual choices available depends on which edition of Mimer SQL is installed on the machine.

The server type may be one of:

Server type Description
Experience Advanced set of database server functionality in a multithreaded server. Both data manipulation (DML) and Data Definition Language (DDL) supported. In version 10.1 this server type does not support user defined types. Otherwise, it supports a more sophisticated version of SQL than an Engine server. This is detailed in the release notes.
Engine

Advanced set of database server functionality in a multithreaded server. This type of server supports user defined types and both DML and DDL. This type provides backward compatibility with earlier versions of the Mimer SQL database server.

Engine is not supported from version 11.0 and later. Use Experience instead.
Mobile Experience This is a small footprint multithreaded server that supports precompiled SQL statements and data manipulation statements. Data Definition statements are not available.
Mobile this is a small footprint multithreaded server that supports precompiled SQL statements only.
Micro This server type has a very small footprint. It only uses precompiled SQL statements in a single threaded server. This type of server is used when memory is a very limited resource.
Auto This is an in-memory server type with a very small footprint. It only uses precompiled SQL statements in a multi threaded server. The schema is decided by running the schema compiler on an Experience database server and creating a dynamic link library that holds the schema and statements in the Mimer SQL Auto server. The Mimer SQL Auto server also has realtime support.

 

See Also