Re: [basex-talk] Export database to SQL?

On Wed, 2016-03-02 at 16:24 +0000, Bhander, Gurbakhash S. wrote:

Hi,

Is there any way to export data from the database to other databases?

There are several ways. But note that there's not a 1:1 mapping between relational data and XML, so you first have to choose how you will represent your information in the relational database.

After that, if it's simple unstructured values (e.g. no mixed content) you might write out CSV as text using XQuery, or use the BaseX SQL Module [1] to connect directly to the other database if it supports JDBC.

Liam

[1] http://docs.basex.org/wiki/SQL_Module