org.h2.tools

Class Script

java.lang.Object

org.h2.util.Tool

org.h2.tools.Script

public class Script
extends Tool

Creates a SQL script file by extracting the schema and data of a database.

Field Summary

Fields inherited from class org.h2.util.Tool

out

Constructor Summary

Constructors

Constructor and Description
Script()

Method Summary

Methods

Modifier and Type	Method and Description
static void	execute(String url, String user, String password, OutputStream out) Backs up a database to a stream.
static void	execute(String url, String user, String password, String fileName) Backs up a database to a SQL script file.
static void	main(String... args) Options are case sensitive.
void	runTool(String... args) Run the tool with the given output stream and arguments.

Methods inherited from class org.h2.util.Tool

isOption, printNoDatabaseFilesFound, setOut, showUsage, throwUnsupportedOption

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Script

public Script()

Method Detail

main

public static void main(String... args)
                 throws SQLException

Options are case sensitive. Supported options are:

[-help] or [-?]	Print the list of options
[-url "<url>"]	The database URL (jdbc:...)
[-user <user>]	The user name (default: sa)
[-password <pwd>]	The password
[-script <file>]	The target script file name (default: backup.sql)
[-options ...]	A list of options (only for embedded H2, see SCRIPT)
[-quiet]	Do not print progress information

Parameters:

args - the command line arguments

Throws:

SQLException

runTool

public void runTool(String... args)
             throws SQLException

Description copied from class: Tool

Run the tool with the given output stream and arguments.

Specified by:

runTool in class Tool

Parameters:

args - the argument list

Throws:

SQLException

execute

public static void execute(String url,
           String user,
           String password,
           String fileName)
                    throws SQLException

Backs up a database to a SQL script file.

Parameters:

url - the database URL

user - the user name

password - the password

fileName - the script file

Throws:

SQLException

execute

public static void execute(String url,
           String user,
           String password,
           OutputStream out)
                    throws SQLException

Backs up a database to a stream. The stream is not closed.

Parameters:

url - the database URL

user - the user name

password - the password

out - the output stream

Throws:

SQLException