Hi Liam,
Yes, C# supports JDBC and I am trying to connect it to the basex database using following codes. But it doesn't work. I guess, my database name is not correct.
String Connection = "jdbc:sqlserver://localhost;databaseName=basexbatabase;integratedSecurity=true;"
Any suggestions? Thanks - Raj
-----Original Message----- From: Liam R. E. Quin [mailto:liam@w3.org] Sent: Wednesday, March 02, 2016 11:49 AM To: Bhander, Gurbakhash S. Bhander.Gurbakhash@epa.gov Cc: BaseX basex-talk@mailman.uni-konstanz.de Subject: 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
-- Liam R. E. Quin liam@w3.org The World Wide Web Consortium (W3C)