Storing Data as XML BLOB

Posted by NBrowne on Stack Overflow See other posts from Stack Overflow or by NBrowne
Published on 2010-09-28T08:56:45Z Indexed on 2010/12/24 9:54 UTC
Read the original article Hit count: 198

Filed under:
|
|

Hi,

At the moment the team i am working with is looking into the possibility of storing data which is entered by users from a series of input wizard screens as an XML blob in the database. the main reason for this being that i would like to write the input wizard as a component which can be brought into a number of systems without having to bring with it a large table structure.

To try to clarify if the wizard has 100 input fields (for example) then if i go with the normal relational db structure then their will be a 1 to 1 relationship so will have 100 columns in database. So to get this working in another system will have to bring the tables,strore procedures etc into the new system.

I have a number of reservations about this but i would like peoples opinions??

thanks

© Stack Overflow or respective owner

Related posts about sql

Related posts about Xml