Search This Blog

Thursday, August 23, 2007

XML to DDL Imports, Synchronizes Database Schemata

The Freshmeat project known as xml2ddl provides a set of Python
programs under the GNU General Public License (GPL). Given a working
Python runtime environment, this set of tools works on many operating
systems, including most Windows, Linux, and UNIX platforms. It also
works with the following database engines: PostgreSQL, MySQL, Oracle,
and Firebird. Basically, xml2ddl permits users to convert an XML
representation of a database into a corresponding set of SQL or DDL
statements. According to its creator and custodian, Scott Kirkwood,
"XML to DDL strives to be database independent so that the same XML
can be used for a variety of databases. This is great for quickly
testing out a variety of databases for performance, for example".
Project description: XML to DDL is a set of Python programs that
converts an XML representation of a database into a set of SQL or DDL
(Data Definition Language) commands. In addition, it can examine the
difference between two XML files and output a sequence of SQL statements
(normally ALTER statements) to bring one database up-to-date with the
XML schema. You can also download the XML schema directly from the
database. Finally, there's a tool to convert your schema into HTML for
documentation purposes. XML to DDL currently supports the most recent
versions of PostgreSQL, MySQL, Oracle, and Firebird databases."

Further Information

2 comments:

michael-adamssmith said...

Excellent post dear blogger, I would like to read more entries at home, so I will save this link.

michael-adamssmith said...

Really cool blog brother. I've been coming here for quite some time, but I've never commented before. This blog is a constant inspiration like Buy Viagra Thanks for sharing so much.