Creating a Data database

To create a Data database, you need the 'Create database' permission

Warning: Databases cannot be copied. Do not attempt to create or copy a database from within SQL Server as invalid references are likely to be created. All new databases must be created and registered via the System Management module (or through the API).

To create a new Data database, follow the steps below.

Select Database > Create Database or right click on the icon in the tree view. The Create New Database window is displayed.

SQL Server is the only available database option. Oracle databases are no longer supported.
If you are using remote data entry, choose to create either a server or site database. More info

Select a Server database if you are setting up a central Data database. Select a Site database if you are setting up a Data database at a remote site. You will also need to enter the site name.

For more information on setting up remote data entry, please see contact Customer Support.
Click OK.
In the new window, enter the connection values. There is a limit of 15 characters for the DB Alias.
When all the fields have been completed, click Test to test the connection.
If the connection tests successfully, click Create to create the database.

Note: You must register a new database before it can be used.

Writing a database creation script to file

This enables you to save the database creation script as a text (.txt) file. You may then open and edit the script to your own requirements at a later date.

After completing steps 1 - 4 above:

Check the Write DB creation script to file box and click OK.
Enter a name for the file and click OK.
The .txt file will be created in the application folder\Out Folder