How in H2DB get sql dump like in MySql?

by

Yes, there are multiple solutions. One is to run the SCRIPT SQL statement:

SCRIPT TO 'fileName'

Another is to use the Script tool:

java org.h2.tools.Script -url <url> -user <user> -password <password>

Then, there are also the RUNSCRIPT statement and RunScript tool.

By the way, you should consider upgrading to a more recent version of H2. With newer versions, the two files .data.db and .index.db are combined in to a .h2.db file.

More Related Contents:

  1. How to find rows in one table that have no corresponding row in another table
  2. SQL query that gives distinct results that match multiple columns
  3. psql invalid command \N while restore sql
  4. Cumulative Total in MS Sql server [duplicate]
  5. Return number from Oracle Select statement after parsing date
  6. What does ON [PRIMARY] mean?
  7. Difference between View and table in sql
  8. Export table data from one SQL Server to another
  9. How do you interpret a query’s explain plan?
  10. How to make a view column NOT NULL
  11. oracle SQL how to remove time from date
  12. Which SQL statement is faster? (HAVING vs. WHERE…)
  13. Function with SQL query has no destination for result data
  14. SQL UPDATE TOP with ORDER BY?
  15. How do I create a table alias in MySQL
  16. How do I execute a MS SQL Server stored procedure in java/jsp, returning table data?
  17. LINQ to SQL query using “NOT IN”
  18. SQL can I have a “conditionally unique” constraint on a table?
  19. SUM total time in SQL Server [duplicate]
  20. Count consecutive duplicate values in SQL
  21. Crosstab with a large or undefined number of categories
  22. CONCAT equivalent in MS Access
  23. How to exclude a column from SELECT query?
  24. Truncate timestamp to arbitrary intervals
  25. MySQL: Get character-set of database or table or column?
  26. Conditional lead/lag function PostgreSQL?
  27. How to improve performance for datetime filtering in SQL Server?
  28. Re-order columns of table in Oracle
  29. can we have a foreign key which is not a primary key in any other table?
  30. Select latest row for each group from oracle

Leave a Comment