#361 How to export one or more table's structure with / without data?

[Abid Maqbool]

As in official docs of HSQLdb, e.g. http://hsqldb.org/doc/2.0/guide/guide.html

We have some options for export and imports of database.

I have a question! How to export and import only tables' structure with / without data?

To export just data

<export script table statement> ::= PERFORM EXPORT SCRIPT FOR TABLE <table name> DATA [WITH COLUMN NAMES] TO <single-quouted file path>

More over tables, triggera and other things can be sync, how?

Basically have two hsqldb database one at local pc and second on internet (VPS hosing). What is better why to sync both database (database structure and data). Data and structure can be changed o both servers.

[Fred Toussi]

The PERFORM EXPORT SCRIPT FOR DATABASE STRUCTURE exports all the definitions without the data.

For your usage you need a separate product such as FlywayDB.org to manage the synchronisation.