Database

The Database node contains a selection of tools for working with and manipulating the solution database – available to Administrator users only.

Please backup your database before using any of these tools.

If you don’t have access to your database or don’t know how to back it up, don’t use the tools.

The Search & Replace tool lets you select a database, a table and a field – then search for and replace values therein (Figure 2.1).

Use Find to find all records matching a value, then Replace all to replace all values found with the content in the Replace with field.

Figure 2.1 The Search & Replace tool

The SQL Firehose tool is a tool for executing SQL statements against your database (Figure 3.1). SQL Firehose is a full SQL client, and supports all SQL operations.

SQL Firehose is only available for Administrators (not Admins) and angel users.

Figure 3.1 The SQL Firehose tool

Using the Setup node you can change database connection configuration or add an alternative database connection to the solution (Figure 4.1).

Figure 4.1 The Database setup options

The Indexes node provides a user with the rigt permissions (db_owner) with the ability to rebuild the SQL indexes of the solution database (Figure 5.1).

Figure 5.1 Rebuilding SQL indexes