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?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
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:
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.