Most tools are command line driven, but not all (for example the CSV tool).
| Modifier and Type | Interface and Description |
|---|---|
| public interface | SimpleRowSource
This interface is for classes that create rows on demand. |
| Modifier and Type | Class and Description |
|---|---|
| public class | Backup
Creates a backup of a database. |
| public class | ChangeFileEncryption
Allows changing the database file encryption password or algorithm. |
| public class | CompressTool
A tool to losslessly compress data, and expand the compressed data again. |
| public class | Console
Starts the H2 Console (web-) server, as well as the TCP and PG server. |
| public class | ConvertTraceFile
Converts a .trace.db file to a SQL script and Java source code. |
| public class | CreateCluster
Creates a cluster from a stand-alone database. |
| public class | Csv
A facility to read from and write to CSV (comma separated values) files. |
| public class | DeleteDbFiles
Deletes all files belonging to a database. |
| public class | GUIConsole
Console for environments with AWT support. |
| public class | MultiDimension
A tool to help an application execute multi-dimensional range queries. |
| public class | Recover
Helps recovering a corrupted database. |
| public class | Restore
Restores a H2 database by extracting the database files from a .zip file. |
| public class | RunScript
Runs a SQL script against a database. |
| public class | Script
Creates a SQL script file by extracting the schema and data of a database. |
| public class | Server
Starts the H2 Console (web-) server, TCP, and PG server. |
| public class | Shell
Interactive command line tool to access a database using JDBC. |
| public class | SimpleResultSet
This class is a simple result set and meta data implementation. |
| public abstract class | TriggerAdapter
An adapter for the trigger interface that allows to use the ResultSet interface instead of a row array. |
| public class | Upgrade
Upgrade utility. |