Create Databases
Multi-Database Support is a feature available in the Square 9 Professional Edition as an option or as part of the core product offering in the Corporate Edition. With it you can create and run more than one GlobalSearch database repository.
- On the GlobalSearch toolbar, click on the Administration () icon.
- In the vertical Administration menu, select Databases. A list of the GlobalSearch databases will appear. The default database is
GetSmart
. - Click the Add () button to create a new database, if multi-database support is enabled.
- Enter a name (with no spaces) for the database in the New Database bar.
- For additional database settings, click Advanced.
- To change the database location from the default SQL server set at installation, choose one of the following:
- Enter the database server path in the Server bar.
- Click the Search () button and select from the list of database locations.
- Enter the database server path in the Server bar.
- Select Windows Authentication or SQL Authentication and enter your credentials as an administrator, if prompted.
- Click Save.
Considering Interoperability When Naming Databases
When naming a database, the name must have a maximum of 50 characters. Also, it is a good idea to avoid special characters (other than underscores or hyphens) or beginning the name with a numeral. By doing so, the database will better allow smooth interoperability with optional Square 9 modules such as GlobalForms, and with external systems such as line-of-business applications, should you want to implement an integration of this type.