changing databases

E

Elridge

I have developed an InfoPath form with a SQL Server database backend. I
would like to modify the form's Main Connection to point to a different
database (an exact replica in terms of database schema) for staging of the
form and then after staging move it again to a production database. Is there
a way to do this without breaking the binding for each control?
 
S

Scott L. Heim [MSFT]

Hi,

Yes - assuming you have installed Service Pack 1 for Office/InfoPath 2003.
If so, just complete these steps:

- Open your InfoPath solution in Design View
- From the Tools menu, choose "Convert Main Data Source"
- Complete the Wizard!

I hope this helps!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Top