About using a different database

Studio uses a relational database to store configuration and state, such as component configuration, user permissions, and system settings.

By default, Studio uses Hypersonic (HSQL), which is an embedded database running inside the Java virtual machine. HSQL is useful for standing up a Studio instance very quickly, but must NOT be used in production due to performance issues and its inability to support clustered instances.

Note that Studio has been tested on MySQL and Oracle 11g. Other databases are expected to work but have not been explicitly tested.

Also, when migrating to a new database, make sure that the current data does not conflict with the new database's schema. For example, different databases may have different constraints for column sizes.