Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If I make a LibreOffice Base database in its native ODB format, is it possible to later migrate the database to a SQL server such as PostgreSQL??? If so, how?


share|improve this question
up vote 2 down vote accepted

The quick and expensive way is to use RazorSQL, which costs $70, though you can use the free trial if you only need it once. Alternately you can use the SQL window with the command:

SCRIPT 'file.sql'

You'll get SQL that you can play back into your favorite DBMS. You'll probably need to remove various HSQL-specific bits: The collation and DBA user lines at the top, the SA lines & set write_delay at the bottom, the cached from CREATE CACHED TABLE, incompatible names, etc. Oh, and add a semicolon after every statement.

There are various ways to export data to CSV, but export to SQL is almost always preferable if you're going to import it back in to another RDBMS.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .