search

AnantLabs / wwwsqldesigner

Automatically exported from code.google.com/p/wwwsqldesigner
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

SQL to XML possible? #4

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Hi Ondřej,
is it possible to create the XML schema file out of a sql file?
Simon

Original issue reported on code.google.com by pow...@gmx.de on 26 Jan 2009 at 10:53

GoogleCodeExporter commented 9 years ago 
Hi,
this could be done by writing the appropriate backend ("php-sqlfile" or similar 
name)
which reads and parses the SQL and produces relevant xml file. Unfortunately, 
as SQL
is not a xml dialect, this transformation cannot be done via XSLT means.

Original comment by ondrej.zara on 27 Jan 2009 at 6:53

GoogleCodeExporter commented 9 years ago

Original comment by ondrej.zara on 5 Feb 2009 at 10:37

GoogleCodeExporter commented 9 years ago 
Thanks for your answer, I was not sure if the js does this already. 

There are two PEAR packages which could do it in PHP. But I didnt tested them 
yet:

http://pear.php.net/package/XML_Query2XML
http://pear.php.net/package/XML_sql2xml

Original comment by pow...@gmx.de on 5 Feb 2009 at 10:42

GoogleCodeExporter commented 9 years ago 
How do I import a DB from PostgreSQL?

Original comment by widipa@gmail.com on 8 Sep 2009 at 4:47

GoogleCodeExporter commented 9 years ago 
This is not possible ATM. Someone has to create an import-capable postgresql 
backend.

Original comment by ondrej.zara on 8 Sep 2009 at 1:38

GoogleCodeExporter commented 9 years ago 
Having clearer docs on how this is done would be benificial. As far as I've 
understood, you need to set up wwwsqldesigner on your own machine, make a 
database, and then import from that.

Original comment by odin.om...@gmail.com on 13 Sep 2012 at 9:15