InfoPath Dev

Hi, I have developed an IP2003 form with a SQL DB at the background. Now, we are planning to move the database to a different server (a production environment). My question is, when the DB is moved, I will surely need to change the data connections to point to the new DB.. right? Won't that screw up all the validations on the fields? That would essentially mean that the form needs to be redone. Isn't it? Is there a way to avoid that? Thanks!

Hi --

As long as everything except the server will be the same (database name, table / view names, etc), you can save your form as source files and then, in manifest.xsf you can change the data connections to point to the new server.

Make a backup copy first!

So, if the DB name changes then will I not be able to save the form? Also, once I save the sources, how can I rebuild the .xsn for publishing? Many thanks!

Well, the DB name is used in the data tree.... so XPaths will change.

To rebuild the .xsn, simply use File --> Save As and save as an .xsn. This repacks up your template files.