Execute SQL When You Start a Server

You can configure a SQLFire server or peer to execute SQL scripts during its boot process. You can also use configuration and initialization scripts as an alternative to data dictionary persistence.

You specify SQL scripts using the following startup arguments, which determine when the server executes the script:

To use configuration and initialization scripts as an alternative to data dictionary persistence, ensure that the first peer or server that you start in the cluster uses configuration scripts to execute the required DDL for your application. All other peers and servers can then use initialization scripts to finish executing dependent DDL and to populate your schema with data.