Package org.h2.tools
Class Script
java.lang.Object
org.h2.util.Tool
org.h2.tools.Script
public class Script
extends org.h2.util.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 -
Method Summary
Modifier and TypeMethodDescriptionstatic voidOptions are case sensitive.static voidprocess(String url, String user, String password, String fileName, String options1, String options2) Backs up a database to a stream.static voidprocess(Connection conn, String fileName, String options1, String options2) Backs up a database to a stream.voidRun the tool with the given output stream and arguments.Methods inherited from class org.h2.util.Tool
getMainClassName, isOption, printNoDatabaseFilesFound, setOut, showUsage, showUsageAndThrowUnsupportedOption, throwUnsupportedOption
-
Constructor Details
-
Script
public Script()
-
-
Method Details
-
main
Options are case sensitive.Supported options [-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- on failure
-
runTool
Description copied from class:org.h2.util.ToolRun the tool with the given output stream and arguments.- Specified by:
runToolin classorg.h2.util.Tool- Parameters:
args- the argument list- Throws:
SQLException- on failure
-
process
public static void process(String url, String user, String password, String fileName, String options1, String options2) throws SQLException Backs up a database to a stream.- Parameters:
url- the database URLuser- the user namepassword- the passwordfileName- the target file nameoptions1- the options before the file name (may be an empty string)options2- the options after the file name (may be an empty string)- Throws:
SQLException- on failure
-
process
public static void process(Connection conn, String fileName, String options1, String options2) throws SQLException Backs up a database to a stream. The stream is not closed. The connection is not closed.- Parameters:
conn- the connectionfileName- the target file nameoptions1- the options before the file nameoptions2- the options after the file name- Throws:
SQLException- on failure
-