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?
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
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.