Back-end design question

I

Irene

We are in the process of converting several of our
Company's internal forms to InfoPath. We plan to
integrate them with BizTalk and use HWS. I'm trying to
weigh the pro's and cons of leaving the collected form
data in XML format or setting it all up in a SQL database
and storing the data collected there. Both options are
open.

We are new to this technology (InfoPath and BizTalk) so
I'd appreciate any feedback or ideas on best practices.

Thanks!

Irene
 
P

Patrick Halstead

relational databases are very powerful (reporting and analysis, transacted
with logging/backup, etc.), but it will take more work to integrate your XML
forms into it and do the deserialization from XML forms to SQL rowsets. the
good news is that you're starting from scratch which means you can design
your database tables and forms at the same time.
 
Top