Create a Database

Once you have installed Mimer SQL Mobile, you are ready to create the database you will export to and use on your device.

To create a database:

1. If not already started, start the Mimer Administrator, located in the Mimer SQL Mobile program group.

   
   
   

2. Select the Local tab, click Add to create a database. The Local Database Definition dialog box opens.
3. Enter the name of the database and the directory on your workstation where you want to create the database. Click OK.
4. The Mimer Administrator asks if you want to create system databanks. In the Create Systems dialog box, click Yes. Complete the system databanks wizard.

   Note: When asked for a SYSADM password, ensure that you have selected the Mimer SQL Mobile System Databank option. This will give you a smaller system databank.

   Note: Remember the SYSADM password! If you lose the SYSADM password, it cannot be retrieved from your Mimer SQL Mobile system.

5. When the system databank creation is complete, the wizard asks you what you want to do next. Select the options to start the database server and create a development user and development environment, click Finish.
6. The Example Environment Setup wizard starts. Select both available options and complete the wizard to create a development user and example environment.

   You now have a Mimer SQL Mobile database server running on your workstation.