General Category > BeerXML Projects

Beer XML > SQL >Beer XML

(1/2) > >>

g0mikese:
I'm working on a website where I hope to import Beer XML files into an SQL database, and then have the capability of exporting those same database entries as Beer XML files. I've noticed that this site isn't exactly active recently so I figured I"d pop a word in and see if anyone has any handy links on importing XML files into an SQL database. I'm sure I'll find some stuff out there just fine, but figured anyone lurking on this site might have a bit of an interest in the project.

AntonW:
Hi,

Mapping from SQL to XML and from XML to SQL is a nontrivial task, and the transformations to move data back and forth isn't something that can be easily (or automatically) generated.  The only exception would be if your data model is extremely flat and BeerXML's data model is not flat.

-Anton

ps.  The rate of change has slowed down recently.  Hopefully we can get any loose ends with version 2.0 wrapped up soon.  If you find any problems let us know and we'll take a peek.

HankLynch:
If you go with SQL Server 2005, you can always make good use of an XML Data column.  That might work for you.

jvetter:
The XML Data column in SQL Server 2005 is actually quite nice, especially when using in conjunction with a schema. They have intergrated XML searching for the column that allows you to do XPATH like queries using SQL style SELECT statement (called XQuery i believe).

One BeerXML 2 is finalized, I plan to use it just like this to keep a collection of recipes and sessions on my brewery site.

Oud Schoten:
Is the site up and running ?

Navigation

[0] Message Index

[#] Next page