SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How do I set a "always-sync" connection between a Form Library and a Database (in SQL server 2008)?

I have a Form library that use InfoPath form. In the form library, there are multiple columns (or fields) and contain data. I also have a database inside SQL Server 2008. So, the question is how can I set in such a way that any data changes to form library will be reflect in the database and vice-versa. (Meaning that data in the form library will always be the same as the data in the database.)

For info: using MOSS 2007, SQL Server 2008

share|improve this question
up vote 0 down vote accepted

After some research, I found that it is not possible to perform a "always-sync" connection between a form library and a database (in SQL Server 2008).

The only other way is using the SQL Server Replication provided you know the Form Library table located in the SQL server and then perform a replication between that table to another table in the SQL server.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.